excel lesson 6 test

you can create hyperlinks to

1. another web page 2. specific location in a workbook 3. an email address

the _______ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options

AutoFilter

______ graphics enhance worksheets by providing a visual representation pf information and ideas

SmartArt

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.

clear filter from

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

comment

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

conditional formatting

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

delete

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

descending

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

drawing tools

Hiding permanently removes a row or column from view.

false

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

false

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

false

filtering data removes errors

false

when you sort data contained in columns of a worksheet, excel includes the column headings

false

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

filtering

the _______ tab contains tools to edit and format the picture

format

the ______ rules format cells based on a comparison operators such as greater than, less than, between, and equal to

highlight cells

a _______ is a reference in a worksheet that opens another file or page when you click it

hyperlink

to insert a SmartArt graphic, click the SmartArt button in the ________ group on the insert tab. the choose a SmartArt graphic dialog box appears

illustrations

to open the shapes gallery, click the insert tab on the ribbon, and then, in the ______ group, click the shapes button

illustrations

anything that appears on the screen that you can select and work with as a whole is known as an ________

object

a(n) _______ is a digital photograph or other image file

picture

to insert a picture from a file, click the _________ button in the illustrations group on the insert tab of the ribbon.

picture

to open the research task pane, click the review tab on the ribbon, and then, in the _____ group, click the research button

proofing

the ______ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias

research

all of the comments are located on the ________ tab of the ribbon in the comments group

review

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

ribbon

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

right click

you can show or hide all the comments in a worksheet by toggling the ______ comments button in the comments group

show all

_______ refers to rearranging the data in a more meaningful order

sort

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.

sort and filter

To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button

styles

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

templates

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

true

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

true

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

true

all images are protected by copyright law

true

when you click the shape you want to insert the pointer changes to a crosshair

true