Flashcard on Formatting and Themes

Front

Currency is an example of a number format.

Back

True

Front

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

Back

True

Front

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

Back

False

Front

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

Back

True

Front

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

Back

True

Front

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

Back

zero, one, two, three

Front

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

Back

Color

Front

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

Back

conditional formatting

Front

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? Options: Delete the conditional formatting rule., Edit the conditional formatting rule., Format the range in the Font dialog box., Format the range as a table.

Back

Edit the conditional formatting rule.

Front

Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin? Options: On the Margins tab of the Page Setup dialog box, change the number in the Left box.; On the Page Layout tab, set the Width and Height to Automatic and the Scale to 100%; On the Page tab of the Page Setup dialog box, change the Orientation setting.; On the Margins tab of the Page Setup dialog box, click the Preset button.

Back

On the Margins tab of the Page Setup dialog box, change the number in the Left box.