Exam 28: Enhancing a Worksheet

You can change which reference books and research sites are available from the Research task pane by clicking the Research list link at the bottom of the task pane.

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

A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.

You can create hyperlinks to ____.

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 ____.

When data with letters is arranged in alphabetical order (A to Z), data with numbers is arranged from lowest to highest, and data with dates is arranged from earliest to latest, it's referred to as descending order.

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

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

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

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.

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.

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.

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

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

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.

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.

Filtering data removes errors.

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

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