# 2 replace the phrase insert cell reference here in

• 31

This preview shows page 26 - 28 out of 31 pages.

on the Calculations worksheet.2.Replace the phrase “[Insert Cell Reference Here]” in cell D22with a cell referenceto the Total Half Year Fixed Expenses amount on the Calculations worksheet.3.Replace the phrase “[Insert Cell Reference Here]” in cell D25with a cell referenceto the Total Purchases Expenses amount on the Calculations worksheet.4.Replace the phrase “[Insert Cell Reference Here]” in cell D26with a cell referenceto the Total Freight Outwards Expenses amount on the Calculations worksheet.5.Replace the phrase “[Insert Cell Reference Here]” in cell D27with a cell referenceto the Percentage Freight Outwards of Total Sales amount on the Calculations worksheet6.Replace the phrase “[Insert Cell Reference Here]” in cell D29with a cell referenceto the Total Half Year Fixed and Variable Expenses amount on the Calculations worksheet7.Replace the phrase “[Insert Cell Reference Here]” in cell D31with a cell referenceto the Total Profit amount on the Calculations worksheet8.Replace the phrase “[Insert Cell Reference Here]” in cell D32with a cell referenceto the Total Discount for Orders amount on the Calculations worksheet9.Replace the phrase “[Insert Cell Reference Here]” in cell D33with a cell referenceto the Percentage Discount of Total Sales amount on the Calculations worksheet10.Replace the phrase “[Insert Cell Reference Here]” in cell D34with a cell referenceto the No. Orders P a g e 26 | 31.....CIS5100 ASSIGNMENT 1 QUESTION FILESEMESTER 1, 2020
Discount Applied amount on the Calculations worksheet.Note: Ensure that you only use cell referencing for the DataInput Totals data.Do not discuss with your fellow students, nor post formulas to the StudyDesk Forums; it may result inacademic misconduct.Task 19: ScenariosUsing the Scenario Manager in Excel create and check the following eight (8) Scenarios using the Changing Cellsof D4, D5 and D7on the DataInput worksheet:See the Beskeen Excel Chapter 19, the Forum Postings, the Practical Appendixes and the Practical Videosprovided in the Assignment 2 Assessment Tab for more details on creating Scenarios.ScenarioMarkup TypeFreight TypeExchange Rate Type1Store MarkupOswald Chesterfield Cobblepot FreightBE2Store MarkupOswald Chesterfield Cobblepot FreightCA3Store MarkupNorman Osborn TransportBE4Store MarkupNorman Osborn TransportCA5Supplier MarkupOswald Chesterfield Cobblepot FreightBE6Supplier MarkupOswald Chesterfield Cobblepot FreightCA7Supplier MarkupNorman Osborn TransportBE8Supplier MarkupNorman Osborn TransportCANote: Ensure you have a suitable scenario name for each scenario, eg. Scenario 1, Scenario2, Scenario 3, …Task 20: Scenario SummaryUsing the Scenario Manager in Excel create a Scenario Summaryworksheet from the DataInputworksheet based on the eight (8) Scenarios from Task 19 and focusing on the Result cells D12, D22, D25, D26, D27, D29, D31, D32, D33 and D34 on the DataInputworksheet.