Excel 7 & 8 Quiz Review
When you click the + button (New Sheet) on the tabs bar, where is a worksheet always inserted?
After the active worksheet
You just created a copy of a worksheet named August. What name does Excel gives it?
August (2)
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Breaks
Which of the following steps is not part of inserting a worksheet into a workbook?
Click Worksheet on the Insert menu tab.
How would you move sheet tabs to a new position in the workbook?
Click and drag the sheet tab to the new location
John would like to remove a worksheet from his workbook. Which option would he choose?
Delete
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?
Delete
Which of the following statements describes how to increase or decrease a column's width?
Drag the boundary next to the column heading.
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
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
Format
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
Formatting
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
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
Freeze Panes
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
Hide
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
Hide
Why would you need to copy a worksheet within a workbook?
It lets you repeat formats and working formulas into a new sheet.
Which term describes the blank portions of a page that fall outside the main body of the printed document?
Margins
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
In which of the following locations are check boxes that you can select to view or print gridlines?
On the Page Layout tab, in the Sheet Options group
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
Page Layout
Which of the following dialog boxes is used to transpose rows and columns?
Paste Special
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.
Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?
Print Titles
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 steps is a method for hiding a single worksheet in a multi-sheet workbook?
Right-click the worksheet's tab and click Hide.
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
Scale
Which command do you use to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks drop-down area
Which of the following statements describes how to you unhide a hidden row or column?
Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Sheet Options
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
You want to insert a cell into your worksheet. Which command do you use?
The Insert command in the Cells group on the HOME tab.
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
Theme
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
Unhide
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.
__________ refers to shrinking or stretching printed output to a percentage of its actual size.
a. Scaling c. both a and b (answer) b. scaling
The __________ is the line between rows or columns.
a. boundary c. both a and b (answer) b. Boundary
The identifying letter at the top of a column is called the _____. (hint: answer is two words)
a. column header c. Column header b. Column Header d. a, b and c (answer)
A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.
a. header b. Header c. both a and b (answer)
__________ is the top-to-bottom measurement of a row, measured in points. (hint: answer is two words)
a. row height c. Row Height b. Row height d. a, b and c (answer)
A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.
theme
To render twice the normal amount of worksheet displayed for any given area of the screen, which of the following settings would you need to change the Zoom to?
50%
Which of the following statements about hidden and unhidden worksheets is correct?
A hidden worksheet cannot be inadvertently deleted.