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

打印
嵌入

排行榜

视觉风格

选项

AI增强版：本活动包含AI生成的内容。了解更多信息。

切换模板

恢复自动保存：？