SET 4 — Editing, Replacing & Clearing Data

While typing, what does Backspace delete?

Characters to the left of the insertion point.

While editing, what does Delete erase?

Characters to the right of the insertion point.

How can you move the insertion point while editing data?

Use the arrow keys.

How can you enter Edit mode for a completed cell entry?

Double-click the cell or press F2.

What key combination might some keyboards require instead of F2?

FN+F2.

What word appears in the Status bar while you are in Edit mode?

Edit.

Where can you position the insertion point when editing a completed entry?

In the cell or in the Formula bar.

How do you finish editing a cell?

Press Enter or another completion key.

How do you replace existing cell data?

Select the cell, type the new data, and complete the entry.

What happens to the previous contents when you type new data into a selected cell?

The old data is replaced.

How can you remove contents from a cell while preserving its formatting?

Press Delete or use Clear Contents.

Where is the Clear button located?

Home tab, Editing group.

What does Clear All remove?

Formatting and content.

What does Clear Formats remove?

Formatting while keeping the data.

What does Clear Contents remove?

Content while preserving formatting.

What Clear option has the same basic effect as pressing Delete?

Clear Contents.

What does Clear Comments and Notes remove?

Shared comments or attached notes.

What does Clear Hyperlinks remove?

The hyperlink while preserving formatting.

What does Remove Hyperlinks remove?

The hyperlink and its formatting.

What Status bar icon can indicate that macros are being recorded?

A macro recording icon.

What can the Accessibility icon on the Status bar alert you to?

Content that may need audio or visual enhancement for readability.