AAT L3 Spreadsheets for Accounting 6

Question 1

The Excel NETWORKDAYS function calculates:

Accepted Answer

The number of working days (excluding weekends and optionally holidays) between two dates

Answer

NETWORKDAYS(start_date, end_date, [holidays]) returns the number of working days between two dates, automatically excluding Saturdays, Sundays, and any specified bank holidays.

Question 2

An accountant is asked to produce a cash flow forecast in Excel. To ensure the forecast updates automatically when assumptions change, the accountant should:

Accepted Answer

Link all forecast outputs to clearly labelled assumption input cells using formulas

Answer

Linking outputs to labelled input cells (assumptions) means changing an assumption (e.g., interest rate, growth rate) automatically recalculates all affected forecasts — this is the key advantage of using a well-structured Excel model.

Question 3

Which Excel function returns the position (row number) of a value within a range?

Accepted Answer

MATCH

Answer

MATCH(lookup_value, lookup_array, match_type) returns the relative position of a value within a range (e.g., 3 if it is the third item). Often used in combination with INDEX to create a flexible two-way lookup.

Question 4

When sharing an Excel workbook containing confidential client data, the most secure method is:

Accepted Answer

Password-protecting the workbook and sending via an encrypted, secure channel

Answer

Protecting confidential data requires both file-level security (password protection) and secure transmission (encrypted email or secure file transfer). Unprotected files sent via unsecured channels risk data breach.

Question 5

The Excel SUMPRODUCT function is useful for accounting because it can:

Accepted Answer

Multiply corresponding values in two or more ranges and sum the results — useful for weighted averages and invoice totals

Answer

SUMPRODUCT multiplies corresponding values in two or more arrays and sums the results — for example, multiplying quantities by unit prices across a range to calculate total revenue without a helper column.

AAT Level 3 Practice Test

AAT Level 3 Practice Test

AAT L3 Spreadsheets for Accounting 6