Microsoft Office Tutorials and References
In Depth Information
In the Lab 1: Loan Balance Worksheet
c. Center the column headings in row 3.
d. Format the values in C5:C12 and C14:C16 using the comma format.
e. Change the document properties as specied by your instructor. Save the workbook using the
le name, ACI 2–1 Janeese Crystals Corrected. Submit the revised workbook as specied by
your instructor.
What else could you do to improve the worksheet?
3.
In the Labs
Design and/or create a workbook using the guidelines, concepts, and skills presented
in this chapter. Labs 1 and 2, which increase in difculty, require you to create solutions
based on what you learned in the chapter; Lab 3 requires you to create a solution, which
uses cloud and web technologies, by learning and investigating on your own from
general guidance.
Lab 1: Loan Balance Worksheet
Problem: You are a part-time assistant in the
accounting department at HelpToday Personal Loans,
a Cincinnati-based personal loan company supplying
small loans to individuals. You have been asked to use
Excel to generate a report that summarizes the existing
loan balances (Figure 2 – 73). The customer data in
Table 2 – 6 is available for test purposes.
Table 2– 6 HelpToday Personal Loans Data
Customer
Previous Balance
Payments
Tolliver, Ralph
1,600.72
72.15
Jennings, Howard
1,518.62
382.30
Rivera, Juan
679.29
80.69
Lance, Brad
1,060.42
107.60
Yin, Yu
1,178.83
125.63
Instructions: Create a worksheet similar to the one
shown in Figure 2 – 73. Include the three columns of
customer data in Table 2 – 6 in the report, plus two
additional columns to compute a monthly fee and a current
balance for each customer. Assume no negative unpaid
monthly balances.
Lang, Rose
1,280.20
79.85
Tulley, Sullivan
1,253.88
389.79
Jiminez, Jose
477.11
278.52
Adams, Bettina
821.31
153.14
Figure 2 – 73
Continued >
Search JabSto ::




Custom Search