FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Formatting Workbook Text and Data

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 51

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

_____ are an example of conditional formats in Excel.

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

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

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

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

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.

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

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

A _____ indicates a manual page break.

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

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

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

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

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

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

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

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

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