Exam 7: Excel Module Formatting Workbook Text and Data

The header and footer sections include a _____.

Case 2-2 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.

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

A conditional format can make negative numbers red and positive numbers black.

Header and footer elements such as worksheet name, current date, and time are _____ elements.

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

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

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

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

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

A  conditional format applies formatting to a cell when its value meets a specified condition.

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

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

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.

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

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

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

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

Excel organizes fonts into theme and non-theme fonts.

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