Font size
Worksheets21-22 8 Aut 1 Spreadsheet
Total questions: 23
Worksheet time: 13mins
In =SUM(A6:H9) which part is the parameters?
=
SUM
A6:H9
This has no paramters
In =SUM(A6:H9) which part is the function?
=
SUM
A6:H9
This has no function
To find the Mean Average of the value in the celles G6 to L15 we would use:
=MEAN(G6:L15)
=MAX(G6:L15)
=AVG(G6:L15)
=AVERAGE(G6:L15)
The formula =RIGHT(B6,7) when performed on the phrase "The way to write a million is 1000000" typed intp B6 would result in
No answer
1000000
The way
one million
What symbol is used to indicate an absolute cell reference?
£
#
@
$
A spreadsheet needs to have different values entered into a cell depending on whether the user inputs "Yes" or "No". WHat function can be used to create a formula that can decide what to put into the cell?
DECIDE
IF
CHECK
DEPEND
Changing the background colour of a cell would be changing the ________________________? Choose the most suitable answer in terms of ICT language.
Colour
Size
Formatting
Background
A cell displays ######## when you know there should be something in it. How can you solve the problem of not being able to see the value in the cell? Choose as many as apply
Double click on the line between the columns on the top bar
Make the font really small
Drag the line between the columns wider on the top bar
Use a larger cell
you need a cell to be coloured red on the background if the value is negative. What do you need to use?
IF statement
Formatting
Conditional Formatting
None of these
You are making a spreadsheet to keep track of how much you have spent on Books. You wish to show the money spent such as £5.99. What should you do or choose from the options listed, choose the most applicable?
Just type in £5.99 as the spreadsheet will "know"
Type 5.99 and format the cell to "Currency"
Type 5.99 and format the cell to "Accounting"
Type 599 and format the cell to "Money"
You are using a spreadsheet to calculate the profit from a show. In order to make a reasonable profit you may need to alter the price of the tickets. The computer has a built in menu function to help with this. What is it?
FIND
CALCULATE
ALTER
GOAL SEEK
What formula should be placed in the red cell shown?
=SUM(E7+E20)
=TOTAL(E7+E20)
=TOTAL(E7:E20)
=SUM(E7:E20)
What formula should be placed in the red cell shown?
=SUM(E7+E20)
=TOTAL(E7+E20)
=TOTAL(E7:E20)
=SUM(E7:E20)
What formula is required to add up the Precipitation(mm) to make the Total(mm)
=D5+D6+D7+D8+D9+D10
=SUM(D5:D13)
=SUM(D5+D13)
=TOTAL(D5 to D13)
What has been done between to change the information on the left to the information on the right, and why?
Coloured it in to make it look better
Formatted gridlines and background colour to add interest
Formatted gridlines and background colour to make it easier to read and understand
Formatted colours and added gridlines to make it look good
In which cell would you place a formula to calculate the maximum precipitation
G1
D14
F8
G8
Which of these should not be made into a line graph?
The number of apples, pears , oranges and lemons in a shop
Colours of cars passing a point over a given time
The temperature change in a cup of coffee over time
Maximum temperature in each month of the year 2020
A discrete (non-continuous) variable is one which...
Has no intermediates between values
Can always be broken down into smaller values, infinitely.
Is suitable for use on bar charts
Is suitable for use on line graphs
On a graph, the Y-Axis is used to show
The variable we did not control or know beforehand
The variable we did control and knew beforehand
Which is the X-Axis on a graph?
X is horizontal (across)
X is vertical (up and down)
What should be typed into the cell J2 in order to get the computer to fill in that someone is charged £5 if they want to race (R) but not charged if they are leisure (L) riders?
=RACE=£5
=IF(J2="R",£5,£0)
=IF(J2="R",5,0)
=IF(J2="L",5,0)
Members are charged a fee depending on their type of membership (MTYPE). Juniors pay £5, Family £10 and Full £25. Which of the following will do this for all the Members if filled down from H2?
=IF(F2="Full",25,(IF(F2="Family",10,5)))
=IF(F2="Full",25,(IF(F2="Family",10,(IF(F2="Junior",5,0)))))
=if(F2="Full,25,10,5)
=IF(F2="Full",25, 10 OR 5)
What does the formula =SUM(A7:H9) do?
Adds together the values in A7 and H9
Adds together all the values in A7 to H9
Multiplies the values in A7 and H(
None of the previous
