Question 1

When selecting the cells for a chart, include the cells that contain values and they will be used to identify the lines, columns, or pie slices on the chart.

Accepted Answer

A) True 
 B)False

Question 2

In Page Layout view, gridlines are shown in light ____ unless you turn them off.

Accepted Answer

A) red 
B) yellow 
C) green 
D) blue 
A) red 
B) yellow 
C) green 
D) blue

Question 3

It's a good idea to use the Save option to rename and save an extra copy of your worksheet before testing your worksheet for errors._________________________

Accepted Answer

A) True 
 B)False

Question 4

Pages that contain cells that will be printed are displayed in ____.

Accepted Answer

A) gray 
B) white 
C) yellow 
D) cream 
A) gray 
B) white 
C) yellow 
D) cream

Question 5

Excel has many Page Setup options.Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

Accepted Answer

-Portrait orientation prints a wo

Question 6

When using the spell checker, if the correct spelling appears in the Recommendations list, click to select it, then click the Change button to correct the misspelled word._________________________

Accepted Answer

A) True 
 B)False

Question 7

-Referring to the figure above, to rotate the clip art you would drag ____.

Accepted Answer

A) any of the circles on the border surrounding the graphic 
B) any of the squares on the border surrounding the graphic 
C) the green handle located at the top of the graphic 
D) none of the above 
A) any of the circles on the border surrounding the graphic 
B) any of the squares on the border surrounding the graphic 
C) the green handle located at the top of the graphic 
D) none of the above

Question 8

To enter Page Layout view, click the ____ tab, then select Page Layout.

Accepted Answer

A) Cells 
B) Numbers 
C) View 
D) Print 
A) Cells 
B) Numbers 
C) View 
D) Print

Question 9

When using the spell checker, if no suggested spellings are displayed, click the Not in Dictionary text box, then type the correct word._________________________

Accepted Answer

A) True 
 B)False

Question 10

When making changes to a chart, make sure the chart is selected so that Excel displays all of the charting tabs which includes ____.

Accepted Answer

A) Design 
B) Layout 
C) Format 
D) all of the above 
A) Design 
B) Layout 
C) Format 
D) all of the above

Question 11

Graphics can be resized using the ____ "handles" that appear on the edges of a selected graphic.

Accepted Answer

A) round 
B) triangular 
C) square 
D) rectangle 
A) round 
B) triangular 
C) square 
D) rectangle

Question 12

____________________, the lines that separate one cell from another, can be printed to create visual boundaries for rows and columns.

Accepted Answer

The answer of ____________________, the lines that separate one cell...

Question 13

-In the figure above, an example of an axis title is ____.

Accepted Answer

A) Papaya-Maya Annual Fund Raiser 
B) Fund Raisers 
C) Teams 
D) $200,000 
A) Papaya-Maya Annual Fund Raiser 
B) Fund Raisers 
C) Teams 
D) $200,000

Question 14

It's a good idea to use the Quick Save option to rename and save an extra copy of your worksheet before testing, just in case your test significantly changes the worksheet.

Accepted Answer

A) True 
 B)False

Question 15

To select a different chart type, select the Design tab, and then click the ____ button.

Accepted Answer

A) Change Chart Type 
B) Swap Chart Type 
C) Format Chart Type 
D) Choose Chart Type 
A) Change Chart Type 
B) Swap Chart Type 
C) Format Chart Type 
D) Choose Chart Type

Question 16

If the chart doesn't seem to make sense, make sure the chart is selected and try clicking the Switch Row/Column button in the ____ group.

Accepted Answer

A) Page 
B) Data 
C) Chart 
D) Format 
A) Page 
B) Data 
C) Chart 
D) Format

Question 17

Case 14-1
Juliet wants to save a worksheet as a Web page. Please answer the questions below.
-To save her worksheet as a Web page, Juliet first access the Save As dialog box, clicks a Selection option, chooses an ____ file type, names her file, and clicks Save.

Accepted Answer

A) HTTP 
B) HTML 
C) XML 
D) JavaScript 
A) HTTP 
B) HTML 
C) XML 
D) JavaScript

Question 18

Worksheet headings are the column letters and row numbers._________________________

Accepted Answer

A) True 
 B)False

Question 19

Vector drawings can be created using Excel's drawing tools._________________________

Accepted Answer

A) True 
 B)False

Question 20

____________________ orientation prints a worksheet on a vertically oriented page.

Accepted Answer

The answer of ____________________ orientation prints a worksheet on a...

Exam 14: Finalizing a Worksheet

When selecting the cells for a chart, include the cells that contain values and they will be used to identify the lines, columns, or pie slices on the chart.

In Page Layout view, gridlines are shown in light ____ unless you turn them off.

It's a good idea to use the Save option to rename and save an extra copy of your worksheet before testing your worksheet for errors._________________________

Pages that contain cells that will be printed are displayed in ____.

Excel has many Page Setup options.Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.

When using the spell checker, if the correct spelling appears in the Recommendations list, click to select it, then click the Change button to correct the misspelled word._________________________

-Referring to the figure above, to rotate the clip art you would drag ____.

To enter Page Layout view, click the ____ tab, then select Page Layout.

When using the spell checker, if no suggested spellings are displayed, click the Not in Dictionary text box, then type the correct word._________________________

When making changes to a chart, make sure the chart is selected so that Excel displays all of the charting tabs which includes ____.

Graphics can be resized using the ____ "handles" that appear on the edges of a selected graphic.

____________________, the lines that separate one cell from another, can be printed to create visual boundaries for rows and columns.

-In the figure above, an example of an axis title is ____.

It's a good idea to use the Quick Save option to rename and save an extra copy of your worksheet before testing, just in case your test significantly changes the worksheet.

To select a different chart type, select the Design tab, and then click the ____ button.

If the chart doesn't seem to make sense, make sure the chart is selected and try clicking the Switch Row/Column button in the ____ group.

Case 14-1 Juliet wants to save a worksheet as a Web page. Please answer the questions below. -To save her worksheet as a Web page, Juliet first access the Save As dialog box, clicks a Selection option, chooses an ____ file type, names her file, and clicks Save.

Worksheet headings are the column letters and row numbers._________________________

Vector drawings can be created using Excel's drawing tools._________________________

____________________ orientation prints a worksheet on a vertically oriented page.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows 7

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Finalizing a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters