Case-Based Critical Thinking Questions
Case 1-2
Sam is a distributor of ceramics.He uses Excel 2010 to record his inventory and order forms.Sam's worksheet for his company's monthly orders needs to display summary information including total number of items ordered,and the amount of revenue generated from those orders.
-First Sam will add the number of orders.He chooses to use the ____ function from the AutoSum feature.
A) MAX
B) ADD
C) SUM
D) TOTAL

Question

Quizplus · Accepted Answer

The SUM function from the AutoSum feature is the best choice as it allows Sam to easily add up the values in a range of cells, which is what he needs to do to determine the total number of items ordered.