3
RCMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 3 • Computer Applications - Office 2016 - EL3520 A

Which function is used to add a range of cells?

Answer
A
=SUM
B
=AVERAGE
C
=MAX
D
=ADD

Explanation

The SUM function adds the values in a range of cells. For example, =SUM(A1:A5) totals the numbers in cells A1 through A5. AVERAGE finds the mean, MAX returns the largest value, and ADD is not the standard spreadsheet function for totaling a range.

AI-written and checked against the verified answer.

Previous
Next