FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Functions from Ms. Excel that is used to calculate the sum of a set of data with the desired conditions is ____
A
COUNTIF
B
SUMIF
C
SUM
D
COUNT
Explanation: 

Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.

Detailed explanation-2: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

Detailed explanation-3: -The difference between COUNTIF and COUNTIFS is that COUNTIF is designed for counting cells with a single condition in one range, whereas COUNTIFS can evaluate different criteria in the same or different ranges. When doing financial analysis, COUNTIF helps in doing a quick analysis.

Detailed explanation-4: -Formula 2. To get the total count, embed COUNTIFS inside the SUM function, like this: SUM(COUNTIFS(range, "criteria1", "criteria2", "criteria3", …)) You can find a few more ways to count cells with OR logic in this tutorial: Excel COUNTIF and COUNTIFS with OR conditions.

There is 1 question to complete.