Excel — Formulas & Functions — Chapter Test

Answer all 5 questions, then submit. You need 60% to pass. Log in to save progress.

Question 1

Which cell reference STAYS FIXED when a formula is copied?

AA1 (relative)

B$A$1 (absolute)

CA1:A10 (range)

Dnone of them

Question 2

Which function gives the AVERAGE of a range?

A=SUM()

B=AVERAGE()

C=COUNT()

D=MAX()

Question 3

Which function JOINS text together?

AUPPER()

BCONCATENATE()

CCOUNT()

DMIN()

Question 4

=COUNT(A1:A10) returns…

Athe total of the cells

Bhow many cells contain numbers

Cthe average

Dthe largest value

Question 5

AutoFilter is used to…

Adelete rows

Bshow only rows matching a value

Cadd up a column

Dchange colours