NEW
Font size
WorksheetsAnimal Rescue Centre Quiz 2
Total questions: 10
Worksheet time: 5mins
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
