Year 8 homework 4 - HT2

Q1. A spreadsheet is a PROGRAM which makes it easy for you to work with numbers.

• False
• True

Q2. A spreadsheet consists of a page made up from COLUMNS and ROWS which are arranged into a GRID.

• TRUE
• FALSE

Q3. You can identify every single cell on a spreadsheet by its unique cell REFERENCE made up from the ROW number and column letter, for example A6, E14, N45.

• TRUE
• FALSE

Q4. Numbers, text or FORMAULAS can be entered into each cell.

• TRUE
• FALSE

Q5. Formulas allow you to perform CALCAULATIONS on the numbers in your spreadsheet. You can add, subtract, multiply and DIVIDE numbers by using formulas. Using formulas is a very good idea, because it means that once your spreadsheet is set up, any changes you make to one area are automatically RECALCULATED throughout the SPREADSHEET.

• True
• False

Q6. How many rows are shown on this spreadsheet?

• 7
• 8
• 6
• 3

Q6. How many columns are shown on this spreadsheet?

• 3
• 4
• 2
• 1

Q7. What is the cell reference of the active cell?

• C5
• C6
• C4
• C7

Q8. Which of the following is an example of a cell reference?

• C6
• =6*7
• SUM(A3:A6)
• D

Q9. Which of the following graph/chart types is most suited to show percentages?

• Pie
• Column
• Bar
• Line