Exam 7: Formatting Workbook Text and Data

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

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's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.

In conditional formatting, to highlight only cells that contain a specific date, select the rule _____.

A(n) ____________________ is a selection of formatting options using a specific font and color from the current theme.

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks.

A(n) conditional format applies formatting to a cell when its value meets a specified condition. _________________________

-In the accompanying figure, the font in Live Preview is _____.

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

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. -Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1) Select and copy a range. 2) Click the Paste button arrow in the Clipboard group on the HOME Tab. 3) Specify exactly what you want to paste. 4) Click Paste Special to open the dialog box. 5) Select the range where you want to paste the Clipboard contents.

The Format Cells dialog box has six tabs, including _____.

A(n) footer appears at the top of each printed page. _________________________

The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data.

A(n) ____________________ is a key that shows each color used in the worksheet and what it means.

_____ are an example of conditional formats in Excel.

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell

MATCHING Match each of the following icons with the description that most closely matches its function. -Aligns the cell content with the cell's bottom edge

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

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 to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.