Exam 7: Excel Module Formatting Workbook Text and Data

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

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

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

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

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

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

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

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

_____ are an example of conditional formats in Excel.

Ten ____________________ colors-dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple-are always available regardless of the workbook's theme.

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

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

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

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

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

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

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

Information that prints on each page, like a company name or logo, may be set as a _____.

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.