AAT L3 Spreadsheets for Accounting 5

Question 1

Which feature in Excel allows you to protect the formulas in a spreadsheet from being accidentally changed?

Accepted Answer

Sheet protection (with locked cells)

Answer

Cell locking combined with sheet protection prevents users from editing specified cells (typically formula cells); input cells can remain unlocked, so data can be entered without risking formula changes.

Question 2

The Excel TEXT function is used to:

Accepted Answer

Format a number as text with a specified format

Answer

TEXT(value, format_text) converts a number to text with a specified format code — for example, =TEXT(A1,'dd/mm/yyyy') formats a date serial number as a readable date string.

Question 3

When preparing a payroll spreadsheet, which function could be used to look up an employee's pay rate from a separate table based on their employee code?

Accepted Answer

VLOOKUP

Answer

VLOOKUP is ideal for retrieving employee pay rates from a lookup table using the employee code as the lookup value — a common use of VLOOKUP in payroll and HR spreadsheets.

Question 4

Which of the following describes the purpose of the 'Goal Seek' function in Excel?

Accepted Answer

It calculates what input value is needed to achieve a specific output value in a formula

Answer

Goal Seek (under What-If Analysis) finds the input value needed for a formula to produce a desired result — for example, what sales level is needed to achieve a target profit.

Question 5

In a well-designed accounting spreadsheet, a control total is used to:

Accepted Answer

Verify that data entered equals expected totals, providing a check on completeness and accuracy

Answer

Control totals are independent checks built into a spreadsheet — for example, checking that the sum of individual entries equals an independently calculated total, catching entry errors or omissions.

AAT Level 3 Practice Test

AAT Level 3 Practice Test

AAT L3 Spreadsheets for Accounting 5