DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoSum
|
|
|
SUBTOTAL
|
|
|
MAX
|
|
|
MIN
|
Detailed explanation-1: -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. Select the blank cell in the row below the cells that you want to sum, cell A5 in this example.
Detailed explanation-2: -So, for example, =SUBTOTAL(9, A1:A10) will give us the sum of all values in A1:A10, provided none are filtered(more on this filtering thing below). That is because “9” stands for SUM in SUBTOTAL lingo. If you want a count of values, you can use “2”.
Detailed explanation-3: -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.