Quiz on Formatting and Themes

Currency is an example of a number format.

• True

• False

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

• True

• False

To change the background color of a cell, you use the Background color button.

• True

• False

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

• True

• False

You use conditional formatting to format a cell based on its value.

• True

• False

The Percent style formats numbers as percentages with _____ decimal places by default.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

• Alignment

• Fonts

• Color

• Styles

To format a range so that all values greater than $500 appear in red, which of the following can you use?

• conditional formatting

• cell formatting

• cell styles

• Quick Access toolbar

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

• Delete the conditional formatting rule.

• Edit the conditional formatting rule.

• Format the range in the Font dialog box.

• Format the range as a table.

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

• left

• center

• bold