When you sort data contained in columns of a worksheet, Excel includes the column headings.

Filtering rearranges the order of the data.

When you click the shape you want to insert the pointer changes to a crosshair.

A picture is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart.

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

When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ____ command.

To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button.

To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu.

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

When the shape is selected, the ____ appear on the Ribbon and contain the Format contextual tab.

When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key.

____ graphics enhance worksheets by providing a visual representation of information and ideas.

To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.

A(n) ____ is a digital photograph or other image file.

To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.

The ____ contextual tab contains tools to edit and format the picture.

A ____ is a cell in a worksheet that opens another file or page when you click it.

You can create hyperlinks to ____.

A ____ is a note attached to a cell that is usually used to explain or identify information contained in the cell.

All of the comments tools are located on the ____ tab of the Ribbon in the Comments group.

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

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.

FIGURE 6-1



Excel Case 6-1
Mariana is adding some hyperlinks to her worksheet. Please refer to the figure above while answering the questions below.

Mariana first wants to access the Insert Hyperlink dialog box shown in Figure 6-1.  What should she do next?

Mariana wants to enter a ScreenTip to her hyperlink.  What are the next steps?

Excel Case 6-2
Harry has inserted a picture into his Excel worksheet and wants to make some adjustments.  Please answer the questions below.

Harry also wants to change the picture’s shape and border. He accesses the Format contextual tab and uses the tools in the ____ group to change the shape and color.