USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
COUNTA
|
|
|
MIN
|
|
|
MAX
|
Detailed explanation-1: -The COUNTA function counts the number of cells that are not empty in a range.
Detailed explanation-2: -Count nonblank cells in a range by using the COUNTA function Use the COUNTA function function to count only cells in a range that contain values.
Detailed explanation-3: -Use the COUNTA function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you.
Detailed explanation-4: -The COUNTA function is a premade function in Excel, which counts all cells in a range that has values, both numbers and letters.
Detailed explanation-5: -Select a blank cell and type the =COUNTA function including the range of cells that you want to count. For example, we used =COUNTA(A2:A11). Just hit enter, and the COUNTA function will automatically count the cells that are not blank. You now have the total number of cells that have values in it!