Division of Business and Information Management,
Bristol Community College
The purpose of this assignment is to experiment with Microsoft Excel named ranges and using them in spreadsheet formulas.
Download file hw_excel_L02P31.xls and open it in Microsoft Excel.
While working with Excel, save your document often. Give it a descriptive name, for example, "PurchaseOrderSample.xls".
Select a region of cells A13:A15. Insert and define a name for this range: quantity.
Select a region of cells G13:G15. Insert and define a name for this range: price.
Select a region of cells I13:I15. Insert and define a name for this range: amount.
Click on cell I13 and enter a formula =quantity*price.
Use auto-fill function to populate remaining Amount fields with the same formula.
Click cell H17 and enter a new text label: Total.
Click cell I17 and enter a formula to calculate total purchase order amount.
When you are done, save the document, close it, and exit Excel.
Submit your Excel document via e-mail attachment sent to:
Igor Kholodov Igor.Kholodov@bristolcc.edu