Page 200 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 10: Microsoft Excel

Column headings help in understanding the data or information that has been entered in Notes
the %worksheet. Sometimes the column heading is too large to fit into a column. Even
though it does not show the entire title or formula, the cell still contains everything entered
into it. This exercise, shows how to increase or decrease the column width to fit the entered
information.
Using the FirstFile worksheet, click cell B5, and type Dates in cell B5
Press tab to go to cell C5, and then type Conveyance.

Press tab to go to cell D5, and then type Miscellaneous.
One cell will overlap the other.

Press enter.
At the top of the worksheet, position the pointer at the top of the grid between
columns C and D until the pointer changes into a double-arrow line and then double-
click.
Note The pointer becomes n double-arrow! when it is placed between columns at the
top of a chart.
Repeat steps 4 and 5 between cells D and E.

Select the words Amount Spew, and move the + pointer to a cell line until it changes
to an arrow.

Click and drag the text to begin in cell C3.
Save the worksheet.
With these easy steps we can customize a template or design our own workbook to present
our information.
10.3.7 Arranging Text with the Copy, Paste and Cut Commands

With Excel, it is easy to modify data. When we use the features in Excel to create a table,
we may decide on a different order of column heads or we may want to revise them. It is
important to make changes before we build a formula for the chart in order to maintain
correct calculations.
Note Usually Cut is used to move the contents of a cell or cells to a different location. Copy
is used to duplicate the contents or a cell or cells in another location.
Using the Cut, Paste, and Copy commands to arrange text.
Using the FirstFile worksheet, right-click cell C3, and click Cut.

Right-click cell C1, and click Paste.
Right-click cell D5, and click Cut.

Right-click cell D10, and click Paste.
Right-click cell C5, and click Cut.
Right-click cell D5, and click Paste.
Right-click cell D10, and click Cut.

Right-click Cell C5, and click Paste.

LOVELY PROFESSIONAL UNIVERSITY 193