C268 Practice Questions | WGU Study Guide

Question 41: A company wants to prevent users from entering incorrect data into a specific cell. Which Excel feature should they use?

a) Data Validation

b) Conditional Formatting

c) Filter

d) Protect Sheet

Question 42: A manager needs to calculate the total commissions paid to sales representatives based on the sales amount in column B and the commission rate in column C. Which formula will calculate the total commission for a salesperson?

a) =B5*C5

b) =SUM(B5,C5)

c) =IF(B5>C5)

d) =AVERAGE(B5,C5)

Question 43: A business wants to summarize monthly sales data for each product in a report. Which Excel feature allows them to organize and filter this data by product?

a) PivotTable

b) Slicer

c) Filter

d) Conditional Formatting

Question 44: A financial analyst needs to forecast future sales based on past performance. Which function should they use?

a) =CORREL()

b) =FORECAST()

c) =NPER()

d) =PMT()

Question 45: Which formula will return "Yes" if a value in cell A1 is greater than 50 and "No" if it is less than or equal to 50?

a) =IF(A1>50,"Yes","No")

b) =IF(A1<50,"Yes","No")

c) =IF(A1=50,"Yes","No")

d) =A1>50

Question 46: A store owner wants to calculate the total number of items sold for each product. Which Excel feature will allow them to summarize the sales data in a report?

a) PivotTable

b) Data Validation

c) Conditional Formatting

d) Slicer

Question 47: A user needs to calculate the total sales for each region in a report. Which feature in Excel allows them to filter the data by region?

a) Slicer

b) Conditional Formatting

c) Filter

d) Data Validation

Question 48: A client wants to calculate how much money they will have after making monthly savings deposits for 10 years with an interest rate of 3%. Which Excel function should they use?

a) =FV()

b) =PV()

c) =PMT()

d) =NPV()

Question 49: A manager needs to calculate the total number of orders that exceeded $1,000 in value. Which function should they use?

a) =COUNTIF()

b) =SUMIF()

c) =AVERAGEIF()

d) =IF()

Question 50: A user wants to calculate the total revenue for each product in a table, based on the product’s price and the number of units sold. Which formula will provide the correct result?

a) =B1*C1

b) =SUM(B1,C1)

c) =IF(B1>C1)

d) =AVERAGE(B1,C1)

C268 Spreadsheets Practice Questions - Set 5 - Part 3

Question 41: A company wants to prevent users from entering incorrect data into a specific cell. Which Excel feature should they use?

Question 42: A manager needs to calculate the total commissions paid to sales representatives based on the sales amount in column B and the commission rate in column C. Which formula will calculate the total commission for a salesperson?

Question 43: A business wants to summarize monthly sales data for each product in a report. Which Excel feature allows them to organize and filter this data by product?

Question 44: A financial analyst needs to forecast future sales based on past performance. Which function should they use?

Question 45: Which formula will return "Yes" if a value in cell A1 is greater than 50 and "No" if it is less than or equal to 50?

Question 46: A store owner wants to calculate the total number of items sold for each product. Which Excel feature will allow them to summarize the sales data in a report?

Question 47: A user needs to calculate the total sales for each region in a report. Which feature in Excel allows them to filter the data by region?

Question 48: A client wants to calculate how much money they will have after making monthly savings deposits for 10 years with an interest rate of 3%. Which Excel function should they use?

Question 49: A manager needs to calculate the total number of orders that exceeded $1,000 in value. Which function should they use?

Question 50: A user wants to calculate the total revenue for each product in a table, based on the product’s price and the number of units sold. Which formula will provide the correct result?

Struggling With Exams?