USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Fill colour
|
|
Colour cell
|
|
Paint Bucket
|
|
Auto Fill
|
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: -Excel also has a handy “Paint Bucket” tool that can be used to quickly fill cells with color. To use it, simply select the cells that you want to fill, click the “Home” tab, and then click the “Paint Bucket” tool in the “Editing” group. From there, you can choose the color that you want to use.
Detailed explanation-3: -Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.