Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/27
Score 0
when you use a cell with a value that never or rarely changes
30
absolute cell referencing
Q 2/27
Score 0
hiding results so you only see what you need to see
30
filtering
27 questions
Q.
when you use a cell with a value that never or rarely changes
1
30 sec
Q.
hiding results so you only see what you need to see
2
30 sec
Q.
organising data so it is from lowest to highest
3
30 sec
Q.
organising data so it is from highest to lowest
4
30 sec
Q.
goes left to right
5
30 sec
Q.
goes up and down
6
30 sec
Q.
starts with = and contains cell references and symbols e.g. =A1 * A3
7
30 sec
Q.
starts with = and contains special words, cell references and symbols e.g. =SUM(A1:A3)
8
30 sec
Q.
the cell is not wide enough to display the contents
9
30 sec
Q.
the text in the cell is not recognised
10
30 sec
Q.
cannot do the calculation as the value in a cell is incorrect
11
30 sec
Q.
trying to divide by zero or by an empty cell
12
30 sec
Q.
a formula refers to a cell that is not valid (if you have deleted a cell being used)
13
30 sec
Q.
Best application for calculating invoices
14
30 sec
Q.
Best application for holding customer data
15
30 sec
Q.
Application that generates reports automatically
16
30 sec
Q.
Application that makes charts or graphs easily
17
30 sec
Q.
Best application for tracking stock records
18
30 sec
Q.
Best application for automatically colour coding financial data to see positive and negative figures
19
30 sec
Q.
Application that uses functions and formula
20
30 sec
Q.
Answers 2 questions (the change and the question). If a shop takes on 2 more people, how much more profit (money) does the shop have to make to afford them?
21
30 sec
Q.
rules added to cells to suggest, limit or check the data that can be entered
22
30 sec
Q.
to minimise input errors or to check the input is suitable
23
30 sec
Q.
a single spreadsheet made up of rows and columns
24
30 sec
Q.
a number of worksheets held in a single file
25
30 sec
Q.
example of absolute cell referencing. The cell reference will not change when the formula is copied to another cell.
26
30 sec
Q.
example of relative cell referencing. The cell reference may change when the formula is copied to another cell.