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

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?