Exam 12: Excel Lesson 6: Enhancing a Worksheet

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.

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

The ____________________ Rules format cells based on comparison operators such as greater than, less than, between, and equal to.

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

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

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

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

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

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry wants to adjust the brightness and contrast. He accesses the Format contextual tab and uses the tools in the ____ group to change the brightness and contrast.

If data is formatted with different font or fill colors, you can sort the data by color.

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

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. To change the username, click the ____ tab, and then click Options in the navigation bar.

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.

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 insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.

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.

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

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.