Microsoft Excel Quiz 1

What do we call the intersection of a row and a column in a spreadsheet?

• Box

• Cell

• Square

• Grid

What is the name of cell in column C and row 5?

• C5

• 5C

• 3E

• C_5

Which of the following is a label?

• =A1+B1

• 2400

• Total

• *3

A value in a cell can be:

• A calculation

• A number

• A text heading

• A file name

What symbol must a formula always start with?

• +

• *

• =

• #

Which one of these is a formula?

• Hello

• 2500

• =B1+C1

• Label

In the spreadsheet cell A1, you typed: Name. What type of cell content is this?

• Label

• Value

• Formula

• Header

Can a cell contain both a label and a formula at the same time?

• Yes

• No

What happens if you type =B2+C2 in a cell?

• It creates a heading

• It displays both numbers

• It adds the values in B2 and C2

• It writes the text “=B2+C2”

Which of these is NOT a valid cell reference?

• A1

• Z10

• 10A

• B5