DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
font color
|
|
|
fill color
|
|
|
border
|
|
|
theme
|
Detailed explanation-1: -Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want. To use a pattern with two colors, pick a color in the Pattern Color box, and then pick a pattern in the Pattern Style box.
Detailed explanation-2: -In Excel, there are several ways to apply background color to the cell or the entire sheet, but all depends on your requirement. If you want the color once applied to not change with any change in the cell value, then you can simply use the “Fill Color” or Format Cells” or Cell Styles” option.
Detailed explanation-3: -In the Format Style dropdown box, select either 2-Color Scale (default) or 3-Color Scale. For Minimum, Midpoint and Maximum values, pick the data type (Number, Percent, Percentile, or Formula), and then choose the color.
Detailed explanation-4: -To add shading or color to a cell range.