USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conditional formatting
|
|
|
Merged cells
|
|
|
Paste special
|
|
|
Rules manager
|
Detailed explanation-1: -Excel Conditional Formatting is used to apply certain formatting to data that meets one or more conditions. Just like usual cell formatting, it lets you highlight and differentiate your data in various ways by changing cells’ fill color, font color, border styles, etc.
Detailed explanation-2: -Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. Conditional formatting provides a way to visualize data and make worksheets easier to understand.
Detailed explanation-3: -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.
Detailed explanation-4: -Answer: Conditional formatting enables you to apply desirable formatting features and get you a chance, to even sort the data using the formatted result-such as colors, icons, and data bars-to one or more cells based on the cell value, that is, the value contained in the cell.