Question 1

To display alternate rows with different fill colors in Excel,use the effect known as ____________________.

Accepted Answer

The answer of To display alternate rows with different fill...

Question 2

What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.

Accepted Answer

Conditional formatting applies formattin...

Question 3

In Excel,the ____ table style formats alternating columns in different colors.

Accepted Answer

A)   Banded Rows
B)   Banded Columns
C)   Last Column
D)   First Column

Question 4

Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.

Accepted Answer

A) True 
 B)False

Question 5

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$E1$
C)   A1:E1
D)   A1-E1

Question 6

Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.

Accepted Answer

A)   Format
B)   Orientation
C)   Sorter
D)   Alignment

Question 7

____ use the same file format for their theme files.

Accepted Answer

A)   Microsoft Word,Access,and Excel
B)   Microsoft Word and Excel
C)   Microsoft Excel and PowerPoint
D)   Microsoft Word,Excel,and PowerPoint

Question 8

In the above figure,you can view a preview of the border style by looking under the heading "____."

Accepted Answer

A)   Line
B)   Presets
C)   Color
D)   Border

Question 9

In the Paste Special dialog box,you can ____

Accepted Answer

A)   select to rotate selected range 90 degrees
B)   paste only formulas
C)   paste values and formats
D)   all of the above

Question 10

Setting the ____ to A1:L10 will print only data in those cells.

Accepted Answer

A)   Page Format
B)   Print Area
C)   Page Break
D)   Print Preview

Question 11

The background image does not affect any cell's ____.

Accepted Answer

A)   format
B)   content
C)   both a.and b.
D)   neither a.nor b. C

Question 12

When you use conditional formatting to highlight cells in a worksheet,you do not need to include a legend.

Accepted Answer

A) True 
 B)False

Question 13

Modifying the number format affects the value stored in the workbook.

Accepted Answer

A) True 
 B)False

Question 14

When you don't want to associate a font with a particular design,you use a ____ font.

Accepted Answer

A)   theme
B)   serif
C)   sans serif
D)   non-theme

Question 15

A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows.

Accepted Answer

A)   theme
B)   style
C)   structure
D)   band B

Question 16

The appearance of text is determined by its type character._________________________

Accepted Answer

A) True 
 B)False

Question 17

If you revise a style in Excel,the appearance of any cell formatted with that style must be updated manually.

Accepted Answer

A) True 
 B)False

Question 18

The region that is sent to the printer from the active sheet is known as the ___________________.

Accepted Answer

print area

Question 19

The most efficient way to format an entire table is to ____.

Accepted Answer

A)   select all and format each element
B)   use a table style
C)   use the format painter
D)   format each cell individually

Question 20

To avoid splitting a worksheet in awkward places,you can insert a(n) ____ to specify a specific breaking point.

Accepted Answer

A)   page break
B)   manual page break
C)   print area
D)   selection

Exam 2: Formatting a Workbook

To display alternate rows with different fill colors in Excel,use the effect known as ____________________.

Correct AnswerverifiedShow Answer

What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.

Correct AnswerverifiedConditional formatting applies formattin...View AnswerShow Answer

In Excel,the ____ table style formats alternating columns in different colors.

Correct AnswerverifiedShow Answer

Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.

Correct AnswerverifiedShow Answer

____ use the same file format for their theme files.

Correct AnswerverifiedShow Answer

In the above figure,you can view a preview of the border style by looking under the heading "____."

Correct AnswerverifiedShow Answer

In the Paste Special dialog box,you can ____

Correct AnswerverifiedShow Answer

Setting the ____ to A1:L10 will print only data in those cells.

Correct AnswerverifiedShow Answer

The background image does not affect any cell's ____.

Correct AnswerverifiedC

When you use conditional formatting to highlight cells in a worksheet,you do not need to include a legend.

Correct AnswerverifiedShow Answer

Modifying the number format affects the value stored in the workbook.

Correct AnswerverifiedShow Answer

When you don't want to associate a font with a particular design,you use a ____ font.

Correct AnswerverifiedShow Answer

A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows.

Correct AnswerverifiedB

The appearance of text is determined by its type character._________________________

Correct AnswerverifiedShow Answer

If you revise a style in Excel,the appearance of any cell formatted with that style must be updated manually.

Correct AnswerverifiedShow Answer

The region that is sent to the printer from the active sheet is known as the ___________________.

Correct Answerverifiedprint area

The most efficient way to format an entire table is to ____.

Correct AnswerverifiedShow Answer

To avoid splitting a worksheet in awkward places,you can insert a(n) ____ to specify a specific breaking point.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Conditional formatting applies formattin...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
print area

Correct Answer
verified

Correct Answer
verified