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

Pie chart

Answer

Bar chart

Answer

Scatter chart

Question 2

In Excel, pressing Ctrl+Z will:

Accepted Answer

Undo the last action

Answer

Redo the last action

Answer

Save the workbook

Answer

Open a new worksheet

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

$A1 (absolute column, relative row)

Answer

$A$1 (absolute column and row)

Answer

A1 (fully relative)

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

VLOOKUP

Answer

INDEX

Answer

MATCH

Question 5

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

Accepted Answer

Ctrl+;

Answer

Ctrl+D

Answer

Ctrl+Shift+;

Answer

Ctrl+T

Question 6

For accountancy purposes, which Excel function would you use to add up invoice amounts only where the invoice date falls within a specific date range?

Accepted Answer

SUMIFS

Answer

SUMIF

Answer

COUNTIFS

Answer

AVERAGEIF