C268 Spreadsheets Practice Questions - Set 4 - Part 2

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

Question 21: A student tracks their daily study hours and grades in Excel. Which function calculates the correlation coefficient between these two variables?

a) =CORREL()

b) =COUNTIF()

c) =SUMIF()

d) =IF()

Question 22: A business wants to track sales performance for different products over time. Which Excel feature allows them to summarize sales data by product in a report?

a) PivotTable

b) Conditional Formatting

c) Data Validation

d) Solver

Question 23: A business wants to protect certain cells in a worksheet from being modified by other users. Which feature should they use?

a) Data Validation

b) Conditional Formatting

c) Protect Sheet

d) Filter

Question 24: A manager wants to calculate the payment required for a $10,000 loan over five years with monthly payments of $200. Which formula will return the correct result?

a) =FV()

b) =NPER()

c) =PMT()

d) =PV()

Question 25: A sales team wants to calculate the average sales for employees who met or exceeded their monthly sales target of $5,000. Which formula will accomplish this?

a) =AVERAGEIF(A1:A10,">=5000")

b) =COUNTIF(A1:A10,">=5000")

c) =SUMIF(A1:A10,">=5000")

d) =IF(A1>5000)

Question 26: A store wants to display the total sales for items that sold at least 300 units. Which formula should they use?

a) =SUMIF(A1:A10,">=300")

b) =COUNTIF(A1:A10,">=300")

c) =IF(B1>=300)

d) =AVERAGEIF(A1:A10,">=300")

Question 27: A client wants to calculate the maximum amount they can borrow with $200 monthly payments for 3 years at a 5% interest rate. Which function will help them determine this?

a) =PV()

b) =FV()

c) =NPER()

d) =PMT()

Question 28: Which function will calculate the number of payments required to pay off a loan if the loan amount is $8,000 with monthly payments of $250 and an interest rate of 6%?

a) =NPER()

b) =PV()

c) =PMT()

d) =FV()

Question 29: A sales manager wants to calculate the percentage of sales attributed to each salesperson. Which formula will calculate this if the product’s sales are in A1 and the total sales are in B1?

a) =A1/B1

b) =SUM(A1:B1)

c) =IF(A1>B1)

d) =COUNT(A1:B1)

Question 30: A team tracks their performance against monthly targets. Which Excel feature would help display whether each employee met their target in a visual way?

a) Conditional Formatting

b) Slicer

c) Filter

d) Data Validation

Question 31: A user wants to display the number of unique entries in a dataset. Which function should they use?

a) =COUNTIF()

b) =SUMIF()

c) =COUNTA()

d) =COUNT()

Question 32: Which formula will return the current date in Excel?

a) =DATE()

b) =NOW()

c) =TODAY()

d) =TIME()

Question 33: A doctor wants to calculate the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?

a) =A1/B1

b) =B1/A1

c) =SUM(A1,B1)

d) =IF(A1>B1)

Question 34: Which feature in Excel allows users to prevent specific cells from being modified?

a) Data Validation

b) Protect Sheet

c) Conditional Formatting

d) Filter

Question 35: A manager wants to calculate the gross profit for a product if the sales amount is in C5 and the cost of goods sold is in C6. Which formula will return the correct result?

a) =SUM(C5,C6)

b) =C5-C6

c) =IF(C5>C6)

d) =COUNT(C5,C6)

Question 36: A doctor wants to track the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?

a) =A1/B1

b) =B1/A1

c) =SUM(A1,B1)

d) =IF(A1>B1)

Question 37: Which feature in Excel allows users to highlight cells that contain values meeting specific criteria, such as sales below a certain threshold?

a) Conditional Formatting

b) Data Validation

c) Filter

d) Slicer

Question 38: Which function will calculate the number of payments required to pay off a loan if the loan amount is $8,000 with monthly payments of $250 and an interest rate of 6%?

a) =NPER()

b) =PV()

c) =PMT()

d) =FV()

Question 39: A sales manager wants to calculate the percentage of sales attributed to each salesperson. Which formula will calculate this if the product’s sales are in A1 and the total sales are in B1?

a) =A1/B1

b) =SUM(A1:B1)

c) =IF(A1>B1)

d) =COUNT(A1:B1)

Question 40: A manager wants to calculate the total commission for a salesperson if the sales amount is in C5 and the commission rate is in C6. Which formula will return the correct result?

a) =C5*C6

b) =SUM(C5,C6)

c) =IF(C5>C6)

d) =AVERAGE(C5,C6)

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass

Get Exam Support