# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only thecells in that range that contain 100. What function should he use?
 A False B True C Either A or B D None of the above
Explanation:

Detailed explanation-1: -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-2: -Count how often a single value occurs by using the COUNTIF function. Use the COUNTIF function to count how many times a particular value appears in a range of cells.

Detailed explanation-3: -The COUNTIF function counts the number of cells within a range that meet the criteria entered.

Detailed explanation-4: -In Microsoft Excel, you can use the COUNTIF function to count cells that meet one criterion. Note: To count cells based on multiple criteria, use the Excel COUNTIFS function.

There is 1 question to complete.