Year 8 Homework 5 - HT2

Q1. Which of the following is a type of formatting?

• Absolute cell referencing.
• Making the cell currency format.
• Adding a new sheet.
• Using a formula.

Q2. What changes a cells colour depending on what they contain?

• Conditional formatting.
• Formulas.
• The IF function.
• The person who made the spreadsheet.

Q3. What is the function =AVERAGE() used for?

• To find the average of numbers.
• To find the lowest of numbers.
• To find the highest of numbers.

Q4. What is the function =MIN() used for?

• To find the highest number.
• To find the average number.
• To find the smallest number.

Q5. How do functions differ from formulas?

• Functions are not predefined and not pre-set formulas.
• Functions are predefined and pre-set formulas.
• Functions are part time predefined and never pre-set formulas.

Q6. Which of the following tasks would a spreadsheet be best used for?

• Present information about a new television channel.
• Manage the details of members at a gym.
• Keep track of money raised at a charity event.

Q7. Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?

• Because primary school children can use bar charts.
• Because they don't require you to enter any formula.
• Because the data is presented in a more visual way.

Q8. What is a spreadsheet used for?

• Spreadsheet is used to perform calculations.
• Spreadsheet is used to print profits.
• Spreadsheet is used to delete data.

Q9. What is a spreadsheet model?

• A model is some one who walks along the road.
• A model is a representation of a real thing.
• A model is a model car