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: -COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.
Detailed explanation-2: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-3: -SUMIF Adds only the cells that meet specified criteria. Example: Add the order totals for only London sales. AVERAGEIF Averages only the cells that meet specified criteria. Example: Average the order totals for only London sales.
Detailed explanation-4: -SUMIF-Add values if a condition is met, such as adding up all purchases from one category. COUNTIF-Count up the number of items that meet a condition, such as counting the number of times a name appears in a list. AVERAGEIF-Conditionally average values; for instance, you could average your grades for only exams.