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