Entering Text into Worksheet Cells

Question 1

What are the four ways to edit a cell in a worksheet?

Answer 1

• Click into the formula bar above the worksheet
• Double-click on the cell you wish to edit
• Press F2 within the cell you wish to edit
• Navigate to a cell and type over the contents

Question 2

What is the default behavior of text entered into a cell?

Answer 2

Text will overlap adjacent cells in a given row as needed

Question 3

What is the maximum number of characters that any cell can contain?

Answer 3

Up to 32,000 characters

Question 4

Fill in the blank: The _______ is located above the worksheet and is used to edit cell contents.

Answer 4

[formula bar]

Question 5

True or False: The contents of cell A1 become invisible when something is entered in an adjacent cell.

Answer 5

True

Question 6

Column Width and “Text” Visibility

Answer 6

The amount of visible “text” is constrained or truncated by the width of the column.

Question 7

Column Width and “Number” Visibility

Answer 7

Unlike “Text”, Numbers are not truncated, but they are replaced with hashtags if they exceed the width of the column.

Question 8

Tool Bar Status while cursor is blinking inside a cell

Answer 8

Many toolbar features are disabled while cursor is within a cell. Only commands that are applicable to working within a cell are functional.

Question 9

How do you reactivate all of the toolbar features if you are in cell edit status?

Answer 9

Press enter to jump out of the cell and reactivate full toolbar.

Question 10

Cells can be updated by….

Answer 10

editing from the formula bar or double clicking the cell and editing within the cell. Also you can press the F2 key or go to that cell and type new text and press enter to replace cell contents.