Excel — Cells, Formatting & Data — Chapter Test

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

Question 1

The name of a cell (its column letter + row number) is its…

Aformula

Bcell address

Cborder

Ddata type

Question 2

Every formula in Excel begins with…

Aa number

Bthe = sign

Ca letter

Da space

Question 3

Which can a cell HOLD?

Aonly numbers

Bnumbers, text or formulas

Conly text

Donly formulas

Question 4

Seeing ###### in a cell usually means…

Ayou divided by zero

Bthe column is too narrow

Cwrong data type

Dthe file is corrupt

Question 5

Which error means you divided by zero?

A######

B#VALUE!

C#DIV/0!

D#NAME?