NEW
Font size
WorksheetsYr 8.3 Spreadsheet/Excel Models
Total questions: 17
Worksheet time: 10mins
Spreadsheet software/google sheet
Word Processing/google doc
Drawing/paint
Goal Seek in excel is used for setting LIMITS and TARGETS
True
False
Spreadsheet models can be used to ask ‘What if….’ questions.
They can be used to try out different options by changing figures in the spreadsheet. This will help to predict what will happen and try out different scenarios
False
True
Conditional Formatting is used on a spreadsheet.
Allows the format of a cell to change depending upon the condition or value in that cell e.g. change the cell fill to red if it contains a negative number
True
False
Which is not data validation?
The checking of data, on input or by software to make sure that it is sensible.
The checking of data, on input or by software to make sure that it is reasonable
A way of checking that something has been entered correctly.
The process of establishing the truth, accuracy, or validity of something.
What will this function will do =SUM(A1:A10)
Add up something
Add up cells in the range A1 to A10
Sum up something
Sum up everything
What will this function will do =MAX(B10:B20)
Max up B10 to B20
Max up the cells in the range
Max up the function
It will find and return the maximum value found in the cells between B10 and B20
What will this function will do =COUNTIF(E9:P10, “C”)
It will Countif something
It will count and return the number of times that E occurs between the cells E9 and P10
It will count and return the number of times that C occurs between the cells E9 and P10
It will count and return the number of times that P occurs between the cells E9 and P10
On the image, what values are stored in cells B4, E14 and J17?
B4: £0.55, E14: Wed & J17: 71243
B4, E14 & E17
B4:0.55, E14: Thu & J17: 71243
B4: £0.55, E14: Wed J17: 266,218
There is no difference between these two functions is excel?
B12*$B$4 or 0.55*B12
False
True
The correct formula to add up two(2) cells are?
=sum(C12 + C17)
=C12 + C17
C12 + C17
=sum(C12:C17)
The correct formula to add up more than two(2) cells are?
B12 +C12 + F12
=B12 + C12 + F12
=sum(B12+C12+F12)
=sum(B12:F12)
