Exam 12: Excel Lesson 6: Enhancing a Worksheet

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

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

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. 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.

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

FIGURE EX 6-1 In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.

The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average.

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.

When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.

The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting.

All images are protected by copyright law.

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

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

The worksheet cell is the hyperlink, not the contents entered in that cell.

FIGURE EX 6-1 In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above. The Set Hyperlink ScreenTip ____ will appear.

Filtering data removes errors.

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Hiding permanently removes a row or column from view.

You can make a perfect square or circle by pressing and holding the F5 key as you drag in the worksheet to draw the shape.

____ are predesigned workbook files that you can use as the basis or model for new workbooks.