Question 1

A(n)____________________ is text printed in the top margin of each page.

Accepted Answer

The answer of A(n)____________________ is text printed in the top...

Question 2

The code _____ will display the filename of the current workbook.

Accepted Answer

A)  &name
B)  &[File]
C)  +name
D)  +[File]E) B) and D)
F) C) and D)

Question 3

Italic,bold,bold italic,and underline are examples of _____.

Accepted Answer

A)  font themes
B)  font styles
C)  graphics
D)  character settingsE) B) and C)
F) None of the above

Question 4

By default,numbers appear in the _____ and generally display values exactly as you type them.

Accepted Answer

A)  Home tab
B)  General format
C)  General number toolbar
D)  currency formatE) A) and B)
F) None of the above

Question 5

The appearance of non-theme fonts,colors,and effects remains unchanged no matter which theme is applied to the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 6

A theme is a collection of formatting options that include a specified font,font size,font styles,font color,fill color,and borders._________________________

Accepted Answer

A) True 
 B)False

Question 7

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Accepted Answer

The answer of Use the ____________________ button in the Alignment...

Question 8

_____ are an example of conditional formats in Excel.

Accepted Answer

A)  Data bars
B)  Quick Analysis tools
C)  Font sets
D)  PercentagesE) B) and C)
F) All of the above

Question 9

Antoinette wants all her worksheets to have the same formatting for text,colors,and graphical effects applied to create a specific look and feel.Antoinette needs to apply a _____.

Accepted Answer

A)  theme
B)  template
C)  style
D)  fontE) None of the above
F) B) and D)

Question 10

Information that prints on each page,like a company name or logo,may be set as a _____.

Accepted Answer

A)  print setup
B)  copied text
C)  text header
D)  print titleE) B) and D)
F) A) and D)

Question 11

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

Accepted Answer

The answer of A(n)____________________ is a collection of formatting that...

Question 12

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

Question 13

One of the benefits of Live Preview is that it _____.

Accepted Answer

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

Question 14

The header and footer sections include a _____.

Accepted Answer

A)  left and right section
B)  center section only
C)  top and bottom section
D)  left, right, and center sectionE) B) and C)
F) All of the above

Question 15

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

Accepted Answer

A)  Seek
B)  Find
C)  Locate
D)  SearchE) C) and D)
F) B) and C)

Question 16

Each header and footer has three sections-a left section,a center section,and a right section._________________________

Accepted Answer

A) True 
 B)False

Question 17

When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

Accepted Answer

A)  journal
B)  documentation sheet
C)  legend
D)  formula sheetE) All of the above
F) B) and D)

Question 18

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

Accepted Answer

A)  right
B)  left
C)  center
D)  topE) A) and B)
F) B) and D)

Question 19

To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.

Accepted Answer

A)  fill color
B)  tab setting
C)  format color
D)  formatting styleE) C) and D)
F) A) and D)

Question 20

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

Accepted Answer

A)  turn it on
B)  turn it off
C)  copy formatting
D)  paste formattingE) B) and C)
F) C) and D)

Exam 8: Formatting Workbook Text and Data

When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

Correct AnswerverifiedShow Answer

A theme is a collection of formatting options that include a specified font,font size,font styles,font color,fill color,and borders._________________________

Correct AnswerverifiedShow Answer

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

Correct AnswerverifiedShow Answer

One of the benefits of Live Preview is that it _____.

Correct AnswerverifiedShow Answer

Antoinette wants all her worksheets to have the same formatting for text,colors,and graphical effects applied to create a specific look and feel.Antoinette needs to apply a _____.

Correct AnswerverifiedShow Answer

The header and footer sections include a _____.

Correct AnswerverifiedShow Answer

Italic,bold,bold italic,and underline are examples of _____.

Correct AnswerverifiedShow Answer

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Correct AnswerverifiedShow Answer

The appearance of non-theme fonts,colors,and effects remains unchanged no matter which theme is applied to the workbook._________________________

Correct AnswerverifiedShow Answer

Each header and footer has three sections-a left section,a center section,and a right section._________________________

Correct AnswerverifiedShow Answer

A(n)____________________ is text printed in the top margin of each page.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Information that prints on each page,like a company name or logo,may be set as a _____.

Correct AnswerverifiedShow Answer

The code _____ will display the filename of the current workbook.

Correct AnswerverifiedShow Answer

_____ are an example of conditional formats in Excel.

Correct AnswerverifiedShow Answer

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

Correct AnswerverifiedShow Answer

By default,numbers appear in the _____ and generally display values exactly as you type them.

Correct AnswerverifiedShow Answer

To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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

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

Correct Answer
verified

Correct Answer
verified