Animal Rescue Centre Quiz 2

In a spreadsheet what is a variable?

• A value that can change

• A cell with a formula

• A specific number

• +, -, /, or *

Enter the most efficient formula to add the range of cells from A1 to A2 on a spreadsheet

• =a1:a2

• =a1*a2

• =a1+a2

• =a1/a2

In an Excel spreadsheet what do all formulas start with?

• A cell reference (e.g. A1)

• An operator

• An equals sign

• f(x)

Which of these is a valid formula for adding up a range of cells?

• =sum(E5:E14)

• =SUM(E5+E14)

• =TOTAL(E5:E14)

• =+(E5:E14)

What is a spreadsheet?

• a computer programme to enter figures that can be calculated and modelled

• a computer programme which designs posters for Animal Rescue Centre

• a computer programme in which you can use to write stories.

• a computer programme in which you can make and edit videos.

Name one advantage of using a spreadsheet over a pen and paper method?

• You can add up numbers easily

• Its cheaper

• You have to learn how to use it before you can add up sums

• Pen and paper is easier to use because everyone has it available

What is a rule?

• Rules are needed when you want to calculate something

• Rules are formulas entered into a spreadsheet

• Rules are what you follow at school

• Rules are numbers that can be changed

What is formulae?

• Formulae is needed to calculate the rule

• Formulae is a recipe for cooking

• Formulae is a rule you enter into a spreadsheet

• Formulae is a variable that you can change

What are the advantages of testing the data?

• To make sure your formulae works to calculate the answers

• To make sure you can save your spreadsheet

• To make sure you have data entered

• To make sure you can afford your cat and dog

Why should you colour code your spreadsheet?

• To make your information clearer to read

• To make the spreadsheet look attractive

• Spreadsheets need colour in their cells

• To see where all the data goes