AAT L3 Spreadsheets for Accounting 2

Question 1

In Excel, the =ROUND(3.456,2) function will return:

Accepted Answer

3.46

Answer

ROUND(3.456,2) rounds the number 3.456 to 2 decimal places. The third decimal is 6 (≥5), so the second decimal rounds up from 5 to 6, giving 3.46.

Question 2

What does the Excel function =COUNTA(A1:A10) calculate?

Accepted Answer

The number of cells in A1:A10 that contain any value (text or numbers)

Answer

COUNTA counts all non-empty cells in the range, regardless of whether they contain numbers, text, dates, or errors — unlike COUNT, which only counts cells with numerical values.

Question 3

Which Excel function returns the largest value from a range?

Accepted Answer

MAX

Answer

MAX returns the largest numerical value from a range of cells. LARGE(range,k) returns the k-th largest value; MIN returns the smallest value.

Question 4

Data validation in Excel is used to:

Accepted Answer

Restrict the type or range of data that can be entered into a cell

Answer

Data validation controls what users can enter into a cell — for example, allowing only whole numbers within a range, dates, or values from a drop-down list — reducing data entry errors.

Question 5

A named range in Excel allows you to:

Accepted Answer

Give a cell range a descriptive name to use in formulas instead of cell references

Answer

Named ranges assign a meaningful name (e.g., 'TaxRate' or 'SalesData') to a cell or range; this makes formulas more readable and easier to maintain than using cell references like B2:B20.

AAT Level 3 Practice Test

AAT Level 3 Practice Test

AAT L3 Spreadsheets for Accounting 2