# FUNDAMENTALS OF COMPUTER

## 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.
 A =COUNTIF B =COUNT C =COUNTA D =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.