Microsoft Excel Advanced Formatting

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Dhardma1
D
Dhardma1
Community Contributor
Quizzes Created: 12 | Total Attempts: 28,233
| Attempts: 257
SettingsSettings
Please wait...
  • 1/6 Questions

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

    • True
    • False
Please wait...
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.

Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    Which of the following can be used in styles

    • Number

    • Alignment

    • Font

    • All of the above

    Correct Answer
    A. All of the above
    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.

    Rate this question:

  • 3. 

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

    • True

    • False

    Correct Answer
    A. 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.

    Rate this question:

  • 4. 

    Themes include which elements?

    • Colors

    • Fonts

    • Borders

    • All of the above

    • Color & fonts

    Correct Answer
    A. Color & fonts
    Explanation
    Themes are used for colors and fonts

    Rate this question:

  • 5. 

    You can apply an actual watermark in Excel

    • True

    • False

    Correct Answer
    A. False
    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.

    Rate this question:

  • 6. 

    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. False
    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.

    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 24, 2012
    Quiz Created by
    Dhardma1
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.