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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?