AAT L3 Spreadsheets for Accounting 4

Question 1

Which Excel chart type is most appropriate for showing trends over time?

Accepted Answer

Line chart

Answer

Line charts are ideal for displaying data trends over time — the continuous line clearly shows whether values are rising, falling, or stable across time periods.

Question 2

In Excel, pressing Ctrl+Z will:

Accepted Answer

Undo the last action

Answer

Ctrl+Z is the universal undo shortcut in Excel (and most applications); it reverses the most recent action. Ctrl+Y or Ctrl+Shift+Z redoes an undone action.

Question 3

When copying a formula in Excel and you want the row reference to remain fixed but the column to change, you should use:

Accepted Answer

A$1 (relative column, absolute row)

Answer

A$1 fixes only the row (the $ is before the row number); when the formula is copied horizontally, the column letter changes (relative) but the row remains fixed at row 1.

Question 4

Which Excel function looks up a value in the first row of a range and returns a value from a specified row below it?

Accepted Answer

HLOOKUP

Answer

HLOOKUP (Horizontal Lookup) searches across the first row of a range for a match and returns the corresponding value from a specified row below — the horizontal equivalent of VLOOKUP.

Question 5

In Excel, the shortcut to insert the current date in a cell is:

Accepted Answer

Ctrl+;

Answer

Ctrl+; (Ctrl + semicolon) inserts the current date as a static value in the active cell. Ctrl+Shift+; inserts the current time. Note this is a static entry — it does not update automatically.

AAT Level 3 Practice Test

AAT Level 3 Practice Test

AAT L3 Spreadsheets for Accounting 4