What are the two different types of Scenario Reports? List some ways Scenario Reports are useful
What will be an ideal response?
A Scenario Summary report creates a worksheet that includes subtotals and results of the scenarios in a worksheet. A Scenario PivotTable report creates a worksheet containing a PivotTable summarizing the scenarios in a worksheet. Scenario reports make it easier to compare scenarios side-by-side. Scenario PivotTable reports also provide the added benefit of analyzing the scenario data in PivotTable format. Using the scenario reports also makes printing and distributing scenarios easier.
You might also like to view...
Which of the following will not produce a compiler error?
a) Changing the value of a constant after it’s declared. b) Changing the value at a given index of an array after it’s created. c) Using a constant variable before it’s initialized. d) All of the above will produce compiler errors.
Which of the following actions would NOT help to identify your personal ethics?
a. Describe yourself. b. Identify the influences of your work environment. c. Conduct a genealogic study of your extended family. d. Prepare a list of values that are most important to you.
You are on a service call to fix a customer's printer when he asks you to help with a network firewall issue. This is not part of your normal responsibilities. What should you do?
A) Call your supervisor to find the best company resource to recommend to the customer. B) Try to solve the issue to the best of your ability. C) Report the user to his supervisor. D) Empathetically tell the customer you cannot and report the request to your supervisor.
Your firm has uploaded a large amount of aerial image data to S3 In the past, in your on-premises environment, you used a dedicated group of servers to oaten process this data and used Rabbit MQ - An open source messaging system to get job information to the servers. Once processed the data would go to tape and be shipped offsite. Your manager told you to stay with the current design, and leverage AWS archival storage and messaging services to minimize cost. Which is correct?
A. Use SQS for passing job messages use Cloud Watch alarms to terminate EC2 worker instances when they become idle. Once data is processed, change the storage class of the S3 objects to Reduced Redundancy Storage. B. Setup Auto-Scaled workers triggered by queue depth that use spot instances to process messages in SOS Once data is processed, C. Change the storage class of the S3 objects to Reduced Redundancy Storage. Setup Auto-Scaled workers triggered by queue depth that use spot instances to process messages in SQS Once data is processed, change the storage class of the S3 objects to Glacier. D. Use SNS to pass job messages use Cloud Watch alarms to terminate spot worker instances when they become idle. Once data is processed, change the storage class of the S3 object to Glacier.