NEW
Font size
WorksheetsYear 7 - Spreadsheet Knowledge Quiz
Total questions: 10
Worksheet time: 5mins
In a spreadsheet, what are the vertical sections labelled with letters (A, B, C, etc.) called?
Rows
Columns
Cells
Sheets
What are the horizontal sections labelled with numbers (1, 2, 3, etc.) in a spreadsheet called?
Rows
Columns
Charts
Formulas
What do we call the intersection of a row and a column in a spreadsheet?
Chart
Table
Cell
Formula
Which formula would you use to add the numbers in cells A1, A2, and A3?
=ADD(A1+A2+A3)
=SUM(A1+A2+A3)
=TOTAL(A1:A3)
=SUM(A1:A3)
Which feature would you use to change the text colour in a cell?
Font Colour
Bold
Merge
Chart
What happens when you sort a column in ascending order?
The smallest values are listed first.
The largest values are listed first.
The column becomes blank.
The column is deleted.
Which type of chart would best show changes over time?
Bar Chart
Pie Chart
Line Chart
Scatter Plot
What does the cell reference "C3" mean?
Column 3, Row C
Column C, Row 3
Row 3, Column C
Both b and c
What is the purpose of the AutoFill feature in spreadsheets?
To copy data or formulas into adjacent cells
To sort data automatically
To create a chart
To add colors to cells
In what format should you save a spreadsheet to ensure it can be opened in most spreadsheet programs?
.doc
.ppt
.xlsx
