Question 1
Back to Spreadsheet Skills
Higher Applications of Mathematics
Spreadsheet Skills mixed revision quiz
A mixed adaptive checkpoint across spreadsheet formulae, references, finance tables, charts, trendlines and error checking.
Quick checkpoint
Check your understanding
Answer each question, check your feedback, then use the diagnosis to fill gaps in your spreadsheet skills.
Score: 0/12
formula syntax
Question 2
Which reference locks cell E1 when copying a formula?
Question 3
Write the formula for percentage change from old value B2 to new value C2.
Question 4
If =B2+C2 is copied down one row, what should it usually become?
Question 5
Which check is most useful before trusting a spreadsheet output?
Question 6
For mixed revision, what makes a spreadsheet answer stronger in Higher Applications?
Question 7
Which chart is usually best for showing a relationship between two numerical variables?
Question 8
Which columns belong in a loan repayment table?
Question 9
Write a spreadsheet formula for future value using amount B2, rate C2 and years D2.
Question 10
What does #DIV/0! usually mean?
Question 11
Why keep assumptions such as interest rate in separate input cells?
Question 12