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