FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
A
sum function
B
count function
C
counta function
D
max function
Explanation: 

Detailed explanation-1: -The COUNTA function counts the number of cells that are not empty in a range.

Detailed explanation-2: -The CountA function counts the number of records that aren’t blank in a single-column table. This function includes empty text ("") in the count. The CountIf function counts the number of records in a table that are true for a logical formula.

Detailed explanation-3: -Excel COUNTIF function is used for counting cells within a specified range that meet a certain criterion, or condition. For example, you can write a COUNTIF formula to find out how many cells in your worksheet contain a number greater than or less than the number you specify.

Detailed explanation-4: -=COUNTA(value1, [value2], …) The Excel countif not blank formula uses the following arguments: Value1 (required argument) – This is the value at which we evaluate the function. Value2 (optional argument) – Additional arguments that represent the values that we wish to count.

Detailed explanation-5: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

There is 1 question to complete.