Question

1. Write the formula to calculate sum
and average of the cell range C2 to C30​

Answer 1

Explanation:

To create the formula:

Type =SUM in a cell, followed by an opening parenthesis (.

To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).

Type a comma (,) to separate the first argument from the next.

Type the second argument, C2:C3 (or drag to select the cells).

Type a closing parenthesis ), and then press Enter.

Each argument can be a range, a number, or single cell references, all separated by commas.

=SUM(A2:A4,2429,10482)

=SUM(4823,A3:A4,C2:C3)

=SUM(4823,12335,9718,C2:C3)

=SUM(A2,A3,A4,2429,10482)

Answer 2

Quick Grand Total for a range of cells

Select the range of cells, and the blank row below the range, and the blank cells in the column to the right (cells A1:D5 in the example below)

Click the AutoSum button on the Ribbon's Home tab. A SUM formula will be automatically entered for each Total.