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.

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