DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When you use conditional formatting on a cell?
|
|
You want to change the font for every cell in the spreadsheet
|
|
|
You want to hide the contents of a column
|
|
|
You want to highlight negative numbers by using red text
|
|
|
You want to use a formula and function to sum the values in a column
|
Explanation:
Detailed explanation-1: -On the Home tab, click Format > Format Cells. In the Format Cells box, in the Category list, click Custom. In the Type box, enter the following format: 0.00%; [Red]-0.00%. Now, the negative percentage will appear in red highlighting.
Detailed explanation-2: -You can also format negative numbers with red font in Google Sheets using a custom number format. Select the range of cells where you want to make negative numbers red and in the Menu, go to Format > Number > More Formats > Custom number format.
There is 1 question to complete.