Quiz
Spreadsheets - Year 9 L1
This quiz has question types that open in the usual player.
Questions in this quiz (10)
1Label the key sections of a spreadsheet by dragging and dropping the labels
- ARow
- BCell
- CColumn
2The correct cell reference for this cell is:
- AA1
- B6B
- CB6
- D5B
3Label the Cell References correctly
- AB3
- BC8
- CE5
- DG14
- EA20
4All formulas (and functions) start with...
- A+
- B=
- C*
- DA cell reference
5Some of the important symbols in a spreadsheet are below. Drag and drop their meanings into place.
+ [blank_start]add[blank_end]
- [blank_start]subtract[blank_end]
* [blank_start]multiply[blank_end]
/ [blank_start]divide[blank_end]- Aadd
- Bmultiply
- Cdivide
- Dsubtract
6The symbol for the function menu ( or "Autosum" dropdown) looks like
- AΣ
- BM
- C+
- D=f(x)
7The correct formula to add up the numbers in this spreadsheet is:
- A=add(A1:A5)
- B=A1+A2+A3+A4
- C=SUM(A1:A5)
- D=(A1:A5)
8The correct formula to calculate the average of the numbers in this spreadsheet is:
- A=MEAN(A1:A5)
- B=AVERAGE(A1:A5)
- C=A1+A2+A3+A4+A5/5
- D=AVE(A1:A5)
9A spreadsheet can create many types of [blank_start]graphs[blank_end] or charts. Some of these include line graphs, [blank_start]column[blank_end] (or "bar") charts and [blank_start]pie[blank_end] charts.
- Agraphs
- Bcolumn
- Cpie
10Formatting means...
- AMaking a spreadsheet for some dude called Matt
- BChanging numbers to see what happens
- CChanging how the spreadsheet looks
- DChanging the words to describe what the numbers mean
Information
- Description
- Quiz on Spreadsheets - Year 9 L1, created by Jon Rogers on 18/08/2017.
- Author
- Jon Rogers
- Language
- English
- Views
- 650
- History
- Created on 18 Aug 2017 · updated on 11 Apr 2018
- Tags
- Rating
- No ratings yet Rate this quiz