Question 1

To set a page break in Excel,select the _____.

Accepted Answer

A) first cell below the row where you want to insert a page break 
B) first cell above the row where you want to insert a page break 
C) row above where you want to insert a page break 
D) row below where you want to insert a page break 
A) first cell below the row where you want to insert a page break 
B) first cell above the row where you want to insert a page break 
C) row above where you want to insert a page break 
D) row below where you want to insert a page break

Question 2

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

Question 3

The cell reference for the merged cell is the $\underline { \text { upper-right }   }$ cell reference._________________________

Accepted Answer

A) True 
 B)False

Question 4

-In the accompanying figure,it shows that _____ is the theme font used for headings.

Accepted Answer

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

Question 5

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

Question 6

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

-Decreases the decimal place

Accepted Answer

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

Question 7

In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.

Accepted Answer

A) A1!E1! 
B) A1 
C) E1 
D) A1-E1 
A) A1!E1! 
B) A1 
C) E1 
D) A1-E1

Question 8

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

Accepted Answer

A) True 
 B)False

Question 9

The Format Cells dialog box has six tabs,including _____.

Accepted Answer

A) Decimals 
B) Security 
C) Border 
D) Shading 
A) Decimals 
B) Security 
C) Border 
D) Shading

Question 10

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

-Vertically centers the cell content within the cell

Accepted Answer

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

Question 11

-In the accompanying figure,the font in Live Preview is _____.

Accepted Answer

A) Algerian 
B) Calibri 
C) Arial 
D) Calibri Light 
A) Algerian 
B) Calibri 
C) Arial 
D) Calibri Light

Question 12

-In the accompanying figure,the _____ indicates the font is 11pt.

Accepted Answer

A) Font arrow 
B) Font size box 
C) Font color 
D) Font graphic 
A) Font arrow 
B) Font size box 
C) Font color 
D) Font graphic

Question 13

Excel organizes $\underline {  \text { fonts }  }$into theme and non-theme fonts._________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Question 16

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Antoinette's workbook has all the data entered and students' current grades displayed.She would like the current grade cells to display the value in red if it is less than 60.Antoinette needs to add _____ to the cell.

Accepted Answer

A) cell formatting 
B) conditional formatting 
C) highlighting 
D) fill color 
A) cell formatting 
B) conditional formatting 
C) highlighting 
D) fill color

Question 17

After you merge a range into a single cell,you cannot realign its content.

Accepted Answer

A) True 
 B)False

Question 18

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

Accepted Answer

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

Question 20

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

Accepted Answer

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

To set a page break in Excel,select the _____.

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

The cell reference for the merged cell is the $\underline { \text { upper-right } }$ cell reference._________________________

-In the accompanying figure,it shows that _____ is the theme font used for headings.

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

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

In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

The Format Cells dialog box has six tabs,including _____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Vertically centers the cell content within the cell

-In the accompanying figure,the font in Live Preview is _____.

-In the accompanying figure,the _____ indicates the font is 11pt.

Excel organizes $\underline { \text { fonts } }$ into theme and non-theme fonts._________________________

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

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

After you merge a range into a single cell,you cannot realign its content.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

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

To set a page break in Excel,select the _____.

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

The cell reference for the merged cell is the upper-right ‾\underline { \text { upper-right } } upper-right ​ cell reference._________________________

-In the accompanying figure,it shows that _____ is the theme font used for headings.

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

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

In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

The Format Cells dialog box has six tabs,including _____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Vertically centers the cell content within the cell

-In the accompanying figure,the font in Live Preview is _____.

-In the accompanying figure,the _____ indicates the font is 11pt.

Excel organizes fonts ‾\underline { \text { fonts } } fonts ​ into theme and non-theme fonts._________________________

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

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

After you merge a range into a single cell,you cannot realign its content.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

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

The cell reference for the merged cell is the $\underline { \text { upper-right } }$ cell reference._________________________

Excel organizes $\underline { \text { fonts } }$ into theme and non-theme fonts._________________________