WorksheetsBasic Excel for G3
Total questions: 20
Worksheet time: 10mins
?
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
How to put data into a spreadsheet?
click the 'Insert Tab'
select a spreadsheet
select a cell and type a title then press enter
How to format text?
select a cell. Use the 'Font' menu to make the text in the cell look different.
select a cell. Use the 'Find' menu to make the text in the cell look different.
select a cell. Use the 'Home' menu to make the text in the cell look different.
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
Which type of graph is the best to show the following data?
How much a child grows between the age of 1 and 7.
Line
bar
pie
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
How to add a title?
at the top of the graph click title menu
at the top of the graph press the edit tab
at the top of the graph it says 'Chart Title' click on the chart title
?
Graph Title
Key Legend
Column
?
Bar Chart
Line graph
?
Line Graph
Bar Chart
Based on the 'Bar Chart', which student is the tallest?
Jenny
Zara
Rahim
Layla
