Exam 2: Microsoft Excel Basics

The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.

The data table used to create a chart appears above the chart.

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

With the Track Changes feature enabled, a(n) border will appear around the changed cells until the file is closed.

The ____ function locates data when it is displayed vertically in the lookup table.

The formula = B3^3 is an example of a(n) ____ operation.

If the Track Changes feature is enabled, it makes the workbook a(n) shared file.

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

To share a workbook with others on the Web, you can ____ the file to the Web.

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

The ____________________ Print Area print option prints the entire worksheet, regardless of what print area is set for that worksheet.

Discuss the reasons for using the Subtotal feature rather than adding formulas in a worksheet.

To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the Home tab of the Ribbon.

Worksheets printed in ____ orientation are wider than they are long.

To open the Data Table dialog box, click the Data tab, click the ____ button in the Data Tools group, and then click Data Table.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?

The horizontal lines within a chart are called the horizontal ____________________.

Headers and footers are each divided into three sections, which you can use to organize the text.

You can keep a chart's height and width in the same proportion by pressing the Shift key as you drag a corner sizing handle.