Spreadsheets：练习题

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

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

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

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

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

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

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.

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

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.

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.