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

Skriv ut
Bädda in

Rankningslista

Visuell stil

Alternativ

AI-förbättrat: Denna aktivitet innehåller innehåll genererat av AI. Lära sig mer.

Växla mall

Återställ sparas automatiskt: ?