DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
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
|
Detailed explanation-1: -Excel Conditional formatting rules are applied to a cell based on the value it holds. In this case, we will check whether the value in a cell in less than 0 or not. If it is, then the cell can be highlighted in a specified color (which would be red in this case).
Detailed explanation-2: -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-3: -You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each cell varies.
Detailed explanation-4: -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.