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によって生成されたコンテンツが含まれています。詳細情報。

テンプレートを切り替える

自動保存: を復元しますか?