1) What does COUNTIF do? a) Counts cells b) Sums cells c) Averages cells 2) Which function sums based on criteria? a) SUMIF b) COUNTIF c) AVERAGEIF 3) What is the first argument in COUNTIF? a) Range b) Criteria c) Sum range 4) What does SUMIF require? a) Range, criteria b) Range, criteria, sum range c) Criteria, sum range 5) Which function counts cells with a condition? a) COUNTIF b) SUMIF c) VLOOKUP 6) What is the second argument in SUMIF? a) Criteria b) Range c) Sum range 7) Can COUNTIF handle text criteria? a) Yes b) No c) Sometimes 8) What does SUMIF return? a) Sum of values b) Count of values c) Average of values 9) Which function uses a single condition? a) COUNTIF b) SUMIF c) IF 10) Is SUMIF case-sensitive? a) No b) Yes c) Sometimes

Higher Administration: COUNTIF and SUMIF Quiz

Odštampaj
Ugradi

Tabela

Vizuelni stil

Postavke

Promeni šablon

Vrati automatski sačuvano: ?