USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
add the numbers in cells C5 and C10
|
|
|
subtract the number in cell C5 from C10
|
|
|
add the numbers in the range from C5 to C10
|
|
|
will not work because it has an error
|
Detailed explanation-1: -You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Detailed explanation-2: -Here’s a formula that uses two cell ranges: =SUM(A2:A4, C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You’d press Enter to get the total of 39787. To create the formula: Type =SUM in a cell, followed by an opening parenthesis (.
Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.
Detailed explanation-4: -The basic syntax here is ‘=SUM(address of first cell:address of last cell)’. 2. You can also try the formula in the cell you want to enter the sum in ‘=C1+C2+C3+C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14’.