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