DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Apply filtering
|
|
|
Use fill colour option
|
|
|
Shade Cells
|
|
|
Use Conditional Formatting
|
Detailed explanation-1: -Format cells by using color scales On the Home tab, under Format, click Conditional Formatting. Point to Color Scales, and then click the color scale format that you want. The top color represents larger values, the center color, if any, represents middle values, and the bottom color represents smaller values.
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, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.