computer science Assignment

You are to complete the assignments that are attatched. It helps to be experienced with powerpoint. Labs 1,2 &3 Cases 1,2&3 Design and/or create a workbook using the guidelines, concepts, and skills presented chapter. Labs 1, 2, and 3 are listed in order of increasing difficulty. In this Lab 1: Accounts Receivable Balance Worksheet Problem: You are a part-time assistant in the accounting department at Aficionado Guitar Parts, a Chicago-based supplier of custom guitar parts. You have been asked to use Excel to generate a re that summarizes the monthly accounts receivable balance (Figure 2 —7 7). A chart of the balancesPalsrto desired. The customer data in Table 2-6 is available for test purposes. Table 2-6 Aficionado Guitar Parts Accounts Receivable Data Customer Cervantes, Katriel Cummings, Trenton Danielsson, Oliver Kalinowski, Jadwiga Lanctot, Royce Raglovv, Dora Tuan, Lin Beginning Balance 803.01 285.05 411.45 438.37 378.81 710.99 318.86 Credits 56.92 87.41 79.33 60.90 48.55 55.62 85.01 Payments 277.02 182.11 180.09 331.10 126.15 231.37 129.67 Purchases 207.94 218.22 364.02 190.39 211.38 274.71 332.89