Practice Test GeeksAAT Level 3 Practice Test
← All AAT L3 Flashcard Decks

Spreadsheets for Accounting Flashcards

6 cards from real AAT L3 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Spreadsheets for Accounting flashcards as text

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

    Answer: 3.46

    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.

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

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

    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.

  3. Which Excel function returns the largest value from a range?

    Answer: MAX

    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.

  4. Data validation in Excel is used to:

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

    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.

  5. A named range in Excel allows you to:

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

    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.

  6. The =CONCATENATE(A1,' ',B1) formula (or =A1&' '&B1) in Excel will:

    Answer: Join the text in A1, a space, and B1 into a single text string

    CONCATENATE (or the & operator) joins text strings together. =A1&' '&B1 combines the content of A1, then a space, then B1 into one continuous text string — useful for combining first and last names, for example.