USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format cell
|
|
|
conditional formatting
|
|
|
fill color
|
|
|
magic cell
|
Detailed explanation-1: -Conditional formatting provides another way to visualize data inside a spreadsheet. Using this tool you can automatically apply formatting such as colors, icons, and data bars, to a range of cells based on a condition or cell value.
Detailed explanation-2: -The correct answer is Conditional formatting. Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value.
Detailed explanation-3: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. 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.
Detailed explanation-4: -On the Home tab, under Format, click Conditional Formatting. Point to Data Bars, and then click a gradient fill or a solid fill. Tip: When you make a column with data bars wider, the differences between cell values become easier to see.