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
