Question 1

You can use a picture or image as the background for all the cells in a worksheet.

Accepted Answer

A) True 
 B)False

Question 2

To access the dialog box shown above,you would navigate to the ____ group on the Home tab.

Accepted Answer

A)  Styles 
B)  Font 
C)  Edit 
D)  Appearance 
A)  Styles 
B)  Font 
C)  Edit 
D)  Appearance

Question 3

In Excel,the table style ____ inserts a new row at the bottom of the table that adds the column values.

Accepted Answer

A)  Header Row 
B)  Total Row 
C)  First Row 
D)  Banded Row 
A)  Header Row 
B)  Total Row 
C)  First Row 
D)  Banded Row

Question 4

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

Accepted Answer

The answer of One of the benefits of conditional ____________________...

Question 5

Ajeesh wants to format his Excel table so that every other line is light yellow.He's seen this done on other reports and believes it will make his data easier to follow across rows.Ajeesh begins to apply highlighting to every other line by using the Ctrl key to select the odd rows,but worries that adding and deleting rows will ruin the consistency of his format.What is an alternate solution for Ajeesh?

Accepted Answer

A)  Ajeesh should continue with his current formatting 
B)  use banded rows 
C)  Ajeesh should not apply this formatting 
D)  use Format Painter 
A)  Ajeesh should continue with his current formatting 
B)  use banded rows 
C)  Ajeesh should not apply this formatting 
D)  use Format Painter

Question 6

MATCHING
Match each of the following icons with the description that most closely matches its function.
-Decreases the size of the indentation used in the 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 7

To view certain columns on a large database,a good option is to ____.

Accepted Answer

A)  hide columns without information you need 
B)  delete columns you aren't viewing 
C)  highlight columns you want to view 
D)  use data bars to find content 
A)  hide columns without information you need 
B)  delete columns you aren't viewing 
C)  highlight columns you want to view 
D)  use data bars to find content

Question 8

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 9

-In the figure above,you can see that the following table elements were selected: Header Row and ____.

Accepted Answer

A)  Total Row 
B)  Banded Columns 
C)  First Column 
D)  Last Column 
A)  Total Row 
B)  Banded Columns 
C)  First Column 
D)  Last Column

Question 10

Excel has only two conditional formats-data bars and highlighting.

Accepted Answer

A) True 
 B)False

Question 11

Fonts,colors,and cell styles are organized in ____ categories.

Accepted Answer

A)  theme and non-theme 
B)  numbers and text 
C)  color and black & white 
D)  form and function 
A)  theme and non-theme 
B)  numbers and text 
C)  color and black & white 
D)  form and function

Question 12

MATCHING
Match each of the following icons with the description that most closely matches its function.
-Increases the size of the indentation used in the 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 13

-In the above figure,the preset button labeled ____ adds lines within the 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

Question 14

In Excel,dates are ____-aligned in the cell by default,regardless of date format.

Accepted Answer

A)  right 
B)  left 
C)  center 
D)  not 
A)  right 
B)  left 
C)  center 
D)  not

Question 15

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Accepted Answer

A) True 
 B)False

Question 16

Red-green color blindness is the most common,so avoid using red text on a green background or green text on a red background.

Accepted Answer

A) True 
 B)False

Question 17

____________________ is the process of changing a workbook's appearance by defining the fonts,styles,colors,and decorative features.

Accepted Answer

The answer of ____________________ is the process of changing a...

Question 18

A ____ is not a type of font.

Accepted Answer

A)  serif 
B)  sans serif 
C)  theme 
D)  true type 
A)  serif 
B)  sans serif 
C)  theme 
D)  true type

Question 19

-In the above figure,it shows that ____ is the theme font used for headings.

Accepted Answer

A)  Algerian 
B)  Batang 
C)  Cambria 
D)  Calibri 
A)  Algerian 
B)  Batang 
C)  Cambria 
D)  Calibri

Question 20

A(n)____ specifies formats for elements in an Excel table,such as font color,fill color,and so forth.

Accepted Answer

A)  sheet format 
B)  Excel table 
C)  table style 
D)  style guide 
A)  sheet format 
B)  Excel table 
C)  table style 
D)  style guide

You can use a picture or image as the background for all the cells in a worksheet.

To access the dialog box shown above,you would navigate to the ____ group on the Home tab.

In Excel,the table style ____ inserts a new row at the bottom of the table that adds the column values.

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell

To view certain columns on a large database,a good option is to ____.

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

-In the figure above,you can see that the following table elements were selected: Header Row and ____.

Excel has only two conditional formats-data bars and highlighting.

Fonts,colors,and cell styles are organized in ____ categories.

MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell

-In the above figure,the preset button labeled ____ adds lines within the range.

In Excel,dates are ____-aligned in the cell by default,regardless of date format.

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Red-green color blindness is the most common,so avoid using red text on a green background or green text on a red background.

____________________ is the process of changing a workbook's appearance by defining the fonts,styles,colors,and decorative features.

A ____ is not a type of font.

-In the above figure,it shows that ____ is the theme font used for headings.

A(n)____ specifies formats for elements in an Excel table,such as font color,fill color,and so forth.

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

You can use a picture or image as the background for all the cells in a worksheet.

To access the dialog box shown above,you would navigate to the ____ group on the Home tab.

In Excel,the table style ____ inserts a new row at the bottom of the table that adds the column values.

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell

To view certain columns on a large database,a good option is to ____.

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

-In the figure above,you can see that the following table elements were selected: Header Row and ____.

Excel has only two conditional formats-data bars and highlighting.

Fonts,colors,and cell styles are organized in ____ categories.

MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell

-In the above figure,the preset button labeled ____ adds lines within the range.

In Excel,dates are ____-aligned in the cell by default,regardless of date format.

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Red-green color blindness is the most common,so avoid using red text on a green background or green text on a red background.

____________________ is the process of changing a workbook's appearance by defining the fonts,styles,colors,and decorative features.

A ____ is not a type of font.

-In the above figure,it shows that ____ is the theme font used for headings.

A(n)____ specifies formats for elements in an Excel table,such as font color,fill color,and so forth.

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