C268 Practice Questions | WGU Study Guide

Question 41: Which function calculates the number of products sold based on the sales data in cells A1 through A10?

a) =COUNT(A1:A10)

b) =SUM(A1:A10)

c) =AVERAGE(A1:A10)

d) =IF(A1>0)

Question 42: A client wants to calculate the monthly payment for a loan. Which Excel function should they use?

a) =PMT()

b) =FV()

c) =PV()

d) =NPER()

Question 43: A store wants to count the number of items sold that cost more than $50. Which function should they use?

a) =COUNTIF(A1:A10,">50")

b) =SUMIF(A1:A10,">50")

c) =IF(A1>50)

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

Question 44: A user wants to calculate the number of months it will take to pay off a loan of $20,000 with monthly payments of $500. Which function will return the correct result?

a) =NPER()

b) =PV()

c) =PMT()

d) =FV()

Question 45: 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) Protect Sheet

c) Conditional Formatting

d) Filter

Question 46: 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 47: Which Excel function calculates the total value of sales based on specific criteria, such as sales greater than $1,000?

a) =SUMIF()

b) =COUNTIF()

c) =AVERAGEIF()

d) =IF()

Question 48: A manager wants to calculate the total commissions paid to sales representatives if the commission percentage is stored in cell B5 and the sales amount is in B6. Which formula will return the correct result?

a) =B6*B5

b) =SUM(B6,B5)

c) =B6/B5

d) =AVERAGE(B6,B5)

Question 49: A user wants to calculate the difference between two dates in terms of days. Which function should they use?

a) =DAYS()

b) =DATE()

c) =DAY()

d) =TODAY()

Question 50: A manager wants to calculate the total salary expenses for a project based on the number of employees required and the salary per employee. Which formula will return the correct result?

a) =C5*C6

b) =SUM(C5,C6)