Conditional Formatting

10 Questions | Total Attempts: 1034

SettingsSettingsSettings
Please wait...
Conditional Formatting

Questions and Answers
  • 1. 
    When we want to show the Value in bar Chart which option of conditional formatting is used ?
    • A. 

      Data Bar

    • B. 

      Color Scales

    • C. 

      Icons sets

  • 2. 
    A conditional format can make negative numbers red and positive numbers black.
    • A. 

      True

    • B. 

      False

  • 3. 
    In which Tab of Excel Ribbon Conditional formatting can be found ?
    • A. 

      Home

    • B. 

      Insert

    • C. 

      Page layout

    • D. 

      Formula

  • 4. 
    Which type of conditional formatting is shown in this picture ?
    • A. 

      Highlight cell rules

    • B. 

      Color Scale

    • C. 

      Data bars

  • 5. 
    Which option is used for Creating Rules  in Conditional formatting on Excel ?
    • A. 

      New Rules

    • B. 

      Manage Rules

    • C. 

      Clear Rules

  • 6. 
    In icon sets which Color shows the positive Result in Conditional Formatting on Excel ?
    • A. 

      Red

    • B. 

      Yellow

    • C. 

      Green

  • 7. 
    What is the name of this picture ?
    • A. 

      Data bars

    • B. 

      Color Scale

    • C. 

      Icons Sets

  • 8. 
    How many type of conditions are avalible in conditional formatting on Excel ?
    • A. 

      Eight

    • B. 

      Five

    • C. 

      Six

  • 9. 
    In which type of Conditional formatting options you will find in this dialog box ?
    • A. 

      Highlight cell rules

    • B. 

      Top/Bottom Rules

    • C. 

      Manage Rules

  • 10. 
    Which conditional formatting is applied on the data ?
    • A. 

      Color Scale

    • B. 

      Data bars

    • C. 

      Icon Sets

Back to Top Back to top