Question 1

Which of the following can you format using the Number group in Excel's home tab?

Accepted Answer

A)  currency formats 
B)  numbers to percentages 
C)  commas as a thousands separator 
D)  all of the above 
A)  currency formats 
B)  numbers to percentages 
C)  commas as a thousands separator 
D)  all of the above

Question 2

Italic,bold,bold italic,and underline are examples of ____.

Accepted Answer

A)  font themes 
B)  font styles 
C)  graphics 
D)  character settings 
A)  font themes 
B)  font styles 
C)  graphics 
D)  character settings

Question 3

Formatting changes only the appearance of data - it does not affect the data itself.

Accepted Answer

A) True 
 B)False

Question 4

The Banded Columns element formats alternating columns in different colors._________________________

Accepted Answer

A) True 
 B)False

Question 5

A frame is a line you add along an edge of a cell to improve readability of the data._________________________

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

When preparing to print,you have the option to select ____.

Accepted Answer

A)  the position of the report on the page 
B)  the orientation of the page 
C)  to include headers or footers 
D)  all of the above 
A)  the position of the report on the page 
B)  the orientation of the page 
C)  to include headers or footers 
D)  all of the above

Question 8

You can treat a range of data as a distinct object in a worksheet known as a(n)____.

Accepted Answer

A)  Excel table 
B)  spreadsheet 
C)  data range 
D)  data set 
A)  Excel table 
B)  spreadsheet 
C)  data range 
D)  data set

Question 9

A sans serif font,such as Arial,does not include decorative strokes on each character._________________________

Accepted Answer

A) True 
 B)False

Question 10

Put the following five steps in the order in which you would perform them to use the Paste Special function: ____.
1)Select and copy a range.
2)Click the Paste button arrow in the Clipboard group.
3)Specify exactly what you want to paste.
4)Click Paste Special to open the dialog box.
5)Select the range where you want to paste the Clipboard contents.

Accepted Answer

A)  1,2,4,3,5 
B)  1,2,4,5,3 
C)  1,5,2,4,3 
D)  1,5,2,3,4 
A)  1,2,4,3,5 
B)  1,2,4,5,3 
C)  1,5,2,4,3 
D)  1,5,2,3,4

Question 11

____ theme colors are designated for text and background,____ colors are used for accents and highlights,and ____ colors are used for hyperlinks.

Accepted Answer

A)  Four,two,six 
B)  Two,four,six 
C)  Four,six,two 
D)  Six,four,two 
A)  Four,two,six 
B)  Two,four,six 
C)  Four,six,two 
D)  Six,four,two

Question 12

If a worksheet says 60%,you have used the ____ feature.

Accepted Answer

The answer of If a worksheet says 60%,you have used...

Question 13

A table style treats the table as a single object rather than a collection of cells.

Accepted Answer

A) True 
 B)False

Question 14

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

Too much color can be just as bad as not

Question 15

Dates and times in Excel measure intervals between the specified date and time and ____.

Accepted Answer

A)  January 1,2000 at 12:00pm 
B)  January 1,2000 at 12:00am 
C)  January 1,1900 at 12:00am 
D)  January 1,1900 at 12:00pm 
A)  January 1,2000 at 12:00pm 
B)  January 1,2000 at 12:00am 
C)  January 1,1900 at 12:00am 
D)  January 1,1900 at 12:00pm

Question 16

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)  Between 
A)  A Date Occurring 
B)  Duplicate Values 
C)  Text That Contains 
D)  Between

Question 17

A conditional format applies formatting only when a cell's value meets a specified condition._________________________

Accepted Answer

A) True 
 B)False

Question 18

Typeface is the specific design used for characters and includes ____.

Accepted Answer

A)  lettering 
B)  numbering 
C)  punctuation marks and symbols 
D)  all of the above 
A)  lettering 
B)  numbering 
C)  punctuation marks and symbols 
D)  all of the above

Question 19

In the Format Cells dialog box,the ____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

Accepted Answer

A)  Number 
B)  Font 
C)  Alignment 
D)  Protection 
A)  Number 
B)  Font 
C)  Alignment 
D)  Protection

Question 20

-In the above figure,the preset button labeled ____ adds a border around the entire cell or range.

Accepted Answer

A)  None 
B)  Outline 
C)  Inside 
D)  none of the above 
A)  None 
B)  Outline 
C)  Inside 
D)  none of the above

Which of the following can you format using the Number group in Excel's home tab?

Italic,bold,bold italic,and underline are examples of ____.

Formatting changes only the appearance of data - it does not affect the data itself.

The Banded Columns element formats alternating columns in different colors._________________________

A frame is a line you add along an edge of a cell to improve readability of the data._________________________

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 preparing to print,you have the option to select ____.

You can treat a range of data as a distinct object in a worksheet known as a(n)____.

A sans serif font,such as Arial,does not include decorative strokes on each character._________________________

theme colors are designated for text and background, colors are used for accents and highlights,and colors are used for hyperlinks.

If a worksheet says 60%,you have used the ____ feature.

A table style treats the table as a single object rather than a collection of cells.

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.

Dates and times in Excel measure intervals between the specified date and time and ____.

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

A conditional format applies formatting only when a cell's value meets a specified condition._________________________

Typeface is the specific design used for characters and includes ____.

In the Format Cells dialog box,the ____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

-In the above figure,the preset button labeled ____ adds a border around the entire cell or range.

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

Which of the following can you format using the Number group in Excel's home tab?

Italic,bold,bold italic,and underline are examples of ____.

Formatting changes only the appearance of data - it does not affect the data itself.

The Banded Columns element formats alternating columns in different colors._________________________

A frame is a line you add along an edge of a cell to improve readability of the data._________________________

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 preparing to print,you have the option to select ____.

You can treat a range of data as a distinct object in a worksheet known as a(n)____.

A sans serif font,such as Arial,does not include decorative strokes on each character._________________________

____ theme colors are designated for text and background,____ colors are used for accents and highlights,and ____ colors are used for hyperlinks.

If a worksheet says 60%,you have used the ____ feature.

A table style treats the table as a single object rather than a collection of cells.

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.

Dates and times in Excel measure intervals between the specified date and time and ____.

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

A conditional format applies formatting only when a cell's value meets a specified condition._________________________

Typeface is the specific design used for characters and includes ____.

In the Format Cells dialog box,the ____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

-In the above figure,the preset button labeled ____ adds a border around the entire cell or range.

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

theme colors are designated for text and background, colors are used for accents and highlights,and colors are used for hyperlinks.