USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
count function
|
|
|
counta function
|
|
|
max function
|
|
|
merged cells
|
Detailed explanation-1: -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.
Detailed explanation-2: -COUNTIFS applies criteria to cells across multiple ranges, and counts the number of times all criteria are met. This is the syntax of the COUNTIFS function.
Detailed explanation-3: -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. The COUNTA function does not count empty cells.
Detailed explanation-4: -COUNT function counts cells that contain only numbers, but COUNTA function counts cells that are not blank, including numbers. As Date and Time values are stored as serial numbers in Excel so these values are counted in both of these functions.