WorksheetsY9 Exam Paper Modelling data – Spreadsheets
Total questions: 45
Worksheet time: 30mins
Which of these is used to visualise information as a picture?
Pie chart
Pizza chart
Apple chart
Circle chart
Which of these would you use to add up a range of numbers?
TOTAL
ADD
PLUS
SUM
You use the MAX function to find:
The largest value
The total
The smallest value
The first value
What does the COUNTA function tell you?
The average
The largest value
The number of non-blank cells
The number of A’s
Give the cell references for each of the following ranges:
The first ten cells of column B
(a)
Give the cell references for each of the following ranges:
The cells in rows 15–20 in column A
(a)
Give the cell references for each of the following ranges:
The cells in rows 15-20 in column B, C and D
(a)
Give the cell references for each of the following ranges:
All of the cells of column E from row 3 to the end
(a)
When starting a formula what is the first thing you type in the cell?
+
-
%
=
The letters in Excel represent the _______?
columns
rows
data
functions
The numbers in Excel represent the _______?
columns
rows
data
functions
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
What are the individual boxes on a spreadsheet called?
Squares
Cells
Entry boxes
Rectangles
What can be used to uniquely identify each cell in a spreadsheet?
Cell reference
Column heading
Row number
Cell locator
Which of the following is the correct formula to calculate 8 divided by 2?
=8/2
8/2
=8*2
8%2
In what format should a cell with a money value entered into be in?
Currency
Text
Numbers
Date
What does this tool do?
Add a table
Add a border
Add a Pie chart
Add an image
What Cell have I selected
A4
B5
C5
D5
B6
What colour is cell E2?
Red
Green
Blue
Yellow
What cell reference of the active cell?
(a)
What would be the total if I added together the numbers in B2, D3, F2 and G2?
(a)
Which of these symbols is used for divide on a computer?
\
*
/
|
How are we sorting the data in this clip?
What symbol should be used to perform a multiplying calculation?
+
-
*
/
What is the correct order for the parts that make up a Cell Reference?
Letter then Number
Number then Letter
Which is NOT a formula?
=SUM(b1:b7)
=b1+b2+b3
=b4*c4
=b5/b7
Which icon represents currency?
*
&
$
@
Which is NOT a type of chart?
pie
column
bar
axis
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
What is the next step after highlighting your data in the spreadsheet?
choose chart editor
insert chart
customize your chart
click file, insert
Study the example. Which type of chart is shown?
Line Chart
Column Chart
Scatter Chart
Bar Chart
Study the example. Which of the following is displayed?
Column Chart
Line Chart
Pie Chart
Bar Chart
Which type of chart is divided into portions representing data percentages?
Line Chart
Bar Chart
Column Chart
Pie Chart
Benjamin needs to create a table with employee information regarding only Bryan, Ashley, and Andrew using the data shown. Which cell range should he select in order to create a table that includes the required data located in this spreadsheet?
A4:A6
A1:D8
A4:D6
A1:D6
Andrew needs to create a table using the data shown. Which cell range should he select in order to create a table that includes all of the data in the spreadsheet?
A2:D2
A2:D8
A1:D8
A1:D1
Which statement about charts is true?
A chart is a tabular representation of data that displays the data in columns and rows.
Chart data is usually represented as text, with graphics used only to annotate the data.
Chart data is usually represented in animated form so that it can be more quickly interpreted than reading through the raw data.
A chart is a graphical representation of data that illustrates the relationships between parts of the data.
These are unorganized facts that, which include words, numbers, images, and sounds.
Process
information
Data
There are facts that are Organised, meaningful and useful or we can say it's the output we get from a computer.
Data
Input
Information
Process
Data that you have collected and that you are using yourself
Primary Data
Secondary Data
Data that somebody else collected and that you are using
Primary Data
Secondary Data
A tool that fills the selected cells with repeating values or a pattern
AutoSum
Import
Autofill
Merge
