DATABASE FUNDAMENTALS
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 (Windows) or Return (Mac), and that’s it! When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -Click the table cell where you want your result. On the Layout tab next to the Table Design tab, select Formula. Check between the parentheses to make sure Word includes the cells you want in the sum. =SUM(ABOVE) adds the numbers in the column above the cell you’re in.
There is 1 question to complete.