Computer Science Ques 604

Question: The most common subtotal used Subtotals command is the ___function, which causes Excel to display a sum each lime the control field change.

Options:

A) ADD

B) SUM

C) TOTAL

D) LIST

E) None of these

Show Answer

Answer:

Correct Answer: B

Solution:

  • The SUM function in excel takes all of the values in each of the specified cells and totals (hen-values. The syntax is= SUM (first value, second value. etc).You can enter constant, cell, Range of cells in the above SUM formula.