DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Insert a formula that displays the number of Sales.
|
|
=COUNTIF
|
|
|
=COUNT
|
|
|
=COUNTA
|
|
|
=SUM
|
Explanation:
Detailed explanation-1: -Enter “=sum(B1:B#)” in the next empty cell in the B column, and replace “#” with the row number of the last filled cell in column B. In the example, you would enter “=sum(B1:B2)” in cell B3 to calculate the total sales of the two items.
Detailed explanation-2: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
Detailed explanation-3: -The formula to calculate gross sales is Total Units Sold x Original Sale Price = Gross Sales.
There is 1 question to complete.