FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can enter up to ____ conditions that data must match in order for a cell to be included in the conditional summary that results from a SUMIFS, COUNTIFS, or AVERAGEIFS formula.
A
127
B
239849
C
100000
D
5000
Explanation: 

Detailed explanation-1: -If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, “John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John."

Detailed explanation-2: -The SUMIF function adds only the values that meet a single criteria. The SUMSQ function sums multiple values after it performs a mathematical square operation on each of them. The COUNTIF function counts only the values that meet a single criteria.

Detailed explanation-3: -To use an IF, COUNTIF or SUMIF function, you can opt for any of these three methods: typing the formula directly in a cell, selecting it from the Insert Function button on the Formula bar, or selecting it from the Function Library located under the Formulas tab on the Ribbon.

There is 1 question to complete.
Previous
Next