Microsoft Excel Advanced Formatting
-
Themes include which elements?
-
Colors
-
Fonts
-
Borders
-
All of the above
-
Color & fonts
-
About This Quiz
This Microsoft Excel Advanced Formatting quiz assesses knowledge in themes, styles, watermarks, and special number formats. It helps learners understand advanced Excel features, enhancing their ability to effectively format and present data.
Quiz Preview
- 2.
A style is a named collection of formats that are saved and applied as a group
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 3.
You can apply an actual watermark in Excel
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 4.
Which of the following can be used in styles
-
Number
-
Alignment
-
Font
-
All of the above
Correct Answer
A. All of the aboveExplanation
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.Rate this question:
-
- 5.
When you apply special number formats to data, Excel changes both the cell's apperance and the cell's value
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 6.
Special number formats contain, but are not limited to, zip codes and phone numbers
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
Quiz Review Timeline (Updated): Mar 22, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 24, 2012Quiz Created by
Dhardma1
Back to top