FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You cannot change the color of cell borders in Excel.
A
true
B
false
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Right click on the cell you want the cell border to change and go to format cell. Go to the border tab and change the color from automatic and then you have to re-apply the border, it will not change automatically by just changing the color in the drop down. You still have to click and add the border.

Detailed explanation-2: -Select one or more cells that have a border that you want to change. Right-click over the cells you’ve chosen and select Format Cells and, in the popup window, click the Border tab. For a continuous line, choose one of the thicker styles from the Line box. In the Presets section, click your existing border type.

Detailed explanation-3: -Add or change a table border. Select the table cells that you want to add or change the table border for. Under Table Tools, on the Design tab, in the Draw Borders group, do one or more of the following: To change the color of the border, click the arrow next to Pen color, and then click the color that you want.

Detailed explanation-4: -On the Border tab, under Line Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. Click OK. Tip: To apply your new cell style, select the cells that you want to change, and then on the Home tab, click Cell Styles, and click the style.

There is 1 question to complete.