Exam 2: Microsoft Excel Basics

A ____ is a character, such as a comma, space, or a tab, used to separate data.

Because Excel includes so many functions, the best way to select a function is from the Excel Help.

You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.

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. Jaime wants to be able to easily rearrange and summarize the data and view it in different ways. He needs to use a ____.

The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

Hiding permanently removes a row or column from view.

Formulas can include more than one operator.

When you open a workbook with macros, a security warning appears on the ____________________.

A ____ is the total of only specific parts of the data.

The active sheet has a blue sheet tab.

To sort data, you first click a cell in the column by which you want to sort a range of data. Click the Data tab on the Ribbon. In the ____ group, click ascending or descending sort.

When you select the chart style, click a 3-D chart subtype to create a 3-D chart.

The ____ looks like a free-floating note pad.

FIGURE EX 12-1 Item 1 in Figure EX 12-1 above shows a ____.

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

Case EX 14-2 Joe works as the manager of an auto repair shop. To help him with his work, Joe has created a macro for creating a table with a set number of columns. He needs to regularly create these tables in his worksheets. Due to some changes in the information that needs to be entered into the worksheet, Joe realizes that he needs to add another column to the table being created by the macro. To make this change, Joe would need to edit the ____ of the macro.

When you ____ Track Changes, the workbook will no longer be shared.