Question 1

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

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 2

Ten ___________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

Accepted Answer

The answer of Ten ___________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and...

Question 3

To add a ____ to a sheet tab,click the Format button,point to Tab color,and then click a color.

Accepted Answer

A)  fill color 
B)  tab setting 
C)  format color 
D)  formatting style 
A)  fill color 
B)  tab setting 
C)  format color 
D)  formatting style

Question 4

You increase the indentation by roughly one character each time you click the ____________________ button in the Alignment group on the Home tab.

Accepted Answer

The answer of You increase the indentation by roughly one...

Question 5

The ____________________ tab in the Format Cells dialog box in Excel provides options for locking or hiding cells to prevent other users from modifying their contents.

Accepted Answer

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

Question 6

A ____________________ formats the entire table as a single unit.

Accepted Answer

The answer of A ____________________ formats the entire table as...

Question 7

Case Based Critical Thinking Questions
Case 2-2
Ajeesh is part of a team creating a number of files with Microsoft Office.Ajeesh is working with four other team members to create individual files for a joint presentation.Ajeesh is in charge of the Excel workbook for his team.
-Ajeesh wants his team's documents to have a common style and appear as a cohesive unit for a large end-of-year presentation.The easiest way to make all documents appear as a cohesive unit is to ____.

Accepted Answer

A)  save the styles and themes as permanent files for other members of his workgroup 
B)  copy and paste styles when each team member opens a new document 
C)  store all the team's files on a network drive 
D)  use the Save As function when creating new files 
A)  save the styles and themes as permanent files for other members of his workgroup 
B)  copy and paste styles when each team member opens a new document 
C)  store all the team's files on a network drive 
D)  use the Save As function when creating new files

Question 8

The header and footer sections include ____.

Accepted Answer

A)  a left and right section 
B)  a center section only 
C)  a top and bottom section 
D)  a left,right,and center section 
A)  a left and right section 
B)  a center section only 
C)  a top and bottom section 
D)  a left,right,and center section

Question 9

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

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 10

Background images do not print in Excel.

Accepted Answer

A) True 
 B)False

Question 11

The information shown in the box under the heading "Style:" are ____.

Accepted Answer

A)  cell line styles 
B)  data line styles 
C)  heading line styles 
D)  border line styles 
A)  cell line styles 
B)  data line styles 
C)  heading line styles 
D)  border line styles

Question 12

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

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

Applying a table style marks the range as a table,making available tools designed for analyzing tabular data,including ____.

Accepted Answer

A)  the ability to sort data 
B)  transferring data to and from an external file 
C)  filtering data to show only rows that match specified criteria 
D)  all of the above 
A)  the ability to sort data 
B)  transferring data to and from an external file 
C)  filtering data to show only rows that match specified criteria 
D)  all of the above

Question 14

A ____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.

Accepted Answer

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

Question 15

____________________ are the 12 colors that belong to the workbook's theme.

Accepted Answer

The answer of ____________________ are the 12 colors that belong...

Question 16

Applying a table theme also marks the range as an Excel table._________________________

Accepted Answer

A) True 
 B)False

Question 17

You can create a ____ color by specifying a mixture of red,blue,and green color values.

Accepted Answer

A)  standard 
B)  custom 
C)  theme 
D)  automatic 
A)  standard 
B)  custom 
C)  theme 
D)  automatic

Question 18

One of the benefits of Live Preview is that ____.

Accepted Answer

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

Question 19

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 20

By default,text is black and cells have no background fill color.

Accepted Answer

A) True 
 B)False

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

Ten ___________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

To add a ____ to a sheet tab,click the Format button,point to Tab color,and then click a color.

You increase the indentation by roughly one character each time you click the ____________________ button in the Alignment group on the Home tab.

The ____________________ tab in the Format Cells dialog box in Excel provides options for locking or hiding cells to prevent other users from modifying their contents.

A ____________________ formats the entire table as a single unit.

The header and footer sections include ____.

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

Background images do not print in Excel.

The information shown in the box under the heading "Style:" are ____.

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

Applying a table style marks the range as a table,making available tools designed for analyzing tabular data,including ____.

A ____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.

____________________ are the 12 colors that belong to the workbook's theme.

Applying a table theme also marks the range as an Excel table._________________________

You can create a ____ color by specifying a mixture of red,blue,and green color values.

One of the benefits of Live Preview is that ____.

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

By default,text is black and cells have no background fill color.

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

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

Ten ___________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

To add a ____ to a sheet tab,click the Format button,point to Tab color,and then click a color.

You increase the indentation by roughly one character each time you click the ____________________ button in the Alignment group on the Home tab.

The ____________________ tab in the Format Cells dialog box in Excel provides options for locking or hiding cells to prevent other users from modifying their contents.

A ____________________ formats the entire table as a single unit.

The header and footer sections include ____.

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

Background images do not print in Excel.

The information shown in the box under the heading "Style:" are ____.

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

Applying a table style marks the range as a table,making available tools designed for analyzing tabular data,including ____.

A ____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.

____________________ are the 12 colors that belong to the workbook's theme.

Applying a table theme also marks the range as an Excel table._________________________

You can create a ____ color by specifying a mixture of red,blue,and green color values.

One of the benefits of Live Preview is that ____.

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

By default,text is black and cells have no background fill color.

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