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

Settings

• 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

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

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

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

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

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

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

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

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

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

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

Related Topics