Microsoft Excel Advanced Formatting

1. Special number formats contain, but are not limited to, zip codes and phone numbers

True

False

Special number formats, such as zip codes and phone numbers, are examples of specific formats used to represent numerical values. These formats are designed to convey specific information or to adhere to a particular standard. While there may be other types of special number formats, zip codes and phone numbers are commonly recognized examples. Therefore, the statement that "Special number formats contain, but are not limited to, zip codes and phone numbers" is true.

Explanation

Special number formats, such as zip codes and phone numbers, are examples of specific formats used to represent numerical values. These formats are designed to convey specific information or to adhere to a particular standard. While there may be other types of special number formats, zip codes and phone numbers are commonly recognized examples. Therefore, the statement that "Special number formats contain, but are not limited to, zip codes and phone numbers" is true.

2. Which of the following can be used in styles

Number

Alignment

Font

All of the above

All of the options mentioned - Number, Alignment, and Font - can be used in styles. Styles are used to define the appearance of elements in a document or webpage. Number refers to the formatting of numbers, such as decimal places or currency symbols. Alignment determines how text or elements are positioned within a container. Font refers to the typeface, size, and style of the text. Therefore, all of these options can be utilized when defining styles.

Explanation

All of the options mentioned - Number, Alignment, and Font - can be used in styles. Styles are used to define the appearance of elements in a document or webpage. Number refers to the formatting of numbers, such as decimal places or currency symbols. Alignment determines how text or elements are positioned within a container. Font refers to the typeface, size, and style of the text. Therefore, all of these options can be utilized when defining styles.

3. A style is a named collection of formats that are saved and applied as a group

True

False

A style is a named collection of formats that are saved and applied as a group. This means that when you apply a style, it automatically applies multiple formatting settings to the selected text or object, such as font, size, color, alignment, etc. By saving and using styles, it becomes easier to maintain consistency throughout a document or presentation, as you can quickly apply the same formatting to different elements with just a few clicks. Therefore, the statement that a style is a named collection of formats that are saved and applied as a group is true.

Explanation

A style is a named collection of formats that are saved and applied as a group. This means that when you apply a style, it automatically applies multiple formatting settings to the selected text or object, such as font, size, color, alignment, etc. By saving and using styles, it becomes easier to maintain consistency throughout a document or presentation, as you can quickly apply the same formatting to different elements with just a few clicks. Therefore, the statement that a style is a named collection of formats that are saved and applied as a group is true.

4. Themes include which elements?

Colors

Fonts

Borders

All of the above

Color & fonts

Themes are used for colors and fonts

Explanation

Themes are used for colors and fonts

5. You can apply an actual watermark in Excel

True

False

In Excel, you cannot directly apply an actual watermark to a worksheet or a cell. While you can add a background image or text to a worksheet, it is not considered a true watermark as it can easily be removed or edited. Watermarks are typically added to documents in word processing or graphic design software, not in Excel.

Explanation

In Excel, you cannot directly apply an actual watermark to a worksheet or a cell. While you can add a background image or text to a worksheet, it is not considered a true watermark as it can easily be removed or edited. Watermarks are typically added to documents in word processing or graphic design software, not in Excel.

6. When you apply special number formats to data, Excel changes both the cell's apperance and the cell's value

True

False

When you apply special number formats to data in Excel, it only changes the cell's appearance and not the cell's value. This means that the way the data is displayed may be altered, but the actual value stored in the cell remains the same.

Explanation

When you apply special number formats to data in Excel, it only changes the cell's appearance and not the cell's value. This means that the way the data is displayed may be altered, but the actual value stored in the cell remains the same.