Excel lesson 8

How would you move sheet tabs to a new position in the workbook?

Click and drag the sheet tab to the new location

Select all the cell blocks in each worksheet of a group individually, before changing the formatting for those blocks.

False

The Find and Replace button brings up the Find and Replace dialog box.

False

When searching for dollar amounts, use a dollar sign in the Find What text box.

False

When you insert a new worksheet into a workbook, a new window appears.

False

You unhide a hidden worksheet window with the Unhide Sheet command.

False

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?

Find & Select

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

Find and Replace

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

Freeze

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?

Freeze

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?

Freeze Panes

John would like to change the order of the worksheets in his workbook. Which option would he choose?

Move

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

Move

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?

Rename

How is an exact copy of a worksheet created within the same workbook?

Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu

How do you change the color of a worksheet tab?

Right-click the tab and select Tab Color.

Which of the following statements about hidden and unhidden worksheets is correct?

A hidden worksheet cannot be inadvertently deleted.

When you click the + button (New Sheet) on the tabs bar, where is a worksheet always inserted?

After the active worksheet

Which of the following steps is required for hiding a worksheet window?

Click Hide on the View menu tab.

Which of the following steps is not part of inserting a worksheet into a workbook?

Click Worksheet on the Insert menu tab.

Which of the following procedures is not a way to delete a worksheet from a workbook?

Press Ctrl + A to select all cells in the worksheet and press Delete.

Why would you need to copy a worksheet within a workbook?

It lets you repeat formats and working formulas into a new sheet.

To render twice the normal amount of worksheet for any given area of the screen, what would you change the Zoom to?

50%

You just created a copy of a worksheet named August. What name does Excel gives it?

August (2)

John would like to remove a worksheet from his workbook. Which option would he choose?

Delete

In order for you to freeze the first column of a worksheet into a frozen pane:

You can click Freeze First Column in the Freeze Panes menu.

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?

String

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?

Tab Color

Changing the magnification of the display does not change the magnification for printing.

True

Find & Select, by default, locates Carol in a search for Caroline, but will not locate Mike in a search for Michael.

True

Freezing a row or column creates what Windows calls a pane.

True

The Arrange All command lets you stack Excel's open windows horizontally or vertically.

True

You can use the Insert dialog box to insert forms you created in advance.

True