Exam 7: Formatting Workbook Text and Data

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

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. -Harold has chosen green as the background color for his workbook. He should not use _____ for any of the font or highlight colors.

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.

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

When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.

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

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

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

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

Explain why it is important to use proper formatting, citing at least three benefits of a well-formatted workbook.

MATCHING Match each of the following icons with the description that most closely matches its function. -Forces the cell text to wrap within the cell borders

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

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

A _____ is the space between the page content and the edges of the page.

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

When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

Changing the number of decimal places displayed in a cell does not change the value stored in the cell.

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

____________________ is the process of changing a workbook's appearance by defining the fonts, styles, colors, and decorative features.

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