WorksheetsSpreadsheets: all Qs
Total questions: 90
Worksheet time: 46mins
What are the individual rectangles on a worksheet called?
Rows
Columns
Cells
Formula
A vertical line of cells in a spreadsheet is a what?
Row
Column
A horizontal line of cells in a spreadsheet is a what?
Row
Column
How are columns labelled on a worksheet?
Letters
Numbers
Symbols
How are rows labelled on a worksheet?
Letters
Numbers
If you wanted to change the colour of the text inside a cell, which tool would you use?
Text colour
Fill colour
Borders
Bold
If you wanted one cell or a number of cells to stand out from the rest which tool could you use?
Bold
Fill Colour
Currency
Borders
If you wanted to change the size of the text inside a cell which tool would you use?
Cell width
Cell height
Text colour
Font size
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What do all formulae start with in a spreadsheet?
+
/
*
=
Which symbol would you use if you are adding the values in cells together?
/
-
+
=
Which symbol would you use to divide the values in two cells?
/
-
*
=
Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?
/
-
*
=
Which symbol would you use to multiply the values in two cells together?
/
-
*
=
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MIN
MAX
AVERAGE
What is the cell reference of the cell with value Coca-Cola inside?
A3
3A
C5
D7
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?
Item
Price
Number Sold
Total
Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta
£1.25 times 12
C5*D5
=C5*D5
Which of the following formulas will work when typed into a cell in Excel?
£0.65 times 23
C10*D10
=C10*D10
=C10xD10
To create an absolute cell reference ___________ sign is used before the parts of formula.
#
$
*
=
A type to cell reference that does not change when copied or filled is called
Cell reference
Absolute cell reference
Relative cell reference
A cell reference that changes when copied is called
Cell reference
Absolute cell reference
Relative cell reference
Which of these formulas uses absolute cell references?
=A25*B12
What formula should be used in cell D4?
=B4+C4
=B4*C4
=B4/C4
=B4-C4
Type the formula that should appear in cell D4.
(a)
What is happening in this spreadsheet?
A formula is being replicated
A formula is being duplicated
A formula is being copied
A formula is being moved
What formula should be used in cell D8?
=SUM(D4+D7)
=SUM(D4:D7)
=SUM(D4+D5+D6+D7)
=SUM(D4:D8)
What is missing from the formula for cell D8?
= (a) (D4:D7)
Cell D8 should contain a function. What kind?
=SUM
=AVERAGE
=MIN
=MAX
Which month is the wettest?
January
February
March
April
May
Which month is the least windy?
January
February
March
April
May
Which month is the least windy?
January
February
March
April
May
What function should be used in the cells in row 17?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in the cells in row 16?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in the cells in row 15?
=SUM
=AVERAGE
=MAX
=MIN
What function should be used in cell B15?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=AVERAGE(C3:C14)
=SUM(D3:D14)
What function should be used in cell D16?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=AVERAGE(D3:D14)
=SUM(D3:D14)
What function should be used in cell C17?
=SUM(C3:C14)
=AVERAGE(C3:C14)
=MAX(C3:C14)
=MIN(C3:C14)
What function should be used in cell B15?
=SUM(B3:B14)
=AVERAGE(B3:B14)
=MAX(B3:B14)
=MIN(B3:B14)
What function should be used in cell B16?
=SUM(B3:B14)
=SUM(B3:B17)
=SUM(B1:B17)
=SUM(B3:B15)
A cell reference that changes when copied is called
Cell reference
Absolute cell reference
Relative cell reference
Which of the following formulas will work when typed into a cell in Excel?
£0.65 times 23
C10*D10
=C10*D10
=C10xD10
What do all formulae start with in a spreadsheet?
+
/
*
=
What is the most popular form of transportation?
walk
cycle
car
bus
taxi
What proportion of people get to work by car?
half
a quarter
a third
three-quarters
an eighth
Do people who taxi or bus combined make more than half of the responses?
yes
no
These are responses to a school trip survey. Which is the most popular choice?
activity centre
wildlife park
museum of natural history
These are responses to a school trip survey. What fraction of students wanted to visit the museum?
a quarter
a half
a third
all of them
Do the students who want to visit the museum and wildlife park combined make up more than half of results?
no
yes
Two schools surveyed students about what they wanted to recycle. Which school decided on plastic bottles?
School A
School B
Sarah asked people what day was best for a party. Which choice did most of her friends choose?
Sunday
Friday
Thursday
Saturday
A tally of cars driving to a school had these results. How many cars contained more than one person?
3
5
8
9
A tally of cars driving to a school had these results. Which was the lowest result?
1
2
3
4
A tally of cars driving to a school had these results. How many people arrived alone?
6
3
5
1
What is the lowest calorie combo meal?
Chocolate muffin and cucumber sandwich
Cheese & ham sandwich and Victoria sponge
Cucumber sandwich and Bakewell tart
Coronation chicken sandwich and Bakewell tart
What is the highest calorie combo meal?
Chocolate muffin and cucumber sandwich
Cheese & ham sandwich and Victoria sponge
Cucumber sandwich and Bakewell tart
Coronation chicken sandwich and chocolate muffin
A balanced lunch should be under 400 calories. If you had a cucumber sandwich, which cake should you not have to stay under this number?
Victoria sponge
Bakewell tart
Chocolate muffin
A survey of class pets showed these results. Which two types of pet are most popular?
cat and fish
dog and hamster
cat and dog
rabbit and dog
What part of a chart is "Types of pets"?
X axis label
Y axis label
title
data labels
What essential component is this chart missing?
X axis label
Y axis label
title
categories
What essential component is this chart missing?
X axis label
Y axis label
title
data labels
What is the most popular flavour of ice cream?
toffee
strawberry
mint
vanilla
chocolate
What is the least popular flavour of ice cream?
toffee
strawberry
mint
vanilla
chocolate
Which two flavours were picked by 8 children in total?
toffee and strawberry
vanilla and strawberry
chocolate and toffee
mint and toffee
vanilla and chocolate
Is the Y axis vertical or horizontal?
horizontal
vertical
On which day was the temperature 26 degrees?
Tuesday
Monday
Wednesday
Saturday
Liam has gathered data about the noise levels in his garden overnight. What kind of chart or graph would work best for this?
pie chart
line graph
bar chart
At what time is Emily's house at its coldest?
9am
3pm
12pm
5pm
Which programs are used to calculate spreadsheets?
Microsoft Publisher & Google templates
Microsoft Excel & Google Sheets
Microsoft PowerPoint & Google Slides
Microsoft Word & Office 365
What symbol does a formula have to start with?
#
$
=
@
Which is NOT a type of chart?
pie
column
bar
axis
What does autosum do?
subtracts totals
adds totals
multiplies totals
divides totals
What are represented by letters in a spreadsheet?
rows
alphabets
numbers
columns
Why are charts/graphs used in spreadsheets?
to show a visual of the data in a spreadsheet
to make the spreadsheet look cool
to backup the data you input into the spreadsheet
all of these are reasons
Which is NOT a formula?
b2+b3+b4
=b1+b2+b3
=b4*c4
=b5/b7
Which icon represents currency?
*
&
$
@
What is the first thing you have to do in a spreadsheet before you can create a chart/graph?
click insert charts/graphs
go to file, print
highlight the data with your mouse
bold all the information
Which chart would you use to show trends or changes over time?
stacked bar chart
pie chart
bar chart
line chart
Is a column vertical or horizontal?
vertical
horizontal
Which of the following is used for a multiplication sign?
X
=
#
*
Which of the following would be a reason you could use a spreadsheet?
To make a presentation
To organize a list of students
To write an essay
To type an email
Which of the following would be a reason you could use a spreadsheet?
To update your operating system.
To work out your average grade in a class.
To build a resume'
To write a research paper.
What is the function that allows you to put data alphabetically?
sort function
junction function
summation function
sheet function
Why do people use spreadsheets?
To make presentations.
To build a resume'.
To write an essay.
To sort information and calculate numbers.
To expand a column, you must ________.
Double click between the column letters.
Double click between the row number.
Use a 'count if' formula
Put in a command.
Which of the following do you use to begin a formula?
=
X
*
+
How do you select an entire row?
Press on the letter and number of the cell together.
Click your mouse on the row number only.
Click the cursor on your cell and drag it to the last cell.
Double click your mouse on the cell.
A combination of a column letter and a row number is called the ________.
cell address
column indicator
spreadhsheet
new sheet
