DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
edit the font of all the text in the workbook
|
|
|
change the layout of your Excel Workbook
|
|
|
create, modify, apply, remove, and manage conditional formatting, including multiple criteria.
|
|
|
Sort the data in order of A to Z
|
Detailed explanation-1: -In the Conditional Formatting Rules Manager, you can choose to show formatting rules for areas of a workbook that have rules, such as the current selection or a specific worksheet. You can then create, edit, and delete rules as well as manage the precedence of rules for the cells or worksheet you selected.
Detailed explanation-2: -To create the first rule: On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.
Detailed explanation-3: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.
Detailed explanation-4: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.