USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Insert a function in cell B19 that calculates all sales from the Total column.
|
|
=AVERAGE
|
|
|
=AVERAGEIF
|
|
|
=SUM
|
|
|
=SUMIF
|
Explanation:
Detailed explanation-1: -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.
There is 1 question to complete.