USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A
|
|
|
B
|
|
|
C
|
|
|
D
|
Detailed explanation-1: -Summary. COUNTIF is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, numbers, and text. The criteria used in COUNTIF supports logical operators (>, <, <>, =) and wildcards (*, ?) for partial matching.
Detailed explanation-2: -If you want to count logical values, text, or error values, use the COUNTA function. If you want to count only numbers that meet certain criteria, use the COUNTIF function or the COUNTIFS function.
Detailed explanation-3: -AVERAGEIF Averages only the cells that meet specified criteria. Example: Average the order totals for only London sales. COUNTIF Counts only the cells that meet specified criteria. Example: Count the number of orders for only London.