Exam 7: Formatting Workbook Text and Data

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 wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

Fonts, colors, and cell styles are organized in _____ categories.

As a general rule, you should _____.

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

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

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

MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell

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

The header and footer sections include a _____.

Color allows you to effectively enhance a workbook, but could you ever use too much or "bad" color? Explain how or when color might detract from a workbook. Give at least four tips for effective color use.

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

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -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 _____.

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

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

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 would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

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

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

MATCHING Match each of the following icons with the description that most closely matches its function. -Merges the selected cells into a single cell

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

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.