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

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?