Challenger App

No.1 PSC Learning App

★
★
★
★
★
1M+ Downloads
Which is a specific feature in Excel that allows to apply specific formatting to cells according to certain criteria

AData validation

BConditional formatting

CFilter

DAuto fill

Answer:

B. Conditional formatting

Read Explanation:

That specific feature is called Conditional Formatting. It is one of Excel's most powerful visual tools, used to automatically change the appearance of cells (such as fill color, font color, or borders) based on the value they contain or a specific formula.


Related Questions:

which is the Intersection of a column and a row on a worksheet?
Excel displays the current cell address in the :
Which of the following function in MS-Excel is used to count cells in a range that meets specific criteria ?

Filter in MS-Excel is used for

i. Calculating formulas

ii. Extracting data that meets the defined criteria

iii. Sorting data in ascending/descending order

iv. Analyzing and managing relevant data

Which of the following tabs contains the option to create charts in Excel 2007 ?