Conditional 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 Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,086
Questions: 10 | Attempts: 2,156

SettingsSettingsSettings
Conditional Formatting - Quiz

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

    Correct Answer
    A. Data Bar
    Explanation
    The option of conditional formatting used to show the value in a bar chart is "Data Bar". This option allows for the visualization of data values using horizontal bars of varying lengths, where the length of each bar corresponds to the value it represents. This helps in quickly understanding the relative magnitude of different data points in the chart.

    Rate this question:

  • 2. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A conditional format is a feature in software applications that allows users to apply formatting to cells or data based on specific conditions or criteria. In this case, the condition is whether a number is negative or positive. The statement suggests that if a number is negative, it will be formatted in red, and if it is positive, it will be formatted in black. This is a common use of conditional formatting to visually differentiate between positive and negative numbers. Therefore, the given statement is true.

    Rate this question:

  • 3. 

    In which Tab of Excel Ribbon Conditional formatting can be found ?

    • A.

      Home

    • B.

      Insert

    • C.

      Page layout

    • D.

      Formula

    Correct Answer
    A. Home
    Explanation
    Conditional formatting can be found in the Home tab of the Excel Ribbon. This tab contains various formatting options and tools that allow users to apply conditional formatting rules to their data. By selecting the desired range of cells and navigating to the Conditional Formatting option in the Home tab, users can easily apply formatting rules based on specific conditions or criteria, such as highlighting cells that meet certain values or displaying data bars to represent the magnitude of values.

    Rate this question:

  • 4. 

    Which type of conditional formatting is shown in this picture ?

    • A.

      Highlight cell rules

    • B.

      Color Scale

    • C.

      Data bars

    Correct Answer
    B. Color Scale
    Explanation
    The correct answer is Color Scale. In the picture, we can see that the formatting applied to the cells is a color gradient, where the color changes based on the cell's value. This type of formatting is known as a color scale, as it represents a range of values using different colors.

    Rate this question:

  • 5. 

    Which option is used for Creating Rules  in Conditional formatting on Excel ?

    • A.

      New Rules

    • B.

      Manage Rules

    • C.

      Clear Rules

    Correct Answer
    A. New Rules
    Explanation
    In Excel, the option "New Rules" is used for creating rules in conditional formatting. This option allows users to define specific conditions and formatting styles that will be applied to cells based on those conditions. By selecting "New Rules," users can create custom rules to highlight cells, apply data bars or color scales, or add icon sets based on their desired criteria. This option is essential for organizing and visually enhancing data in Excel worksheets.

    Rate this question:

  • 6. 

    In icon sets which Color shows the positive Result in Conditional Formatting on Excel ?

    • A.

      Red

    • B.

      Yellow

    • C.

      Green

    Correct Answer
    C. Green
    Explanation
    In icon sets used for conditional formatting in Excel, the color green is used to represent a positive result. This means that if a certain condition is met, such as a value being above a certain threshold, the corresponding cell will be highlighted with a green icon. Green is commonly associated with positive outcomes or success, making it a suitable choice for indicating positive results in Excel's conditional formatting.

    Rate this question:

  • 7. 

    What is the name of this picture ?

    • A.

      Data bars

    • B.

      Color Scale

    • C.

      Icons Sets

    Correct Answer
    C. Icons Sets
    Explanation
    The correct answer is "Icons Sets" because the question is asking for the name of the picture, and the picture is showing different sets of icons. The other options, "Data bars" and "Color Scale," do not accurately describe the picture.

    Rate this question:

  • 8. 

    How many type of conditions are avalible in conditional formatting on Excel ?

    • A.

      Eight

    • B.

      Five

    • C.

      Six

    Correct Answer
    B. Five
    Explanation
    There are five types of conditions available in conditional formatting on Excel.

    Rate this question:

  • 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

    Correct Answer
    A. Highlight cell rules
    Explanation
    The correct answer is "Highlight cell rules." In this dialog box, you will find the options for conditional formatting that allow you to highlight cells based on certain rules or conditions. These rules can be applied to format cells with specific text, values, dates, or other criteria. By selecting "Highlight cell rules," you can access various formatting options such as highlighting cells that contain a certain value, are above or below average, or fall within a specific range.

    Rate this question:

  • 10. 

    Which conditional formatting is applied on the data ?

    • A.

      Color Scale

    • B.

      Data bars

    • C.

      Icon Sets

    Correct Answer
    B. Data bars
    Explanation
    Data bars are a type of conditional formatting that is applied on the data. This formatting displays horizontal bars within the cells, where the length of the bar represents the value of the cell relative to the other cells in the selected range. The longer the bar, the higher the value, and the shorter the bar, the lower the value. Data bars are useful for visually comparing and analyzing data within a range.

    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 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 08, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.