USING MICROSOFT EXCEL
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.
Detailed explanation-5: -If you want to use the fill color option, first select the cells that you want to add color to. Then, go to the format tab and click on the fill color drop-down menu. From here, you can choose to have all positive numbers be one color and all negative numbers be another color.