AAT L3 Spreadsheets for Accounting

Question 1

In Microsoft Excel, which function calculates the sum of a range of cells that meet a specified condition?

Accepted Answer

SUMIF

Answer

SUM

Answer

COUNTIF

Answer

AVERAGE

Question 2

The Excel formula =VLOOKUP(A2,B:D,3,FALSE) will:

Accepted Answer

Return the value in the 3rd column of the range B:D where column B matches A2, using exact match

Answer

Count the number of times A2 appears in column B

Answer

Average all values in column D

Answer

Return an error if A2 is not found in column B

Question 3

Absolute cell references in Excel (e.g., $A$1) are used to:

Accepted Answer

Lock the row and column reference so the reference does not change when the formula is copied

Answer

Prevent a cell from being edited

Answer

Create a named range for the cell

Answer

Apply conditional formatting to the cell

Question 4

The Excel function =IF(B3>100,'Yes','No') will return 'Yes' when:

Accepted Answer

B3 is greater than 100

Answer

B3 equals 100

Answer

B3 is less than 100

Answer

B3 contains text

Question 5

A pivot table in Excel is used to:

Accepted Answer

Summarise, analyse, and rearrange large data sets interactively

Answer

Create a chart from data

Answer

Apply macros to data

Answer

Format cells automatically based on values

Question 6

Which Excel feature automatically formats cells based on their content (e.g., highlighting cells above a certain value in red)?

Accepted Answer

Conditional formatting

Answer

Cell styles

Answer

Data validation

Answer

Pivot charts