Excel Recap 4

Excel Recap

By Mr Wilkinson

Multiple Choice

What symbol starts a formula in excel?

• #

• =

• :

• @

Multiple Choice

Which of these is a valid cell reference in excel?

• 1A

• A.1

• A1

• 1-A

Multiple Choice

What happens when you drag the fill handle (small square in the bottom-right corner of a selected cell) down?

• It deletes the cells below

• It copies or continues a pattern.

• It merges all the cells

• It adds a border to the cells.

Hotspot

How do add borders around the cells.

Fill in the Blanks

A selection of cells in Excel is called a

.

Hotspot

Which of these makes the size of the text smaller?

Hotspot

Which of these "Emboldens" the text

"Rows run Right" (horizontally)

"Columns Come down" (vertically)

​REMEMBER

Match

Match the definitions to the words.

• A horizontal line of cells, labeled with numbers (1, 2, 3…)

• A vertical line of cells, labeled with letters (A, B, C…)

• A single box in a worksheet where you type data

Row

Column

Cell

• Row

• Column

• Cell