NEW
Font size
WorksheetsYear 7 Spreadsheet basics
Total questions: 10
Worksheet time: 5mins
A spreadsheet program is used to store data in:
a database.
a text document.
rows and columns.
letters and numbers.
Spreadsheet rows are easily identified by:
Numbers.
Letters.
Roman numerals.
Colours.
Spreadsheet columns are easily identified by:
Roman numerals.
numbers.
letters.
colors.
Which of the following is an example of a cell reference?
Column C
=SUM
Row 1
A5
Sum, average, count, maximum value, and minimum value are examples of what?
Formulas
Calculations
Functions
Spreadsheet data
Addition, subtraction, multiplication, division are examples of what?
Formulas
Conditional formatting
Functions
Spreadsheet data
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculations in an organized way
To excel your written work
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 average?
=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)
