Inventory Essay

ITS 150: Week Three Microsoft Excel Assignment
ITS 150 Microsoft Excel Assignment
Objective: Modify and prepare professional spreadsheets

1. Assignment:
   a. Review all the handouts and the MS Excel samples (Inventory Example.xls and practice_macros.xls) posted at Blackboard. Download and operate the sample spreadsheets. Modify the data in the samples and learn how the spreadsheets are created and how they operate. In particular, inspect and understand each cell’s contents for text, formulas, and data.
   b. Open the file, Inventory Example.xls
   Modify the Operating Expenses worksheet within the spreadsheet to include the expense of Advertising. Update projected year to 2019. Ensure the spreadsheet’s chart includes the new Advertising expense. (See sample screen
   view below) Verify your spreadsheet works properly.
   c. Create a new spreadsheet that automatically calculates student numerical course grades. List at least five students, five quizzes, assignments, a midterm and final exam. The weights of each of these items are up to you but
   should not all be the same, i.e. a quiz should not be the same weight as the midterm. Spreadsheet must use weighting factors.