DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Total number of cells containing data in the selected range
|
|
|
Total number of cells containing numbers in the selected range
|
|
|
Total number of cells containing text only in the selected range
|
|
|
Total number of cells containing the TRUE value specified in a logic test
|
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: -The COUNT function returns the total number of cells in the selected range that contain both text and numbers. The MAX function returns the total of all cells in the selected range. The MIN function returns the smallest value in a range of cells.
Detailed explanation-3: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done.
Detailed explanation-4: -Remarks. The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value.