Part 1: create a spreadsheet with the following data.
item description purple stock white linen half cream stock 5x7 greeting
item number 0059 0067 0098 1021
unit ream ream 20 dozen
current number of units 346 456 908 546
item description 4x6 greeting black stock 11x14office 8x10 office
item number 1022 0068 2033 2032
unit ream ream 20 dozen
current number of units 346 456 908 546
part 2: solve steve's business problem. add two rows. label them "purchased today" and "total in stock." add formulas to the spreadsheet so that steve can keep the inventory current by adding new purchases and subtracting orders. (fill in the "purchased today" row with numbers of your choice.)
i just need part 2

File account.java (see previous exercise) contains a definition for a simple bank account class with methods to withdraw, deposit, get the balance and account number, and return a string representation. note that the constructor for this class creates a random account number. save this class to your directory and study it to see how it works. then write the following additional code: 1. suppose the bank wants to keep track of how many accounts exist. a. declare a private static integer variable numaccounts to hold this value. like all instance and static variables, it will be initialized (to 0, since it’s an int) automatically. b. add code to the constructor to increment this variable every time an account is created. c. add a static method getnumaccounts that returns the total number of accounts. think about why this method should be static - its information is not related to any particular account. d. file testaccounts1.java contains a simple program that creates the specified number of bank accounts then uses the getnumaccounts method to find how many accounts were created. save it to your directory, then use it to test your modified account class.