Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
-Samantha will add the number of orders.She chooses to use the ____ function from the AutoSum feature.
A)MAX
B)ADD
C)SUM
D)TOTAL

Question

Quizplus · Accepted Answer

The SUM function is the best choice as it will add up all the values in the selected range and provide the total number of items ordered, which is what Samantha needs to display in her worksheet. The MAX function will only return the largest value in the range, which is not relevant in this case. ADD and TOTAL are not valid functions in Excel.

Samantha Is a Distributor of Jewelry