Excel Ch 4
Replace Next
At the Find and Replace dialog box with Replace tab selected, which of the following is not one of the buttons that display?
Format
To search for and replace specific cell formatting in a worksheet, use the _ buttons in the expanded Find and Replace dialog box.
Make the first cell active
Before running a spelling check on a worksheet, you should do which of the following?
the Sort dialog box
To sort data in a column other than the first column, use options at
selecting the cells containing the data to be sorted.
To sort data in an Excel worksheet, you should start by
Add footer
Which of the following is not one of the custom print options in the Settings category at the Print backstage area?
Inserts a vertical page break and moves the remaining columns to the next page
If a worksheet contains more than 7 inches of cells across the page, what does Excel do?
Bottom
A footer can be inserted in Page Layout view by clicking the ADD footer option at the _ of the worksheet page.
the current worksheet
By default, Excel's find and replace features search in which of the following?
Gridlines
By default, the _ that show on the Excel worksheet screen do not print.
Sorting
Chapter 4 discuesses the _ feature as one of Excel's basic database functions.
Black and White
If you have used color for text or shading in a worksheet but do not want to print in color, you should select the _ option at the Page Setup dialog box.
dashed blue line; solid blue line
In page Break Preview, a _ indicates a page break inserted automatically by Excel and a(n) _ indicates a page break inserted manually.
Click the redo button
Suppose that you have deleted data from a cell by clicking the Undo button. How can you restore the data you just deleted?
Match entire cell contents
Suppose that you want to replace all occurrences of 100 with 500. what option should you select at the Find and Replace dialog box to prevent 1000 from being replaced by 5000?
Editing; Home
The Find & Select button is in the _ group on the _ tab.
0.75; 0.7
The default margins in Excel are _ inches(es) for the top and bottom margins and _ inch(es) for the left and right margins.
a1:j1
To print the range A1:J1 on every page, type _ in the Rows to repeat at top text box.
Add Level
To display the Then by option in the Sort dialog box, click the _ button.
Print Titles
To have column and/or titles print on every page of a multipage worksheet, click the _ button in the Page Setup group.
From a file
To insert a picture as a background in a worksheet, click the background button and then click the _ option at the insert Pictures window.
the cell below and to the right of where the breaks should intersect
To insert both horizontal and vertical page breaks at the same time, begin by selecting which of the following?
Set Print Area
To print specific areas of a worksheet, select the cells to print, click the Print Area button in the Page Setup group, and the click _ at the drop-down list.
Scale to Fit
Use buttons in file _ group on the Page Layout tab to adjust the printed output of a worksheet to fit the number of pages specified.
relationship among
Use option at the Sort dialog box to maintain the _ the cells.
Ctrl + Z
Use this keyboard shortcut to undo an action.
8.5 x 11 inches
What is the default worksheet page size in Excel?
Zoom to Page
When previewing headers and footers at the Print backstage area, click the _ button to increase and decrease the viewing size of the worksheet.
Then by
When sorting data by more than one column, specify the first column in the Sort by option box at the Sort dialog box and specify the second column in the _ option box.
three
When working in Page Layout view, you can add header text in any or all of _ boxes.
Find Format
When you click Format option at the Format button arrow drop-down list, the _ dialog box displays with these tabs: Number, Alignment, Font Border, Fill, and Protection.
Page Layout; Header & Footer Tools Design
When you click the Header & Footer button, the worksheet displays in _ view and the _ tab becomes active.
filter arrow
When you click the sort &filter button and then click Filter at the drop-down list, a _appears with each column label in the worksheet.
It displays on the screen but does not print
When you insert a background picture using the Background button in the Page Setup group, how does the picture display and print?
Each area prints on a separate page.
When you specify multiple print areas with options at the Print Area button, how do the areas print?
a funnel
Which of the following icons indicates that the rows in a worksheet have been filtered?
Page setup; Header/Footer
You can insert different odd and even page headers and/or footers at the _ dialog box with the _ tab selected.