NEW
Font size
WorksheetsEXCEL FOR YEAR 5
Total questions: 35
Worksheet time: 18mins
Microsoft excel is a ________________________program
Document
Spreadsheet
Database
Presentation
?
B1
B2
B3
What is a spreadsheet?
Cell A1 when selected
Number Value
A grid of columns and rows.
What would be a correct formula for Addition in excel?
=B3+B4
B3-B4
B3*B4
What would be a correct formula for Subtraction in excel?
B3+B4
=B3-B4
B3*B4
What is Cell reference?
The name of a cell is made of the column letter and the row number.
Is a grid of columns and rows
It tells us the number value
?
x-axis
graph title
y-axis
?
y-axis
graph title
x-axis
?
x-axis
graph title
y-axis
Name one advantage of showing data as a graph instead of a list of numbers.
It is easy to read and identify the given data.
It's fun to make a graph.
To decorate the spreadsheet.
Name two different types of graph.
Bar and Line graph.
oblong and diamond
triangle and square
What is the purpose of a key legend on a graph?
It tells you what the three colours mean.
It tells you the color of the graph.
It tells you the column and row of the graph.
What are the two ways you can sort a spreadsheet list
Drawing and image
A to Z and Z to A
file name and number
?
Line Graph
Bar Chart
Which of the following will pull out the lowest number?
SUM
MAX
AVERAGE
MIN
What part of a spreadsheet is vertical?
Formula Bar
Row
Column
Cell
Which part of a spreadsheet is horizontal?
formulas bar
column
row
cell
Values are aligned on which side of a cell?
Left
Right
Labels align on which side of a cell?
Right
Left
Which of the following is a correct cell address?
1
A1
1A
A
What part of cell is represented by letters?
row
forumula bar
columns
cell
Which of the following is used to get the highest number?
AVERAGE
SUM
MAX
MIN
Which symbol is used for division?
Asterisk
Forward slash
Back slash
Space bar
A cell that has a dark border around it and is the cell you are currently working in is called:
Row
Label
Column
Active Cell
Which of the following symbols is used for multiplication?
Back slash
Plus
Asterisk
Forward slash
What symbols MUST be typed first to tell a cell it is going to calculate?
Equals
Asterisk
Dollar
Percentage
Which of the following will give you a total?
MIN
MAX
AVERAGE
SUM
Which of the following is a formula?
John Jones
$5.00
=SUM(A1:A5)
=A1+A5
