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

etter
Innebygd

Ledertavle

Visuell stil

Alternativer

Bytt mal

Gjenopprett automatisk lagring: ?