Exam 2: Formatting Workbook Text and Data

By default,Excel displays text in a(n) $\underline { \text { black } }$ font color._________________________

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

____________________ is the process of changing a workbook's appearance by defining the fonts,styles,colors,and decorative features.

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

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

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

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

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

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

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

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

A(n) $\underline { text { theme } }$ is a collection of formatting options that include a specified font,font size,font styles,font color,fill color,and borders._________________________

_____ are an example of conditional formats in Excel.

A _____ indicates a manual page break.

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

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

Text and numbers are displayed $\underline { \text { vertically } }$ within cells._________________________

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

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 wants to print ranges E6:F12 and E16:F22 of his worksheet.These are referred to as _____ cell ranges.