USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In order to format a cell to show negative numbers as red text, you would use what function?
|
|
Cell contents
|
|
|
Font color
|
|
|
Conditional formatting
|
|
|
All the answers
|
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: -Using IF function The IF function in Excel can be just as effective in making numbers negative. For example, if column A in Excel contains your list and you want column B to contain the negative values, the following IF formula can be used in column B: =IF(A2>0, A2*-1, A2).
There is 1 question to complete.