Microsoft Excel Advanced Formatting

Explanation
Themes are used for colors and fonts

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.

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.

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.

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.

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.