# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### 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.