C268 Spreadsheets Practice Questions - Set 3 - Part 3

Test your knowledge of Spreadsheets concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 41: Which function calculates the number of payments required to pay off a $15,000 loan with monthly payments of $300 and an interest rate of 4%?

a) =PV()

b) =NPER()

c) =PMT()

d) =FV()

Question 42: Which Excel function returns the rightmost 10 digits from a text string in cell A1?

a) =LEFT(A1,10)

b) =RIGHT(A1,10)

c) =MID(A1,10)

d) =TEXT(A1,10)

Question 43: A sales manager wants to identify which sales representatives have met their monthly sales targets. Which formula would return "Met Target" if the value in cell B2 is greater than or equal to 10,000 and "Missed Target" otherwise?

a) =IF(B2>10000,"Met Target","Missed Target")

b) =IF(B2>=10000,"Met Target","Missed Target")

c) =IF(B2<10000,"Met Target","Missed Target")

d) =IF(B2>=10000,"Missed Target","Met Target")

Question 44: A business owner tracks sales for multiple products and wants to calculate the total for products that sold more than 50 units. Which formula should be used?

a) =COUNTIF(B1:B10,">50")

b) =SUMIF(B1:B10,">50")

c) =IF(B1>50)

d) =AVERAGEIF(B1:B10,">50")

Question 45: Which function will calculate the percentage of total sales for each product in a table, based on the product's sales value divided by the total sales?

a) =SUM()

b) =IF()

c) =COUNTA()

d) =A1/SUM(A1:A5)

Question 46: Which feature allows you to protect a worksheet from being modified by other users?

a) Data Validation

b) Conditional Formatting

c) Protect Sheet

d) Trace Precedents

Question 47: An administrator needs to track changes made to an Excel workbook shared with multiple users. Which tool should they use to monitor updates?

a) Data Validation

b) Conditional Formatting

c) Track Changes

d) Trace Dependents

Question 48: A financial analyst needs to predict future sales based on past performance. Which function should be used to forecast the sales of a product?

a) =FORECAST()

b) =NPER()

c) =PMT()

d) =FV()

Question 49: Which Excel function will return the day portion of a date stored in cell B1?

a) =MONTH()

b) =YEAR()

c) =HOUR()

d) =DAY()

Question 50: A user needs to extract the month from a date value stored in cell B1. Which function should they use?

a) =MONTH()

b) =YEAR()

c) =HOUR()

d) =DAY()

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass

Get Exam Support