Page 201 - DCAP101_BASIC_COMPUTER_SKILLS
P. 201
Basic Computer Skills
Notes Try dragging cell C5 and cell D5 to new locations as we did in the previous exercise.
Close the file without saving. 3.10.7
Make sure never the copy more the one other wise only last copied is
work and all data is lost.
10.4 Entering Data
Excel is a powerful package to enter and display data or text easily. For example, we can
have Excel display a date showing the month, day, and year with the time, or showing only
the first letter of the month, followed by a two-digit year. Numbers can be displayed as
whole numbers, numbers with decimals, or numbers written in scientific notation.
When we enter data in a column format, we may find !t easier and faster
to use arrow keys to move between cells.
Entering data on expenditure under various heads:
Open the FirstFile workbook.
Starting in cell B6, type the following information into the worksheet, under the
corresponding headings.
Dates Conveyance Miscellaneous
1/1/95 85 110
4/1/95 150 350
7/1/95 200 375
10/1/95 275 600
13/1/95 350 750
18/1/95 300 500
21/1/95 250 875
Saving the file
194 LOVELY PROFESSIONAL UNIVERSITY
