Cambridge International AS Level · Information Technology (9626)

Spreadsheets: Practice Questions

5 multiple-choice questions marked as you go, and 5 written questions with worked solutions. All on Spreadsheets.

10 questions21 marksFree, no account

Question 1

1 mark

What is the primary purpose of applying cell protection in a shared financial spreadsheet model?

Question 2

1 mark

Cell A1 contains the text Cambridge and cell B1 contains the formula:
\(=MID(A1, 4, 3)\)
What value is returned in cell B1?

Question 3

1 mark

Which spreadsheet function returns the smallest numerical value in the range B2:B15?

Question 4

1 mark

A student wants to prevent users from accidentally editing or deleting formulas in a completed spreadsheet worksheet. What feature should be applied?

Question 5

1 mark

In a spreadsheet test plan designed to validate an input cell accepting examination marks from \(0\) to \(100\), which value represents extreme (boundary) data?

Question 6

2 marks

In spreadsheet software, what is the key difference between the COUNT and COUNTA functions?

Write your answer out first, then check it against the worked solution.

Question 7

3 marks

When designing a test plan for validating test scores that must fall between \(0\) and \(100\) inclusive, identify one specific numeric value for extreme data and one specific value for abnormal data.

Write your answer out first, then check it against the worked solution.

Question 8

2 marks

State the purpose of the \(TRANSPOSE\) function in a spreadsheet.

Write your answer out first, then check it against the worked solution.

Question 9

4 marks

A teacher uses a spreadsheet to manage student exam scores.
(a) Scores are recorded in cells B2:B35. Write a formula to find the highest score and a formula to find the lowest score.
(b) Describe how data validation can be configured on the score input cells to prevent scores below \(0\) or above \(100\) from being entered.
(c) State one reason why spreadsheet cells containing formulas should be protected or locked.

Write your answer out first, then check it against the worked solution.

Question 10

5 marks

A payroll spreadsheet determines employee tax brackets and bonuses.
(a) Write a nested IF formula in cell D2 based on the annual salary in cell C2: if salary is greater than \(80000\), tax rate is \(30\%\); if greater than \(40000\), tax rate is \(20\%\); otherwise, tax rate is \(10\%\).
(b) Write an alternative formula using the IFS function to achieve the same result.
(c) An additional bonus rule applies: if an employee has worked more than \(5\) years (cell E2) AND has a performance rating (cell F2) of \(4\) or higher, they receive "Eligible", otherwise "Not Eligible". Write the formula using IF and AND.

Write your answer out first, then check it against the worked solution.

* The content provided by thinka is generated by AI and may not always be accurate or up-to-date. Please use it as a supplementary resource and verify with official materials.

You've seen the model answer. Now get yours marked.

This page can show you how a good answer looks. It cannot tell you what your answer was missing. thinka marks your written work against the real mark scheme in about 15 seconds.

Get My Answers Marked Back to the notes

Want more questions like these? Get a fresh set on this topic, marked as you go.