Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do?
A) Add a total row and then choose Sum in the Order Amt column.
B) Add a calculated field to the table that uses the SUM function.
C) Use the SUBTOTAL function at the bottom of the Order Amt column.
D) Add a total column and then choose Total to calculate all totals for the table.
Correct Answer:
Verified
Q307: If you want to sort data first
Q308: In the formula =[SalesPrice]*.05, what do you
Q309: To use the SUBTOTAL function to calculate
Q310: Jin wants to insert a recommended PivotTable.
Q311: By default, table styles override the formatting
Q313: To count only records that match a
Q314: Which of the following is an unacceptable
Q315: To find every cell that satisfies the
Q316: Stacey filtered a table on the Product
Q317: Edwin wants to insert a PivotChart to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents