Microsoft Excel Advanced Formatting

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Dhardma1
D
Dhardma1
Community Contributor
Quizzes Created: 12 | Total Attempts: 27,205
Questions: 6 | Attempts: 244

SettingsSettingsSettings
Advanced Excel Quizzes & Trivia

Advanced Unit 2. Formating cells & spreadsheets


Questions and Answers
  • 1. 

    Themes include which elements?

    • A.

      Colors

    • B.

      Fonts

    • C.

      Borders

    • D.

      All of the above

    • E.

      Color & fonts

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

    Rate this question:

  • 2. 

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

    • A.

      True

    • B.

      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:

  • 3. 

    You can apply an actual watermark in Excel

    • A.

      True

    • B.

      False

    Correct Answer
    B. 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:

  • 4. 

    Which of the following can be used in styles

    • A.

      Number

    • B.

      Alignment

    • C.

      Font

    • D.

      All of the above

    Correct Answer
    D. 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:

  • 5. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    B. 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:

  • 6. 

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

    • A.

      True

    • B.

      False

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

    Rate this question:

Quiz Review Timeline +

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.