The costs for the month of June are already in the worksheet (B6:D6).Ī. Use Solver to determine the best mix of advertising for the advertising dollars. In cell E7, type =E5 because all people might be reached by Social Media with no cost.Ĥ. Because the Social Media cost of zero is valid, the division error appears.
Use Error Checking to evaluate the error in cell F9, Use the solution suggested by Error Checking.ģ. Trace precedents and dependents on the two cells with errors: F9 and E7.Ģ. Figure 9-86b shows the completed Scenario Summary.ġ.
Figure 9–86a shows the completed Answer Report. You are to determine how best to promote the festivals, making the most of the town’s advertising budget. The workbook you open contains information about your town’s two annual festivals, one in June and one in October. Open the workbook called SC_EX_9-2.xlsx, which is located in the Data Files.
Please contact your instructor for information about accessing the Data Files. Note: To complete this assignment, you will be required to use the Data Files. Using Solver to Plan Festival Advertising In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.Reinforce the skills and apply the concepts you learned in this module. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought and personalization while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers.
Part of the acclaimed Shelly Cashman Series®, this edition continues the series' strong history of innovation with an enhanced learning approach designed to engage students, improve retention and prepare learners for success with Microsoft® Office. Introduce your students to the important new features that the latest version of Microsoft® Office has to offer with the focused approach found in Cable/Freund/Monk/Sebok/Starks/Vermaat's MICROSOFT® Office 365® & OFFICE 2019: INTERMEDIATE.
0 kommentar(er)
