WorksheetsYear 7 Spreadsheet assessment
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
What is a spreadsheet used for?
a)
To create and edit text documents
b)
To perform calculations and analyse data
c)
To design graphics and images
d)
To create presentations and slideshows
2.
Which of the following is a common spreadsheet software?
a)
Windows Media Player
b)
Mozilla Firefox
c)
Google Sheets
d)
Adobe Photoshop
3.
In a spreadsheet, what does the term 'cell' refer to?
a)
A feature for formatting text
b)
A section of the spreadsheet that contains headings
c)
A type of formula used in calculations
d)
A single unit where data is stored
4.
What is the purpose of a formula in a spreadsheet?
a)
To change the font style
b)
To perform calculations automatically
c)
To insert images into the spreadsheet
d)
To create new sheets
5.
Which symbol is commonly used to start a formula in a spreadsheet?
a)
#
b)
$
c)
@
d)
=
6.
What does the function 'SUM' do in a spreadsheet?
a)
It calculates the average of a set of numbers
b)
It adds up a range of numbers
c)
It counts the number of cells in a range
d)
It finds the maximum value in a set of numbers
7.
Which of the following can be a result of using a spreadsheet incorrectly?
a)
Faster data entry
b)
Inaccurate calculations
c)
Better organisation of information
d)
Improved data analysis
8.
What is a 'chart' used for in a spreadsheet?
a)
To display data visually
b)
To write notes
c)
To create hyperlinks
d)
To store images
9.
What does 'formatting' a cell mean?
a)
Moving the cell to a different location
b)
Inserting a formula into the cell
c)
Deleting the content of the cell
d)
Changing the colour and style of the text
10.
What does the term 'range' refer to in a spreadsheet?
a)
A specific area of cells selected for a function or formula.
b)
The maximum number of cells in a spreadsheet.
c)
The total number of rows in a spreadsheet.
d)
A type of chart used to display data visually.
100 %
