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 生成的內容。了解更多。

切換範本

恢復自動保存: ?