USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Align
|
|
|
Conditional Formatting
|
|
|
Merge Cells
|
|
|
Rules Manager
|
Detailed explanation-1: -The correct answer is Conditional formatting. Key Points. Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value. To do Conditional formatting, users need to create a conditional formatting rule.
Detailed explanation-2: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.
Detailed explanation-3: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.
Detailed explanation-4: -Conditional formatting is used to format a cell or a range of cells based on specified criteria. In one report, you can create as many conditions as you need and each condition can apply different formatting rules.