Font size
WorksheetsYear 7 End of Unit Assessment - Spreadsheet
Total questions: 25
Worksheet time: 17mins
Which of the following is used to begin a formula in Excel?
+
=
*
/
Which of these is a row labeled with?
Letters
Numbers
Symbols
Formulas
Which of these is an example of a value?
Name
Total
300
Label
What is a spreadsheet mainly used for?
Writing stories
Making presentations
Storing and calculating data
Drawing pictures
What is a function in a spreadsheet?
A set of data
A type of cell
A preset formula
A visual tool
What would you use to add up values in a column?
A chart
A label
SUM function
A row
What is the purpose of a label in a spreadsheet?
To calculate values
To reference cells
To describe data
To store numbers
Which of these is NOT part of a spreadsheet?
Cell
Page
Column
Row
Which function is used to find the average in Excel?
SUM()
AVG()
AVERAGE()
MEAN()
How many worksheets can a spreadsheet have?
Only one
Two
Multiple
None
Which function would you use to find the sum of numbers in A1 to A10?
=AVERAGE
=MAX
=SUM
=MIN
What function would you use to find the minimum values in a list of values
=SUM
=AVERAGE
=MAX
=MIN
Which function counts the number of entries in C2 to C10?
=SUM
=AVERAGE
=MAX
=COUNT
What label would you apply to the top of this chart to describe its content?
Legend
Y-Axis
Chart Title
X-Axis
Which part of a chart explains the symbols or colors used?
Legend
Y-Axis
Chart Title
X-Axis
What is the name of the area where you enter formulas in a spreadsheet?
Cell Reference Box
Formula Bar
Chart Title
Legend
Which of the following is a function in Excel?
=SUM(A1+B1)
=C3-D3
=SUM(A1:A10)
MIN(C3:E2)
Which step comes after clicking on the 'Insert' tab when inserting a chart in Excel?
Highlight the data
Choose chart type
Customize the chart
Save the document
Which chart type is best to show parts of a whole?
Bar Chart
Line Graph
Pie Chart
Scatter Graph
Complete the function to find the Total products in the list of drinks (a) (b) ( (c) (d) (e) )
The formula to multiply the price of Cola by its quantity will be (a) ( (b) (c) (d) )
Write a function to find the lowest price from the list of prices
(a)
What is the horizontal (X-axis) title of this chart?
(a)
How many Energy drinks were bought?
(a)
What symbol is used to multiply values in Excel?
(a)
