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

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?