Excel — Advanced Features — Chapter Test

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

Question 1
Which function JOINS text together?
AUPPER()
BCOUNTIF()
CCONCATENATE()
DIF()
Question 2
Which function COUNTS cells that meet a condition?
ASUM()
BCOUNTIF()
CLOWER()
DIF()
Question 3
Sorting by Class first, then by Marks within each class, is a…
Asingle sort
Bmulti-level sort
Cfilter
Dchart
Question 4
Restricting a cell to accept only whole numbers 0–100 uses…
Aa chart
Bdata validation
CAutoFilter
DCONCATENATE
Question 5
Automatically colouring failing marks red is…
Aconditional formatting
Bsorting
Ca pie chart
Ddata validation