Exam 2: Microsoft Excel Basics

Businesses often use all of the following EXCEPT ____ charts to illustrate growth over several periods.

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you entered an incorrect value in one of the cells and wanted to find it, you would choose cell contents as your place to search in the ____ option box.

When an error is located, the Error Checking dialog box gives you information about the error.

When there is more than one level in a PivotTable, the main row heading is referred to as the ____________________.

A worksheet is a collection of workbooks.

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

Figure EX 16-1 To see the options shown in Figure EX 16-1 above, you first need to click the ____ tab.

SmartArt graphics are often used for organizational charts, flowcharts, and decision trees.

FIGURE EX 6-1 In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above. The Set Hyperlink ScreenTip ____ will appear.

After you've created scenarios, the Scenario Manager lets you view them in a formatted report on a separate worksheet.

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George does not want any lines showing within the chart that he creates. He needs to remove the horizontal and vertical ____.

Use the ____ function when the data in the lookup table is listed horizontally in rows.

To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.

If you need to share your files so that other individuals can view them, you might want to consider placing the files on the Web .

The first character of a macro name must be a(n) ____.

When a workbook is saved as a PDF, you need to have Excel installed to open it.

Excel has predefined ____ for numbers such as Greater Than, Less Than, Above Average, and Below Average.

Case EX 3-1 Vanessa is learning how to split a worksheet window. To resize the panes, what should Vanessa do?