USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average
|
|
|
Count
|
|
|
Max
|
|
|
Sum
|
Detailed explanation-1: -For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. 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.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
Detailed explanation-3: -Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-4: -Using the SUM function, you can also automatically total new values in a column as they are added and calculate the cumulative sum.