FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?
A
Clear the formatting on the cell
B
Delete the formula and just enter the value he wants in the cell
C
Resize the cell to fit the contents
D
Filter the cell
Explanation: 

Detailed explanation-1: -Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.

Detailed explanation-2: -Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard.

Detailed explanation-3: -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-4: -Absolute. a cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied and is indicated by the $ sign.

There is 1 question to complete.