Microsoft Excel Advanced Formatting

7 Questions | Total Attempts: 41

SettingsSettingsSettings
Please wait...
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

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

      True

    • B. 

      False

  • 3. 
    You can apply an actual watermark in Excel
    • A. 

      True

    • B. 

      False

  • 4. 
    Which of the following can be used in styles
    • A. 

      Number

    • B. 

      Alignment

    • C. 

      Font

    • D. 

      All of the above

  • 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

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

      True

    • B. 

      False

  • 7. 
    Which one do you like?
    • A. 

      Option 1

    • B. 

      Option 2

    • C. 

      Option 3

    • D. 

      Option 4