Exam 8: Formatting Workbook Text and Data

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

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

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

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

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 _____.

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

The header and footer sections include a _____.

_____ are an example of conditional formats in Excel.

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

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 _____.

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

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

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

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

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

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 _____.

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

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.

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

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