USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION 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 ____
|
|
Apply filtering
|
|
|
Use fill colour option
|
|
|
Shade Cells
|
|
|
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: -Select a range of cells that you want to format. On the Home tab, in the Styles group, click Conditional Formatting. Point to Color Scales and choose the type you want. Done!
There is 1 question to complete.