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.