Exam 2: Microsoft Excel Basics

To keep the table formatting intact, it is best to use the commands on the Insert and Delete menus in the ____ group on the Home tab.

Once you select a validation range and enter a validation rule for the validation range, the data entered into this range is no longer monitored.

To open the Shapes gallery, click the Insert tab on the Ribbon, and then, in the ____ group, click the Shapes button.

A ____ chart shows the relationship of a part to a whole.

Case EX 14-1 Lynda is responsible for creating a weekly update report in Excel for her boss detailing the performance of the ice cream store where she works. For each report, Lynda has to carry out the same formatting steps for the heading. To take care of the repetitive task of applying the same formats to the headings of all the reports, Lynda can create a ____.

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.

Excel has many types of Form Controls that allow you to create items that would go on a form, such as a check box, scroll bar, and button.

The ____ is the location in the worksheet where data separated by Excel will be placed.

Case EX 12-1 Jaime loves designing and making hand-made bags and he has started a small business selling his bags over the Internet. To keep track of the orders and their status, he uses a worksheet with the following columns: Order Number, Customer Name, Customer Address, Bag Ordered, and Shipped. Under the Shipped column, Jaime enters "Yes" or "No" based on whether the bag has been shipped or not. If Jaime creates a PivotChart for the data, he can ____ the results so that only the bags that are not shipped yet will be displayed.

To convert a table back to a normal range, but keep the data and table style formatting, click the ____ tab on the Ribbon, then click the Convert to Range option in the Tools group.

The ____ performs a "what-if" analysis that lets you change several cells of data.

The Unprotect Worksheet button is found on the ____ tab.

The ____ tab offers the option to save an Excel workbook as a PDF or as an XPS.

Explain why you might need to use the Subtotal function, instead of the COUNT function, when dealing with filtered data.

If you decide that you no longer need to track changes in a workbook, you can disable the ____________________ feature.

Visual Basic for Applications is a ____.