USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB 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: -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.
Detailed explanation-3: -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.