FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To colour those cells blue where temperature is above 50 degree you will
A
Apply filtering
B
Use fill colour option
C
Shade Cells
D
Use Conditional Formatting
Explanation: 

Detailed explanation-1: -Color Scales are premade types of conditional formatting in Excel used to highlight cells in a range to indicate how large the cell values are compared to the other values in the range.

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: -On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Color Scales. Select a two-color scale. Hover over the color scale icons to see which icon is a two-color scale. The top color represents higher values, and the bottom color represents lower values.

There is 1 question to complete.
Previous
Next