Deck 12: Excel Lesson 6: Enhancing a Worksheet

Question 1

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.

Answer 1

False

Question 2

To open the Shapes gallery, click the Insert tab on the Ribbon, and then, in the ____ group, click the Shapes button.

A) Shapes
B) Clip Art
C) Illustrations
D) Pictures

Answer 2

C

Question 3

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

Answer 3

False

Question 4

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
B) Clear Filter To
C) Remove Filter From
D) Remove Filter To

Question 5

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.

Question 6

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.

Question 7

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

Question 8

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

Question 9

Hiding permanently removes a row or column from view.

Question 10

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
B) left-click
C) highlight
D) double-click

Question 11

All images are protected by copyright law.

Question 12

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.

A) Filter
B) Sort
C) Sort & Filter
D) Data

Question 13

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

Question 14

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.

Question 15

The Top/Bottom Rules format cells based on their rank, such as the top 10 items, the bottom 15%, or those that are above average.

Question 16

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

Question 17

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

Question 18

Filter arrows appear in the lower-right corners of the column heading cells.

Question 19

Filtering data removes errors.

Question 20

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
B) Format
C) Edit
D) Styles

Question 21

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. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.

A) computer
B) company
C) copy of Excel
D) copy of Office 2010

Question 22

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry also wants to change the picture's shape and border. He accesses the Format contextual tab and uses the tools in the ____ group to change the shape and color.

A) Picture Styles
B) Arrange
C) Size
D) Adjust

Question 23

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) File
B) Home
C) Insert
D) Data

Question 24

The ____ task pane provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.

A) Research
B) Resource
C) Library
D) Reference

Question 25

To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.

A) Format
B) Shape
C) Data
D) Picture

Question 26

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

A) hyperlink
B) button
C) transporter
D) pop-up cell

Question 27

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

A) Drawing Tools
B) Shape Tools
C) Graphic Tools
D) Editing Tools

Question 28

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.

A) Picture Styles
B) Arrange
C) Size
D) Adjust

Question 29

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

A) Search
B) Editing
C) Proofing
D) Help

Question 30

FIGURE EX 6-1 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.

Question 31

The ____ tab contains tools to edit and format the picture.

A) Edit
B) Format
C) Delete
D) Graphics

Question 32

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
B) Shapes
C) Data
D) Formulas

Question 33

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

A) Forms
B) Templates
C) Formats
D) Images

Question 34

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

A) attachment
B) fax
C) picture
D) shape

Question 35

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.

A) Recycle
B) Remove
C) Erase
D) Delete

Question 36

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

A) SmartClips
B) SmartPictures
C) SmartPhotos
D) SmartArt

Question 37

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

Question 38

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

A) Drawing tab
B) Status bar
C) Side bar
D) Ribbon

Question 39

FIGURE EX 6-1 In order to enter a ScreenTip to go with your hyperlink, you would click ScreenTip in the dialog box shown in Figure EX 6-1 above. The Set Hyperlink ScreenTip ____ will appear.

A) menu
B) wizard
C) status bar
D) dialog box

Question 40

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.

Question 42

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

Question 43

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Question 44

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

Question 45

All of the comments tools are located on the ____________________ tab of the Ribbon in the Comments group.

Question 46

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