Question 1

Specify page numbers on the right side of even numbered pages.

Accepted Answer

A) True 
 B)False  False

Question 2

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

Accepted Answer

A)  Landscape 
B)  Portrait 
C)  Vertical Sheet 
D)  Horizontal Sheet 
A)  Landscape 
B)  Portrait 
C)  Vertical Sheet 
D)  Horizontal Sheet B

Question 3

To select a specific area of a worksheet to print, you should first use the _____ button.

Accepted Answer

A)  Select Area 
B)  Worksheet Area 
C)  Print Area 
D)  Area 
A)  Select Area 
B)  Worksheet Area 
C)  Print Area 
D)  Area C

Question 4

Case-Based Critical Thinking Questions Case 7-1 Max wants to save a worksheet as a Web page. What should he do? To make sure that his worksheet will work as a Web page, Max should preview his worksheet in _____ prior to posting the file online.

Accepted Answer

A)  a Web browser 
B)  Print Preview 
C)  Microsoft Word 
D)  Microsoft Excel 
A)  a Web browser 
B)  Print Preview 
C)  Microsoft Word 
D)  Microsoft Excel

Question 5

If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

Accepted Answer

The answer of If no suggested spellings are displayed, click...

Question 6

Which of the following buttons should you click to specify label titles that should be repeated on every page?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 7

Which of the following buttons is used to insert manual page breaks?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 8

You can output Excel worksheets as PDF files using the _____ option on the FILE tab.

Accepted Answer

A)  Export 
B)  Import 
C)  Send to PDF 
D)  Transmit 
A)  Export 
B)  Import 
C)  Send to PDF 
D)  Transmit

Question 9

You can test your worksheet by entering a set of ____________________ values for which you already know the results.

Accepted Answer

The answer of You can test your worksheet by entering...

Question 10

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

Accepted Answer

A)  Frames 
B)  Cells 
C)  Divs 
D)  Tables 
A)  Frames 
B)  Cells 
C)  Divs 
D)  Tables

Question 11

The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.

Accepted Answer

Different First Page : Because the works

Question 12

Referring to the accompanying figure, which callout points to the button that starts printing?

Accepted Answer

A)  H 
B)  F 
C)  D 
D)  B 
A)  H 
B)  F 
C)  D 
D)  B

Question 13

In the accompanying figure, which callout points to the option that allows you to change the default printing option, which prints the active worksheet?

Accepted Answer

A)  A 
B)  B 
C)  C 
D)  D 
A)  A 
B)  B 
C)  C 
D)  D

Question 14

To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.

Accepted Answer

A)  Proofing 
B)  Thesaurus 
C)  Changes 
D)  Research 
A)  Proofing 
B)  Thesaurus 
C)  Changes 
D)  Research

Question 15

Use the Save As option to rename and save an extra copy of your worksheet.

Accepted Answer

A) True 
 B)False

Question 16

You should always ____________________ your worksheets before relying on the results.

Accepted Answer

The answer of You should always ____________________ your worksheets before...

Question 17

Which of the following buttons is used to filter numbers?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 18

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

Accepted Answer

A) True 
 B)False

Question 19

Which one of the following recommendations applies to making the longest data sets go down the screen?

Accepted Answer

A)  Structure your data. 
B)  Make sure your data is entered accurately. 
C)  Remember the rules of mathematical precedence. 
D)  Use absolute and relative references appropriately. 
A)  Structure your data. 
B)  Make sure your data is entered accurately. 
C)  Remember the rules of mathematical precedence. 
D)  Use absolute and relative references appropriately.

Question 20

Which of the following buttons is used to sort the data in one column in descending order?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Specify page numbers on the right side of even numbered pages.

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

To select a specific area of a worksheet to print, you should first use the _____ button.

Case-Based Critical Thinking Questions Case 7-1 Max wants to save a worksheet as a Web page. What should he do? To make sure that his worksheet will work as a Web page, Max should preview his worksheet in _____ prior to posting the file online.

If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

Which of the following buttons should you click to specify label titles that should be repeated on every page?

Which of the following buttons is used to insert manual page breaks?

You can output Excel worksheets as PDF files using the _____ option on the FILE tab.

You can test your worksheet by entering a set of ____________________ values for which you already know the results.

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.

Referring to the accompanying figure, which callout points to the button that starts printing?

In the accompanying figure, which callout points to the option that allows you to change the default printing option, which prints the active worksheet?

To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.

Use the Save As option to rename and save an extra copy of your worksheet.

You should always ____________________ your worksheets before relying on the results.

Which of the following buttons is used to filter numbers?

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

Which one of the following recommendations applies to making the longest data sets go down the screen?

Which of the following buttons is used to sort the data in one column in descending order?

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

Filters

Exam 7: Finalizing a Worksheet

Specify page numbers on the right side of even numbered pages.

_____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.

To select a specific area of a worksheet to print, you should first use the _____ button.

Case-Based Critical Thinking Questions Case 7-1 Max wants to save a worksheet as a Web page. What should he do? To make sure that his worksheet will work as a Web page, Max should preview his worksheet in _____ prior to posting the file online.

If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

Which of the following buttons should you click to specify label titles that should be repeated on every page?

Which of the following buttons is used to insert manual page breaks?

You can output Excel worksheets as PDF files using the _____ option on the FILE tab.

You can test your worksheet by entering a set of ____________________ values for which you already know the results.

_____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.

The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.

Referring to the accompanying figure, which callout points to the button that starts printing?

In the accompanying figure, which callout points to the option that allows you to change the default printing option, which prints the active worksheet?

To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.

Use the Save As option to rename and save an extra copy of your worksheet.

You should always ____________________ your worksheets before relying on the results.

Which of the following buttons is used to filter numbers?

To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.

Which one of the following recommendations applies to making the longest data sets go down the screen?

Which of the following buttons is used to sort the data in one column in descending order?

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

Filters