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

על ידי
הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?