Advanced Formulas Knowledge Assessment

Front

Which function automatically counts cells that meet multiple conditions? Options: COUNTIF, COUNT, COUNTIFS, SUMIFS

Back

COUNTIFS

Front

Which function automatically counts cells that meet a specific condition? Options: COUNTIF, COUNT, COUNTIFS, SUMIFS

Back

COUNTIF

Front

In the formula =SUMIFS(C5:C16, F5:F16, "<=60", B5:B16, ">200000"), which of the following is the range of cells to be added? Options: =C5:C16, =F5:F16, =B5:B16, =C5:F16

Back

=C5:C16

Front

In the formula =SUMIFS(C5:C16, F5:F16,"<=60", B5:B16, ">200000"), what does "<=60" mean?

Back

If the value in F5:F16 is less than or equal to 60, the value in C5:C16 will be included in the total.

Front

What does criteria range in a formula refer to?

Back

The range containing a condition that must be met in order for data to be included in the result.

Front

Which function returns one value if a condition is true and a different value when the condition is not true?

Back

IF

Front

Which of the following functions returns a value if all conditions are met? AND, OR, IF, SUM

Back

AND

Front

Which function searches for a value in the first column of Table_array and returns a value in the same row from Col_index_num? Options: AVERAGEIF, VLOOKUP, MID, HLOOKUP

Back

VLOOKUP

Front

Which of the following functions converts text from uppercase to title case? UPPER, PROPER, LOWER, TRIM

Back

PROPER

Front

Which function joins two or more text strings into a single text string? Options: AND, MID, TRIM, CONCAT

Back

CONCAT