FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To add color to a row or column you click the ____
A
Click the font color button.
B
Fill color button (paint pail)
C
Set a colored border
D
None of the above
Explanation: 

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: -Start by clicking the row or column label (either a letter or number) that you want to apply the fill color to. Once clicked, the entire row should be selected. Click the Fill color icon in the ribbon, then click the color that you want to apply to that row or column.

Detailed explanation-3: -Click Format. In the Format Cells dialog box, click the Fill tab. Select the background or pattern color that you want to use for the shaded rows, and then click OK. At this point, the color you just selected should appear in the Preview window in the New Formatting Rule dialog box.

There is 1 question to complete.