Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, which callout points to the button you should click to select header and footer options?

Accepted Answer

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

Question 3

In the accompanying figure, which callout points to the group of buttons used to add header elements?

Accepted Answer

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

Question 4

To display rows or columns that are hidden, select the rows or columns that border the hidden section, then right-click and choose Show .

Accepted Answer

A) True 
 B)False

Question 5

What should be avoided when developing worksheets?

Accepted Answer

A)  formatting numbers for easy reading 
B)  circular references 
C)  using consistent formats for similar data 
D)  using meaningful labels 
A)  formatting numbers for easy reading 
B)  circular references 
C)  using consistent formats for similar data 
D)  using meaningful labels

Question 6

Use the ____________________ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.

Accepted Answer

The answer of Use the ____________________ option to filter data...

Question 7

To open the Sort dialog box, click the _____ tab, then click the Sort button.

Accepted Answer

A)  HOME 
B)  VIEW 
C)  DATA 
D)  REVIEW 
A)  HOME 
B)  VIEW 
C)  DATA 
D)  REVIEW

Question 8

____________________ orientation prints a worksheet on the page sideways.

Accepted Answer

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

Question 9

If data becomes scrambled as a result of a sort, click the _____ button.

Accepted Answer

A)  Undo 
B)  Save 
C)  Repeat 
D)  Sort 
A)  Undo 
B)  Save 
C)  Repeat 
D)  Sort

Question 10

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 11

Which of the following buttons is used to filter numbers?

Accepted Answer

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

Question 12

If you want formulas to be printed, click the _____ button on the FORMULAS tab.

Accepted Answer

A)  View Formulas 
B)  Show Formulas 
C)  Display Formulas 
D)  Print Formulas 
A)  View Formulas 
B)  Show Formulas 
C)  Display Formulas 
D)  Print Formulas

Question 13

Excel includes predefined headers, and you cannot create your own headers.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

A data management feature that allows you to focus on a subset of the data in a worksheet is called _____.

Accepted Answer

A)  Selecting 
B)  Filtering 
C)  Extracting 
D)  Formatting 
A)  Selecting 
B)  Filtering 
C)  Extracting 
D)  Formatting

Question 16

Which of the following is the normal Excel file format?

Accepted Answer

A)  .excl 
B)  .xlsx 
C)  .xcl 
D)  .exl 
A)  .excl 
B)  .xlsx 
C)  .xcl 
D)  .exl

Question 17

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)

Question 18

Case-Based Critical Thinking Questions Case 14-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 19

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

Accepted Answer

A) True 
 B)False

Question 20

It is a good idea to _____ your worksheet before performing a sort.

Accepted Answer

A)  format 
B)  save 
C)  review 
D)  select 
A)  format 
B)  save 
C)  review 
D)  select

Exam 14: Finalizing a Worksheet

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

In the accompanying figure, which callout points to the button you should click to select header and footer options?

In the accompanying figure, which callout points to the group of buttons used to add header elements?

To display rows or columns that are hidden, select the rows or columns that border the hidden section, then right-click and choose Show .

What should be avoided when developing worksheets?

Use the ____________________ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.

To open the Sort dialog box, click the _____ tab, then click the Sort button.

____________________ orientation prints a worksheet on the page sideways.

If data becomes scrambled as a result of a sort, click the _____ button.

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

Which of the following buttons is used to filter numbers?

If you want formulas to be printed, click the _____ button on the FORMULAS tab.

Excel includes predefined headers, and you cannot create your own headers.

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

A data management feature that allows you to focus on a subset of the data in a worksheet is called _____.

Which of the following is the normal Excel file format?

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

Case-Based Critical Thinking Questions Case 14-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.

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

It is a good idea to _____ your worksheet before performing a sort.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows

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