Question 1

When you don't want to associate a font with a particular design,you use a _____ font.

Accepted Answer

A) theme 
B) serif 
C) sans serif 
D) non-theme 
A) theme 
B) serif 
C) sans serif 
D) non-theme D

Question 2

Explain why it is important to use proper formatting,citing at least three benefits of a well-formatted workbook.

Accepted Answer

Proper formatting is a balance between too little and too much formatting,both of which can make data hard to understand.A well-formatted workbook helps accentuate important trends and relationships in data.A well-formatted workbook can (1)be easier to read,(2)establish a sense of professionalism,(3)help draw attention to the points you want to make,and (4)provide continuity between worksheets.

Question 3

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Accepted Answer

A) Equal to 
B) Between 
C) Duplicate Values 
D) A Date Occurring 
A) Equal to 
B) Between 
C) Duplicate Values 
D) A Date Occurring C

Question 4

Color allows you to effectively enhance a workbook,but could you ever use too much or "bad" color? Explain how or when color might detract from a workbook.Give at least four tips for effective color use.

Accepted Answer

When used wisely,color can enhance any w

Question 5

_____ merges each of the rows in the selected range across the columns in the range.

Accepted Answer

A) Merge build 
B) Merge and Center 
C) Merge Across 
D) Merge Cells 
A) Merge build 
B) Merge and Center 
C) Merge Across 
D) Merge Cells

Question 6

In conditional formatting,to highlight only cells that contain a specific date,select the rule _____.

Accepted Answer

A) A Date Occurring 
B) Duplicate Values 
C) Text That Contains 
D) Equal To 
A) A Date Occurring 
B) Duplicate Values 
C) Text That Contains 
D) Equal To

Question 7

One of the benefits of Live Preview is that it _____.

Accepted Answer

A) lets you see and evaluate different formats as you develop your workbook 
B) shows you what a document will look like when printed 
C) applies thematic styles to your document 
D) allows you to track changes in your document 
A) lets you see and evaluate different formats as you develop your workbook 
B) shows you what a document will look like when printed 
C) applies thematic styles to your document 
D) allows you to track changes in your document

Question 8

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

Accepted Answer

A) True 
 B)False

Question 9

Each header and footer has three sections-a left section,a center section,and a right section.

Accepted Answer

A) True 
 B)False

Question 10

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Accepted Answer

The answer of The ____________________ tab in the Format Cells...

Question 11

$\underline {   \text { Calculated }  }$ values too large to fit into the cell are displayed in scientific notation._________________________

Accepted Answer

A) True 
 B)False

Question 12

If you want to print only part of a worksheet,you can set a(n)$\underline { \text { print area }   }$,which is the region of the worksheet that is sent to the printer._________________________

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

Accepted Answer

The answer of The ____________________ copies the formatting from one...

Question 14

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Accepted Answer

The answer of Use the ____________________ button in the Alignment...

Question 15

-In the accompanying figure,the number 1 displays _____.

Accepted Answer

A) alignment buttons 
B) centered text 
C) indented text 
D) borders above and below cell content 
A) alignment buttons 
B) centered text 
C) indented text 
D) borders above and below cell content

Question 16

MATCHING
Match each of the following icons with the description that most closely matches its function.

-Aligns the cell content with the cell's bottom edge

Accepted Answer

A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)  
A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)

Question 17

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation.
-Harold needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.

Accepted Answer

A) use Format Painter 
B) format each element using the Toolbar 
C) select all cells and use the Formatting dialog box 
D) apply a table style 
A) use Format Painter 
B) format each element using the Toolbar 
C) select all cells and use the Formatting dialog box 
D) apply a table style

Question 18

MATCHING
Match each of the following icons with the description that most closely matches its function.

-Merges the selected cells into a single cell

Accepted Answer

A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)  
A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)

Question 19

MATCHING
Match each of the following icons with the description that most closely matches its function.

-Forces the cell text to wrap within the cell borders

Accepted Answer

A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)  
A)   
B)   
C)   
D)   
E)  
F) 
G) 
H) 
I) 
J)

Question 20

When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

Accepted Answer

A) journal 
B) documentation sheet 
C) legend 
D) formula sheet 
A) journal 
B) documentation sheet 
C) legend 
D) formula sheet

When you don't want to associate a font with a particular design,you use a _____ font.

Explain why it is important to use proper formatting,citing at least three benefits of a well-formatted workbook.

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Color allows you to effectively enhance a workbook,but could you ever use too much or "bad" color? Explain how or when color might detract from a workbook.Give at least four tips for effective color use.

_____ merges each of the rows in the selected range across the columns in the range.

In conditional formatting,to highlight only cells that contain a specific date,select the rule _____.

One of the benefits of Live Preview is that it _____.

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

Each header and footer has three sections-a left section,a center section,and a right section.

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

$\underline { \text { Calculated } }$ values too large to fit into the cell are displayed in scientific notation._________________________

If you want to print only part of a worksheet,you can set a(n) $\underline { \text { print area } }$ ,which is the region of the worksheet that is sent to the printer._________________________

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

-In the accompanying figure,the number 1 displays _____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's bottom edge

MATCHING Match each of the following icons with the description that most closely matches its function. -Merges the selected cells into a single cell

MATCHING Match each of the following icons with the description that most closely matches its function. -Forces the cell text to wrap within the cell borders

When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 2: Formatting Workbook Text and Data

When you don't want to associate a font with a particular design,you use a _____ font.

Explain why it is important to use proper formatting,citing at least three benefits of a well-formatted workbook.

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Color allows you to effectively enhance a workbook,but could you ever use too much or "bad" color? Explain how or when color might detract from a workbook.Give at least four tips for effective color use.

_____ merges each of the rows in the selected range across the columns in the range.

In conditional formatting,to highlight only cells that contain a specific date,select the rule _____.

One of the benefits of Live Preview is that it _____.

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.

Each header and footer has three sections-a left section,a center section,and a right section.

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Calculated ‾\underline { \text { Calculated } } Calculated ​ values too large to fit into the cell are displayed in scientific notation._________________________

If you want to print only part of a worksheet,you can set a(n) print area ‾\underline { \text { print area } } print area ​ ,which is the region of the worksheet that is sent to the printer._________________________

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

-In the accompanying figure,the number 1 displays _____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's bottom edge

MATCHING Match each of the following icons with the description that most closely matches its function. -Merges the selected cells into a single cell

MATCHING Match each of the following icons with the description that most closely matches its function. -Forces the cell text to wrap within the cell borders

When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

Getting Started With Excel

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

$\underline { \text { Calculated } }$ values too large to fit into the cell are displayed in scientific notation._________________________

If you want to print only part of a worksheet,you can set a(n) $\underline { \text { print area } }$ ,which is the region of the worksheet that is sent to the printer._________________________