1) Which function counts cells based on a condition? a) HLOOKUP b) SUMIF c) VLOOKUP d) COUNTIF 2) Which function sums values based on a condition? a) VLOOKUP b) COUNTIF c) SUMIF d) HLOOKUP 3) Which function looks up a value in a row? a) VLOOKUP b) HLOOKUP c) SUMIF d) COUNTIF 4) Which function looks up a value in a column? a) VLOOKUP b) HLOOKUP c) SUMIF d) COUNTIF 5) Which function can be used for multiple conditions? a) HLOOKUP b) COUNTIF c) SUMIF d) Nested IF 6) What does COUNTIF return? a) Number of cells b) Sum of values c) Cell value d) Row index 7) What does SUMIF return? a) Number of cells b) Sum of values c) Cell value d) Column index 8) What is the main use of VLOOKUP? a) Sum values b) Find data in rows c) Count cells d) Find data in columns 9) What is the main use of HLOOKUP? a) Count cells b) Find data in columns c) Find data in rows d) Sum values 10) Which function uses a range and criteria? a) VLOOKUP b) COUNTIF c) HLOOKUP d) Nested IF 11) Which function can be used for conditional summing? a) SUMIF b) COUNTIF c) VLOOKUP d) HLOOKUP 12) Which function requires a lookup value? a) Nested IF b) COUNTIF c) SUMIF d) VLOOKUP 13) Which function is used for horizontal lookup? a) VLOOKUP b) HLOOKUP c) COUNTIF d) SUMIF 14) Which function is used for vertical lookup? a) COUNTIF b) HLOOKUP c) VLOOKUP d) SUMIF 15) Which function can be nested for complex conditions? a) HLOOKUP b) COUNTIF c) SUMIF d) Nested IF

Spreadsheet Functions Quiz

Print
Embed

Leaderboard

Visual style

Options

AI Enhanced: This activity contains content generated by AI. Learn more.

Switch template

Continue editing: ?