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가 생성한 콘텐츠가 포함되어 있습니다. 더 알아보세요.

템플릿 전환하기

자동 저장된 게임을 복구할까요?