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

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？