Question 1

You can use the Charts group on the Page Layout tab to chart or graph data in your worksheet._________________________

Accepted Answer

A) True 
 B)False  False

Question 2

In the Clip Art task pane, enter a keyword for the type of clip art you would like to use in the ____ text box, then click Go.Choose an image from the available pictures, then close the Clip Art task pane.

Accepted Answer

A)  Search for
B)  Search now
C)  Find now
D)  Find art A

Question 3

When a chart is selected, you can move it or resize it by dragging the sizing handles._________________________

Accepted Answer

A) True 
 B)False  True

Question 4

If your worksheet contains multiple pages, the margin settings apply to ____.

Accepted Answer

A)  selected pages
B)  all pages
C)  the page you are currently viewing
D)  the first page

Question 5

To print only the current worksheet, select the Print ____ option instead of the Print Entire Workbook option.

Accepted Answer

A)  Active sheet(s) 
B)  Current sheet(s) 
C)  Entire sheet(s) 
D)  Chosen sheet(s)

Question 6

In general, most modifications begin by right-clicking the chart element you want to change.

Accepted Answer

A) True 
 B)False

Question 7

The ____ tools allow you to draw simple lines and shapes.

Accepted Answer

A)  Format
B)  Shapes
C)  Painter
D)  Snapshot

Question 8

Data sorted in ascending order will be arranged in reverse alphabetical order-labels that start with Z will be positioned above those that start with Y._________________________

Accepted Answer

A) True 
 B)False

Question 9

Excel can check the spelling of all labels in a worksheet and shows misspelled words with wavy red underlines.

Accepted Answer

A) True 
 B)False

Question 10

To insert clip art, click the cell where you wish to place the graphic.Click the ____ tab, then click Clip Art in the Illustrations group.

Accepted Answer

A)  Home
B)  View
C)  Format
D)  Insert

Question 11

Excel creates a chart based on the data and labels you select from a worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 12

Case 14-1
Juliet wants to save a worksheet as a Web page. Please answer the questions below.
-To make sure that her worksheet will convert successfully to a Web page, Juliet previews her worksheet in ____ prior to posting the file.

Accepted Answer

A)  Windows Explorer
B)  Windows Excel
C)  a Web browser
D)  all of the above

Question 13

If you are not certain which chart type to use, hover the pointer over any of the chart buttons to display a description and usage recommendation.

Accepted Answer

A) True 
 B)False

Question 14

To get a good view of the entire worksheet before you change margins, you might want to reduce the zoom level to ____ 100%.

Accepted Answer

A)  less than
B)  more than
C)  either a.or b.
D)  neither a.nor b.

Question 15

You might want to insert a ____ page break if a page ends with a row that should be grouped with data on the next page.

Accepted Answer

A)  manual
B)  automatic
C)  style
D)  format

Question 16

Orientation refers to the relative positions of the worksheet and the ____.

Accepted Answer

A)  printer
B)  paper
C)  both a.and b.
D)  neither a.nor b.

Question 17

Before printing a multipage worksheet, use ____ view to preview the information that each page will contain.

Accepted Answer

A)  Page Setup
B)  Page Layout
C)  Print Preview
D)  Print Manager

Question 18

A(n) ____________________ chart (sometimes called a column chart) is used to show comparisons.

Accepted Answer

The answer of A(n) ____________________ chart (sometimes called a column...

Question 19

You can add graphics to your Excel worksheet.Please describe the Shapes tools and how you would go about drawing an arrow.Please also describe the Smart Art button and how you would insert SmartArt into your worksheet.

Accepted Answer

The answer of You can add graphics to your Excel...

Question 20

-Referring to the figure above, to insert the money clip art you would click the ____ tab.

Accepted Answer

A)  Home
B)  Insert
C)  Page Layout
D)  Format

Exam 14: Finalizing a Worksheet

You can use the Charts group on the Page Layout tab to chart or graph data in your worksheet._________________________

In the Clip Art task pane, enter a keyword for the type of clip art you would like to use in the ____ text box, then click Go.Choose an image from the available pictures, then close the Clip Art task pane.

When a chart is selected, you can move it or resize it by dragging the sizing handles._________________________

If your worksheet contains multiple pages, the margin settings apply to ____.

To print only the current worksheet, select the Print ____ option instead of the Print Entire Workbook option.

In general, most modifications begin by right-clicking the chart element you want to change.

The ____ tools allow you to draw simple lines and shapes.

Data sorted in ascending order will be arranged in reverse alphabetical order-labels that start with Z will be positioned above those that start with Y._________________________

Excel can check the spelling of all labels in a worksheet and shows misspelled words with wavy red underlines.

To insert clip art, click the cell where you wish to place the graphic.Click the ____ tab, then click Clip Art in the Illustrations group.

Excel creates a chart based on the data and labels you select from a worksheet._________________________

Case 14-1 Juliet wants to save a worksheet as a Web page. Please answer the questions below. -To make sure that her worksheet will convert successfully to a Web page, Juliet previews her worksheet in ____ prior to posting the file.

If you are not certain which chart type to use, hover the pointer over any of the chart buttons to display a description and usage recommendation.

To get a good view of the entire worksheet before you change margins, you might want to reduce the zoom level to ____ 100%.

You might want to insert a ____ page break if a page ends with a row that should be grouped with data on the next page.

Orientation refers to the relative positions of the worksheet and the ____.

Before printing a multipage worksheet, use ____ view to preview the information that each page will contain.

A(n) ____________________ chart (sometimes called a column chart) is used to show comparisons.

You can add graphics to your Excel worksheet.Please describe the Shapes tools and how you would go about drawing an arrow.Please also describe the Smart Art button and how you would insert SmartArt into your worksheet.

-Referring to the figure above, to insert the money clip art you would click the ____ tab.