information systems 13.2


On Your Own 13-2








1. Create a new, blank workbook, and

then save the workbook as Computer


Service Calls.





2. Rename the Sheet2 worksheet as

Service Calls.





3. In the Service Calls worksheet, enter




labels for the following columns of




data: client, address, phone, date of




service, hours, travel fee, hourly rate,




and service charge.




4. Enter fictional data for at least five




clients. Do not enter data in the




service charge column.




5. Enter a formula to calculate the




service charge for each client, which




is the number of hours multiplied by




the hourly rate plus the travel fee.




6. Enter a formula to total the service




charge for all the clients. Add an




appropriate label to identify the total.




7. Above the client data, insert rows as




needed, and then enter a company




name and worksheet purpose.




8. Format the worksheet for printing,




changing the page orientation and




scale as needed to fit the contents on




one printed page.

9. Rename Sheet1 as Documentation,





and then enter information




documenting the workbook. Include




the name of the company (create a




fictional name), your name, the




current date, and a brief description




of the purpose of the workbook.




10.Save, preview, and print the




workbook, and then close it.


On Your Own








Order this or a similar paper and get 20% discount on your first order with us. Use coupon: GET20