1) Which function is used to add more than two cells in a spreadsheet? a) = COUNT ( ) b) = SUM ( ) c) = A1 + B1 + C1 d) = COUNT A ( ) e) = AVERAGE ( ) f) = MIN ( ) 2) Which one is a cell reference? a) 3E b) 8A c) ADH d) 0A e) A8 f) AE 3) What are spreadsheets used for? a) To organise information b) To calculate and sort data c) To present information d) To save files e) To send emails 4) Relative cell references use $ signs to make sure a cell reference does not change when replicated a) True b) False 5) Which function is used to find the largest value in a range of cells? a) = MIN ( ) b) = AVERAGE ( ) c) = COUNT ( ) d) = SUM ( ) e) = MAX ( ) 6) Absolute cell references in a formula are indicated by placing a dollar sign ($) before the column letter and row number. a) True b) False 7) The COUNT function counts both text and numerical data in a cell a) True b) False 8) = B1 / A1 will... a) Multiply both cells together b) Add the cells c) Divide the cells d) Subtract the cells 9) What symbol must ALL formulas contain a) - b) $ c) ( ) d) = e) + f) /

S3 Admin Spreadsheets Starter Activity

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

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