AAT L3 Spreadsheets for Accounting 3

Question 1

The PMT function in Excel calculates:

Accepted Answer

The periodic payment for a loan or annuity given interest rate, term, and principal

Answer

PMT(rate, nper, pv) calculates the fixed periodic payment needed to repay a loan (or receive from an annuity) at a given interest rate over a specified number of periods.

Question 2

When using Excel for accounting purposes, why is it important to separate input data from formulas in different areas?

Accepted Answer

To make it easier to update assumptions without changing formulas, reducing errors

Answer

Separating input cells (data/assumptions) from formula cells follows good spreadsheet design practice; it makes the model easier to update, audit, and check, and reduces the risk of errors when changing inputs.

Question 3

In Excel, a macro is used to:

Accepted Answer

Record and replay a sequence of actions, automating repetitive tasks

Answer

A macro records a series of actions (keystrokes and commands) that can be replayed to automate repetitive tasks, such as formatting reports or running regular data processing routines.

Question 4

What is the purpose of 'freezing panes' in Excel?

Accepted Answer

To keep row or column headers visible when scrolling through a large spreadsheet

Answer

Freeze Panes locks specified rows and/or columns in place so they remain visible as you scroll through a large dataset, making it easier to see column or row headings at all times.

Question 5

Which of the following is the correct Excel formula to calculate VAT (at 20%) on a net amount in cell A1?

Accepted Answer

=A1*0.2

Answer

VAT at 20% on a net amount is calculated as net × 0.20 (i.e., the net amount × 20%). To find the gross amount, the formula would be =A1*1.2; to extract VAT from a gross amount, use =A1/1.2*0.2 or =A1-(A1/1.2).

AAT Level 3 Practice Test

AAT Level 3 Practice Test

AAT L3 Spreadsheets for Accounting 3