Name:     ID: 
 
Email: 

Microsoft Excel Lesson 6

True/False
Indicate whether the statement is true or false.
 

 1. 

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

 2. 

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

 3. 

Filtering data removes errors.
 

 4. 

Hiding permanently removes a row or column from view.
 

 5. 

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

 6. 

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.
 

 7. 

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

 8. 

All images are protected by copyright law.
 

 9. 

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

 10. 

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

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 11. 

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.
a.
Clear Filter From
c.
Remove Filter From
b.
Clear Filter To
d.
Remove Filter To
 

 12. 

To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button.
a.
Formulas
c.
Edit
b.
Format
d.
Styles
 

 13. 

To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu.
a.
right-click
c.
highlight
b.
left-click
d.
double-click
 

 14. 

____ graphics enhance worksheets by providing a visual representation of information and ideas.
a.
SmartClips
c.
SmartPhotos
b.
SmartPictures
d.
SmartArt
 

 15. 

To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.
a.
Illustrations
c.
Data
b.
Shapes
d.
Formulas
 

 16. 

When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.
a.
Drawing tab
c.
Side bar
b.
Status bar
d.
Ribbon
 

 17. 

A(n) ____ is a digital photograph or other image file.
a.
attachment
c.
picture
b.
fax
d.
shape
 

 18. 

The ____ tab contains tools to edit and format the picture.
a.
Edit
c.
Delete
b.
Format
d.
Graphics
 

 19. 

A ____ is a reference in a worksheet that opens another file or page when you click it.
a.
hyperlink
c.
transporter
b.
button
d.
pop-up cell
 

 20. 

You can create hyperlinks to ____.
a.
another Web page
b.
a specific location in the current workbook
c.
an e-mail address
d.
all of the above
 

 21. 

The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.
a.
Research
c.
Library
b.
Resource
d.
Reference
 

 22. 

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.
a.
Search
c.
Proofing
b.
Editing
d.
Help
 
 
FIGURE EX 6-1

nar001-1.jpg
 

 23. 

In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.
a.
Click the cell she wants to use for the hyperlink. On the Insert tab of the Ribbon, in the Links group, click the Hyperlink button.
b.
Right-click the cell or object, and then click Hyperlink on the shortcut menu
c.
either a. or b.
d.
neither a. nor b.
 
 
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.
 

 24. 

To change the username, click the ____ tab, and then click Options in the navigation bar.
a.
File
c.
Insert
b.
Home
d.
Data
 
 
Case EX 6-2
Harry has inserted a picture into his Excel worksheet and wants to make some adjustments.
 

 25. 

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.
a.
Picture Styles
c.
Size
b.
Arrange
d.
Adjust
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Sort
b.
Object
c.
Conditional formatting
d.
Filtering
e.
Comment
 

 26. 

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

 27. 

Rearranging the data in a more meaningful order.
 

 28. 

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

 29. 

Highlights worksheet data by changing the look of cells that meet a specified condition.
 

 30. 

Anything that appears on the screen that you can select and work with as a whole.
 



 
         Start Over