USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
fill
|
|
|
format
|
|
|
active cell
|
|
|
active cell
|
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.
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: -To shade a cell until something is entered in Excel, first select the cell or range of cells that you want to format. Then, on the Home tab, in the Font group, click the Fill Color button. A drop-down menu will appear. From here, you can choose the color that you want to use to shade the selected cell or cells.
Detailed explanation-4: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Note: This article explains how to automatically fill values into other cells.