Question

Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do?
a. Add a calculated field to the table that uses the SUM function.
b. Add a total row and then choose Sum in the Order Amt column.
c. Add a total column and then choose Total to calculate all totals for the table.
d. Use the SUBTOTAL function at the bottom of the Order Amt column.

Answer 1

He should add a calculation field  to the table that use the SUM function.

Let understand that a spreadsheet perform various function such as calculation of the sum, subtraction of values on the sheet row and column.

• However, the columns and rows cells number and chronology must be duly noted to allow accurate summation of values.

• In order word, the cells number such as A12 - A29 should be noted if the values in Cell A12 to A29 needed to be calculated.

In conclusion, the answer cell can be situated below or besides the values to allow co-ordination on the spreadsheet.

Learn more about this here

brainly.com/question/12961162