You can apply a different theme to each worksheet in your workbook.

True

False

Correct!

Review the section "Formatting with Themes."

Each cell style combines formatting such as font, color, fill, and alignment.

True

False

Correct!

Review the section "Cell Styles."

Troy wants to display positive numbers in green and negative numbers in red so they stand out in his worksheet. He should create a custom number format.

True

False

Correct!

Review the section "Creating Custom Number Formats."

The custom number formatting code 0 is a digit placeholder and is always displayed, so if the cell number format is 000 and the number 17 is entered, the worksheet will display 017.

True

False

Correct!

Review the section "Creating Custom Number Formats."

Changes to the page settings such as margins and orientation can be seen in Normal view.

True

False

Correct!

Review the section "Customizing the Page Setup."

Which statement about document properties is true?

They function as personal notes and reminders for the file creator.

They give users helpful information about the file, such as the author and the last-modified date.

You must manually enter the last-modified date, so it’s good practice to do that before you save the file.

Document properties are visible only to the author or creator of the file.

Correct!

Review the section "Editing Document Properties."

A theme is made up of which three elements?

Colors, fonts, and shapes

Colors, numbers, and effects

Colors, fonts, and effects

Margins, orientation, and size

Correct!

Review the section "Formatting with Themes."

Alison created a new cell style, which she can use to apply the same formatting to headings in:

the same worksheet only

the same column only

any Office file

any worksheet in the current workbook

Correct!

Review the section "Cell Styles."

Which tab is active when you open the Format Cells dialog box?

Either Border or Fill

It depends on how you open the dialog box.

Border

Number, Alignment, or Font

Correct!

Review the section "Using the Format Cells Dialog Box."

Jenny is sending a price list to a Canadian customer and wants to indicate that the prices are in U.S. dollars by including the text USD and the dollar sign with each. Which custom number format code should she use?

“USD”00000

$,###USD

$#,###”USD”

$0,000”USD”

Correct!

Review the section "Creating Custom Number Formats."

Senjay wants to impress his boss by creating a custom number format in his year-end reports. How will his worksheet display if he uses this code? [Blue]+0.0%;[Red]-0.0%;General

One row of data. Cell 1: Growth (in black). Cell 2: +46.2% (in blue). Cell 3: -8.1% (in red). Cell 4: +15.0% (in blue). Cell 5: +34.0% (in blue). Cell 6: +0.0% (in blue). Cell 7: -17.0% (in red). Cell 8: +45.0% (in blue)

One row of data. Cell 1: Growth (in black). Cell 2: +46% (in blue). Cell 3: -8% (in red). Cell 4: +15% (in blue). Cell 5: +34% (in blue). Cell 6: 0 (in black). Cell 7: -17% (in red). Cell 8: +45% (in blue)

One row of data. Cell 1: Growth (in black). Cell 2: +0.46 (in blue). Cell 3: -0.08 (in red). Cell 4: +0.15 (in blue). Cell 5: +0.34 (in blue). Cell 6: 0 (in black). Cell 7: -0.17 (in red). Cell 8: +0.45 (in blue)

One row of data. Cell 1: Growth (in black). Cell 2: +46.2% (in blue). Cell 3: -8.1% (in red). Cell 4: +15.0% (in blue). Cell 5: +34.0% (in blue). Cell 6: 0 (in black). Cell 7: -17.0% (in red). Cell 8: +45.0% (in blue)

Correct!

Review the section "Creating Custom Number Formats."

You created an annual budget worksheet and want to make sure it’s easy to find in the company directory, so you:

save the file with a descriptive name

save the file in the right location

add the keywords annual budget to the document property tags

All of these options

Correct!

Review the section "Editing Document Properties."