Exam 7: Formatting Workbook Text and Data

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

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

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

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

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

A _____ indicates a manual page break.

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

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. -Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

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

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

-In the accompanying figure, the number 4 displays _____.

Text and numbers are displayed vertically within cells. _________________________

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

-In the accompanying figure, it shows that _____ is the theme font used for headings.

-In the accompanying figure, the number 1 displays _____.

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

-In the accompanying figure, an example of a theme font is _____.

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

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

-In the accompanying figure, the number 3 displays _____.