Exam 8: Formatting Workbook Text and Data

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

Changing the number of decimal places displayed in a cell does not change the value stored in the cell._________________________

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

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

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

The background image does not affect any cell's format or content._________________________

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

When you specify a print area for a nonadjacent range,you are also inserting a(n)____________________ page break.

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.

When creating an Excel document,you should avoid using _____ text and background together,since this is the most common form of color blindness.

_____ merges each of the rows in the selected range across the columns in the range.

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.

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

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

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

Text and numbers are displayed vertically within cells._________________________

In one of Harold's columns there are too many numbers after the decimal place.Harold does not need this level of detail.It is distracting from the data and he really only needs two numbers after the decimal.How could Harold make the data appear cleaner in the most efficient way?

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

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.