Question 1

-In the above figure,a filter arrow is ____ of the column title "Month."

Accepted Answer

A)  to the right of 
B)  to the left of 
C)  on top of 
D)  underneath of 
A)  to the right of 
B)  to the left of 
C)  on top of 
D)  underneath of

Question 2

A conditional format can make negative numbers red and positive numbers black.

Accepted Answer

A) True 
 B)False

Question 3

Table styles have six elements that can be turned on or off._________________________

Accepted Answer

A) True 
 B)False

Question 4

When creating an Excel document,you should avoid using ____ text and background together,since this is the most common form of color blindness.

Accepted Answer

A)  red and green 
B)  yellow and blue 
C)  black and white 
D)  red and yellow 
A)  red and green 
B)  yellow and blue 
C)  black and white 
D)  red and yellow

Question 5

The header row in the above figure contains ____.

Accepted Answer

A)  Month,RO1,RO2,RO3,etc. 
B)  The Intelligent Path to Fitness 
C)  X310 Monthly Sales Analysis 
D)  ExerComp 
A)  Month,RO1,RO2,RO3,etc. 
B)  The Intelligent Path to Fitness 
C)  X310 Monthly Sales Analysis 
D)  ExerComp

Question 6

The data shown in the table above appears in ____.

Accepted Answer

A)  banded rows 
B)  banded columns 
C)  alternating rows 
D)  special formatting 
A)  banded rows 
B)  banded columns 
C)  alternating rows 
D)  special formatting

Question 7

When you add a table style,be sure that all formatting is as you want it because table styles in Excel cannot be formatted once applied.

Accepted Answer

A) True 
 B)False

Question 8

-In the above figure,table styles are shown above the following group label: ____.

Accepted Answer

A)  Tools 
B)  Table Styles 
C)  Table Style Options 
D)  External Table Data 
A)  Tools 
B)  Table Styles 
C)  Table Style Options 
D)  External Table Data

Question 9

A ____________________ is text printed in the top margin of each page.

Accepted Answer

The answer of A ____________________ is text printed in the...

Question 10

If you insert a new row at the top of the table,the new row becomes the header row and is formatted with the table style.

Accepted Answer

A) True 
 B)False

Question 11

Information that prints on each page,like a company name or logo,may be set as a(n)____.

Accepted Answer

A)  print setup 
B)  copied text 
C)  text header 
D)  print title 
A)  print setup 
B)  copied text 
C)  text header 
D)  print title

Question 12

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

Accepted Answer

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

Question 13

Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet.However,his columns are truncating his content.What solution could Karl use for making his text visible without losing data?

Accepted Answer

A)  abbreviate all text 
B)  reduce the font size to 8 pt 
C)  click Wrap text 
D)  delete one column 
A)  abbreviate all text 
B)  reduce the font size to 8 pt 
C)  click Wrap text 
D)  delete one column

Question 14

To remove banded rows from an Excel table,first you need to select the ____ tab on the Ribbon.

Accepted Answer

A)  Insert 
B)  Home 
C)  Design 
D)  Page 
A)  Insert 
B)  Home 
C)  Design 
D)  Page

Question 15

A ____________________ is a selection of formatting options using a specific font and color from the current theme.

Accepted Answer

The answer of A ____________________ is a selection of formatting...

Question 16

To remove conditional formatting in Excel,click ____________________ from the Conditional Formatting button.

Accepted Answer

The answer of To remove conditional formatting in Excel,click ____________________...

Question 17

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking ____ on the shortcut menu.

Accepted Answer

A)  Format 
B)  Cells 
C)  Format Cells 
D)  Cells Style 
A)  Format 
B)  Cells 
C)  Format Cells 
D)  Cells Style

Question 18

The Format Cells dialog box has six tabs that does NOT include: ____.

Accepted Answer

A)  Fill 
B)  Protection 
C)  Alignment 
D)  Color 
A)  Fill 
B)  Protection 
C)  Alignment 
D)  Color

Question 19

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)  
K)  
L)   
A)    
B)    
C)   
D)    
E)     
F)  
G)  
H)  
I)  
J)  
K)  
L)

Question 20

A ____________________ is text printed in the bottom margin of each page.

Accepted Answer

The answer of A ____________________ is text printed in the...

-In the above figure,a filter arrow is ____ of the column title "Month."

A conditional format can make negative numbers red and positive numbers black.

Table styles have six elements that can be turned on or off._________________________

When creating an Excel document,you should avoid using ____ text and background together,since this is the most common form of color blindness.

The header row in the above figure contains ____.

The data shown in the table above appears in ____.

When you add a table style,be sure that all formatting is as you want it because table styles in Excel cannot be formatted once applied.

-In the above figure,table styles are shown above the following group label: ____.

A ____________________ is text printed in the top margin of each page.

If you insert a new row at the top of the table,the new row becomes the header row and is formatted with the table style.

Information that prints on each page,like a company name or logo,may be set as a(n)____.

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

Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet.However,his columns are truncating his content.What solution could Karl use for making his text visible without losing data?

To remove banded rows from an Excel table,first you need to select the ____ tab on the Ribbon.

A ____________________ is a selection of formatting options using a specific font and color from the current theme.

To remove conditional formatting in Excel,click ____________________ from the Conditional Formatting button.

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking ____ on the shortcut menu.

The Format Cells dialog box has six tabs that does NOT include: ____.

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

A ____________________ is text printed in the bottom margin of each page.

Getting Started With Excel

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 2: Formatting a Workbook

-In the above figure,a filter arrow is ____ of the column title "Month."

A conditional format can make negative numbers red and positive numbers black.

Table styles have six elements that can be turned on or off._________________________

When creating an Excel document,you should avoid using ____ text and background together,since this is the most common form of color blindness.

The header row in the above figure contains ____.

The data shown in the table above appears in ____.

When you add a table style,be sure that all formatting is as you want it because table styles in Excel cannot be formatted once applied.

-In the above figure,table styles are shown above the following group label: ____.

A ____________________ is text printed in the top margin of each page.

If you insert a new row at the top of the table,the new row becomes the header row and is formatted with the table style.

Information that prints on each page,like a company name or logo,may be set as a(n)____.

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

Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet.However,his columns are truncating his content.What solution could Karl use for making his text visible without losing data?

To remove banded rows from an Excel table,first you need to select the ____ tab on the Ribbon.

A ____________________ is a selection of formatting options using a specific font and color from the current theme.

To remove conditional formatting in Excel,click ____________________ from the Conditional Formatting button.

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking ____ on the shortcut menu.

The Format Cells dialog box has six tabs that does NOT include: ____.

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

A ____________________ is text printed in the bottom margin of each page.

Getting Started With Excel

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters