Excel Section 4 Concepts Exam

Use options in the Page Setup dialog box with this tab selected to specify printing comments in a worksheet.

--> a. Sheet b. Margins c. Header/Footer d. Page

When you save a workbook in an Excel 97-2003 format, the ____ extension is applied. a. .wk1 b. .123 c. .xlsx d. .xls

.xls

What happens when you click and drag a worksheet tab in Excel? a. The contents of the cells in the worksheet are copied and pasted to a new location. b. The worksheet is moved to a different position in the workbook. c. The width of the tab is increased. d. A copy of the worksheet is created.

The worksheet is moved to a different position in the workbook.

This is the code that Excel enters in a header or footer when the Sheet Name button is clicked.

a. &[SheetName] b. &[Tab] c. &[Name] d. &[Shift]

Convert a file to a different format from the

a. Get External Data group on the Data tab. b. Changes group on the Review tab. --> c. Save As dialog box. d. Workbook connections dialog box.

To insert a comment, click the New Comment button in the Comments group on the ____ tab.

a. Home b. Data --> c. Review d. Insert

How does Excel place comments in a worksheet?

a. It places all comments on one special worksheet tab, which contains only comments. b. It places each comment on its own worksheet tab. c. Comments float in the active worksheet, and can be moved by the user. --> d. It anchors them to the active cell.

Save files in a different format with options at this backstage area.

a. New --> b. Export c. Share d. Info

A formula is said to contain a(n) ____ reference when it references a cell spanning two or more worksheets.

a. absolute b. mixed --> c. 3-D d. relative

What does the Add Level button in the Sort dialog box do? a. adds another row to the dialog box so you can sort by additional columns b. adds a blank column to the right side of your table c. adds another blank row to your table d. adds a row to your table that sums each column

a. adds another row to the dialog box so you can sort by additional columns

In Page Break Preview, grayed-out cells

a. are not within the print area. --> b. are part of the print area. c. contain color fonts or fills. d. will be printed on subsequent pages.

Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called

a. backgrounds. b. charts. --> c. tables. d. templates.

A ____ is used to display only certain records within a table that meet the specified criteria.

a. comment b. template --> c. filter d. sort

In Page Break Preview, page breaks are shown as ____ lines.

a. dashed or solid red b. dashed or solid green --> c. dashed or solid blue d. dashed or solid black

To copy a format from the active cell and paste it multiple times to other cells, begin by ____ the Format Painter button.

a. double right-clicking b. clicking c. right-clicking --> d. double-clicking

The options for choosing a template are available

a. in the New Workbook dialog box. b. in the Styles group on the Home tab. c. on the Insert tab. --> d. at the New backstage area.

How do you activate the worksheet shortcut menu?

a. right-click anywhere in the worksheet --> b. right-click the worksheet tab c. double-click the worksheet tab d. double-click anywhere in the worksheet

A new Excel workbook initially contains

a. two worksheets named Sheet1 and Sheet2. b. three worksheets named Sheet1, Sheet2, and Sheet3. --> c. one worksheet named Sheet1. d. one unnamed worksheet.

When you click the New sheet button, where is the new worksheet placed? a. behind the active worksheet b. at the end of the existing worksheets c. in front of the active worksheet d. at the beginning of the existing worksheets

at the end of the existing worksheets

You can group multiple nonadjacent worksheets by pressing and holding down the ____ key while clicking each tab. a. Alt b. Ctrl c. Del d. Shift

ctrl