Excel Lessons 6 & 7

The worksheet that appears in the workbook window is called the ______.

ACTIVE SHEET

What is the worksheet that appears in the workbook window?

ACTIVE SHEET

You can create hyperlinks to ______, _______, ______.

ANOTHER WEBSITE, A SPECIFIC LOCATION IN THE CURRENT WORKBOOK, AN EMAIL ADDRESS (all of the above)

You can tell which workbook is active by looking at its title. The active workbook has a _____ title bar.

BLUE

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

COMMENT

What highlights worksheet data by changing the look of cells that meet a specified condition?

CONDITIONAL FORMATTING

When yo uno longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. The press the _____ key.

DELETE

A _______ sort arranges from Z to A, highest to lowest, oldest to newest.

DESCENDING

The location where the data will appear is the ______.

DESTINATION

When the shape is selected, the ______ appear on the ribbon and contain the Format contextual tab.

DRAWING TOOLS

To rename a worksheet, double-click its sheet tab, type the new name, and then press the _____ key.

ENTER

T or F? Each workbook opens with 5 worksheets.

FALSE

T or F? Filtering rearranges the order of the data.

FALSE

T or F? Hiding permanently removes a row or column from view.

FALSE

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

FALSE

T or F? In DESCENDING order data is organized alphabetically (A to Z), lowest to highest (numbers), earliest to latest (dates).

FALSE - ASCENDING

T or F? 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.

FALSE - SHIFT

T or F? FILTERING rearranges data in a more meaningful way.

FALSE - SORTING

T or F? To HIDE a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

FALSE - UNHIDE

T or F? To insert a blank worksheet, click the Insert CELLS tab next to the existing sheet tabs.

FALSE - WORKSHEETS

What displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria?

FILTERING

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

HIGHLIGHT CELLS

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

HYPERLINK

To make a workbook active, just click ______ or ______

ITS TITLE BAR, ANYWHERE IN THE WORKSHEET

What is anything that appears on teh screen that you can select and work with as a whole?

OBJECT

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

PICTURE

The _____ task pane provides acces to info typically found in references such as dictionaries, thesauruses, and encyclopedias.

RESEARCH

What identifies the worksheets within the workbook?

SHEET TAB

You can reposition a worksheet by dragging its _____ to a new location.

SHEET TAB

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

SMARTART

The location the data is being transferred from is _____.

SOURCE

To change the tab color of a worksheet, right-click the sheet tab you want to recolor, point to ______ on the shortcut menu, and then click the color you want for that tab.

TAB COLOR

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

TEMPLATES

When using the Arrange Windows dialog box, what are three of the layout options?

TILED, VERTICAL, CASCADE

T or F? All images are protected by copyright law.

TRUE

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

TRUE

T or F? To rename a worksheet, you can right-click its sheet tab, and then click Rename on the shortcut menu.

TRUE

T or F? To select more than one cell or range in a worksheet, select the first cell or range, hold down the CTRL key, and select each additional cell or range.

TRUE

T or F? Until the worksheets are named, they are identified as Sheet1, Sheet2, and so on.

TRUE

T or F? You can reposition a worksheet by dragging its sheet tab to a new location.

TRUE

The active sheet has a ______ sheet tab.

WHITE

What is a group of adjacent worksheets?

WORKSHEET RANGE

Until the _____ are renamed, they are identified as Sheet1, Sheet2, and so on.

WORKSHEETS