Filters
Question type

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

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

_____ are an example of conditional formats in Excel.


A) Data bars
B) Quick Analysis tools
C) Font sets
D) Percentages

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) numbers
B) text
C) universal numbers
D) Greenwich Mean Time

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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.


A) selective
B) nonadjacent
C) consecutive
D) specific

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

A _____ indicates a manual page break.


A) dashed blue line
B) solid blue line
C) dashed red line
D) solid red line

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) Format
B) Cells
C) Format Cells
D) Cells Style

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

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) QuickTool Bar
B) Quick Analysis Tool
C) Quick Formatting Bar
D) Conditional Analysis Tool

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) right
B) left
C) center
D) top

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) theme and non-theme
B) numbers and text
C) color and black and white
D) form and function

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Showing 81 - 100 of 100

Related Exams

Show Answer