NEW
Font size
WorksheetsY9 Spreadsheet Homework
Total questions: 27
Worksheet time: 18mins
What makes cells change in appearance?
Formula
Formatting
Function
Forgotten
Which of these is NOT a formatting tool?
Background colour
Borders
Fonts
SUM
What does "Conditional Formatting" mean?
Changing the background and borders
Changing the font and text colour
Changing how some cells look based on a rule
Hiding some data in the spreadsheet
Which formula would be used to calculate a total?
=MAX(B5:B10)
=SUM(B5:B10)
=AVGERAGE(B5:B10)
=SUM(B5*B10)
Which formula would be used to calculate the largest number?
=MAX(B5:B10)
=SUM(B5:B10)
=AVGERAGE(B5:B10)
=SUM(B5*B10)
_____ is used to combine two or more cells
Alignment
Wrap text
Format
Merge and Center
What symbol is used for multiplication (times)?
*
/
+
-
What is =B2 + C2 ?
2
10
1
11
What is =A2 - C1 ?
2
10
1
11
In a spreadsheet, a formula must ALWAYS start with...
a cell address
a letter
an equals sign
an empanada
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
Charts and graphs are __________________________ representations of data.
graphical
simple
inaccurate
Which type of graph is suitable for the sandwich shop scenario
Column Graph
Pie Chart
Scatter Graph
Line Graph
Histogram
What is the cell reference of the Yellow cell?
A1
C4
B3
C3
What does this symbol do? /
Divide
Add up
Subttract
Multiply
The yellow strip refers to a
Row
Column
The blue strip refers to a
Row
Column
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 are the three essential elements to enter a function?
Equal sign, function name and cell reference.
Equal sign, cell reference and formula.
Function name, data and cell reference.
Function name and cell reference.
What is the result of
=C4 + C5
32
12
17
15
THE __________ FUNCTION IS USED TO FIND THE MAXIMUM VALUE FROM A SET OF VALUES
MAX( )
MIN( )
