Exam 2: Microsoft Excel Basics

The chart types are available on the ____ tab in the Charts group.

You designate the portion of the workbook to print on the Area tab in Backstage view.

The code word ____ appears at the top of a macro.

If you are concerned about protecting a workbook from being viewed by unauthorized individuals, you can add password protection to the workbook in Excel.

Whenever you select a range, the Ribbon shows the results of common calculations for the selected cells.

A ____ is a preset collection of design elements, including fonts, colors, and other effects.

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Themes that are loaded with Excel 2010 are located in the ____________________ gallery.

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.

When evaluating formulas, the ____ of parentheses is evaluated first.

Figure EX 17-1 Clicking Item 2 in the Figure EX 17-1 above will ____.

When the Move or Copy dialog box appears, click the To book arrow and click the workbook where you want to move or copy the selected worksheet. After you select the destination workbook, the names of all of its worksheets appear in the ____ sheet box.

You can create a new folder in which to save a file by clicking the New folder button in the Save As ____________________. Type a name for the new folder, and then press the Enter key.

Excel offers the ability to import and export data.

Case EX 15-1 Tracy is currently living in a rental apartment but she wants to buy a condo. She is using a worksheet to figure out how much she would need to save each year to be able to save enough money to make the down payment for the condo in six years. The feature that Tracy needs to use is found on the ____ tab.

Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands .

The AutoFormat button cannot be added to the Quick Access Toolbar.

After you have saved the workbook, you can use the Save command in ____________________ view or the Save button on the Quick Access Toolbar to periodically save the latest version of the workbook with the same name in the same location.

You cannot enter a formula with an incorrect structure in Excel. If you attempt to do so, a(n) ____ appears, explaining the error and providing a possible correction.