Question 1

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Accepted Answer

A)  Equal to
B)  Between
C)  Duplicate Values
D)  A Date OccurringE) C) and D)
F) A) and B)

Question 2

Harold needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.

Accepted Answer

A)  use Format Painter
B)  format each element using the Toolbar
C)  select all cells and use the Formatting dialog box
D)  apply a table styleE) B) and C)
F) C) and D)

Question 3

Excel organizes fonts into theme and non-theme fonts._________________________

Accepted Answer

A) True 
 B)False

Question 4

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 colorE) All of the above
F) A) and B)

Question 5

Explain how to use conditional formatting effectively.

Accepted Answer

•Document the conditional formats you ...

Question 6

A footer appears at the top of each printed page._________________________

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of The region that is sent to the...

Question 8

Header and footer elements such as worksheet name,current date,and time are _____ elements.

Accepted Answer

A)  descriptive
B)  dynamic
C)  impact
D)  requiredE) All of the above
F) A) and D)

Question 9

By default,Excel displays text in a black font color._________________________

Accepted Answer

A) True 
 B)False

Question 10

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 breakE) A) and B)
F) A) and C)

Question 11

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Accepted Answer

A) True 
 B)False

Question 12

In a workbook's 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, twoE) C) and D)
F) B) and C)

Question 13

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 14

If you want to print only part of a worksheet,you can set a print area,which is the region of the worksheet that is sent to the printer._________________________

Accepted Answer

A) True 
 B)False

Question 15

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin._________________________

Accepted Answer

A) True 
 B)False

Question 16

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

One way to align text over several columns or rows is to ____________________,or combine,several cells into one cell.

Accepted Answer

The answer of One way to align text over several...

Question 19

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

Accepted Answer

The answer of To remove conditional formatting in Excel,click ____________________...

Question 20

The cell reference for the merged cell is the upper-right cell reference._________________________

Accepted Answer

A) True 
 B)False

Exam 8: Formatting Workbook Text and Data

One way to align text over several columns or rows is to ____________________,or combine,several cells into one cell.

Correct AnswerverifiedShow Answer

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

Correct AnswerverifiedShow Answer

A footer appears at the top of each printed page._________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The cell reference for the merged cell is the upper-right cell reference._________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.

Correct AnswerverifiedShow Answer

Harold needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.

Correct AnswerverifiedShow Answer

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Correct AnswerverifiedShow Answer

Header and footer elements such as worksheet name,current date,and time are _____ elements.

Correct AnswerverifiedShow Answer

Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Excel organizes fonts into theme and non-theme fonts._________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain how to use conditional formatting effectively.

Correct Answerverified​•Document the conditional formats you ...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

By default,Excel displays text in a black font color._________________________

Correct AnswerverifiedShow Answer

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

Correct AnswerverifiedShow Answer

If you want to print only part of a worksheet,you can set a print area,which is the region of the worksheet that is sent to the printer._________________________

Correct AnswerverifiedShow Answer

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin._________________________

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

In a workbook's theme,___ colors are designated for text and background,_ colors are used for accents and highlights,and ___ colors are used for hyperlinks.

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

•Document the conditional formats you ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified