Use the drop-down menus to complete the steps for using the Scenario command.


1. Select the cells you want to use in your scenario.


2. Go to the ____ tab.

Data
Home
Insert
Formulas

3. In the Forecast group, select _____ and click Scenario Manager.

Sort
Get Data
Forecast Sheet
What-If Analysis

4. Click Add and fill in the name and add comments if you wish.


5. To compare, you will want to create _____ version.

A what-If
A original
A Data Table

6. Add a second scenario, changing the values from the first.


7. Click _____ to view the values in each scenario.

OK
Show
Review

Answers

Answer 1

Answer:

1. Select the cells you want to use in your scenario.

2. Go to the Data tab.

3. In the Forecast group, select What-if Analysis and click Scenario Manager.

4. Click Add and fill in the name and add comments if you wish.

5. To compare, you will want to create an original version.

6. Add a second scenario, changing the values from the first.

7. Click show to view the values in each scenario.

I got the answer right on Edge :)

Answer 2

The cells a person want to use are:

Go to the Data tab. In the Forecast group, select What-if Analysis and click Scenario Manager.Click Add and fill in the name and add comments if you wish. To compare, you will want to create an original version.

What is cell?

A cell is known to be area that is found on a spreadsheet that is known to be the place where the data are said to be entered.

Note that in the case above, The cells a person want to use are:

Go to the Data tab. In the Forecast group, select What-if Analysis and click Scenario Manager.Click Add and fill in the name and add comments if you wish. To compare, you will want to create an original version

Learn more about cells from

https://brainly.com/question/13920046

#SPJ9


Related Questions

Why does a bus topology require a terminator

Answers

Answer:The purpose of the terminator is to absorb signals so that they do not reflect back down the line

Explanation:

The answer is-

B.) because otherwise the packets will bounce back and forth from end to end repeatedly

Bus topology can be regarded as a kind of topology for a Local Area Network, it is one that has it's nodes connected to a single cable(backbone) and any break in the so called backbone, there will be failure in the entire segment. However a Terminator is usually attached to the end-points of a bus network so that the signal is absorbed by the Terminator and as a result of this the signal will not reflect back down the line. If there is no Terminator there would be bouncing back and forth of packet in an endless loop.It should be noted that a bus topology require a terminator because otherwise the packets will bounce back and forth from end to end repeatedly

What is the purpose of this diamond shape in a flowchart?

Answers

Answer:

To represent a decision making step.

Explanation:

for example, assume that you need to display 'pass' if the total marks are greater than 50 and 'fail' if it's less than 50

Then, after calculating the total, you should draw a diamond and inside it write, 'is total ∠ 50?'

after that you can continue your flowchart taking one decission as 'yes' and the other decission as 'no'

The rectangular shape stands for a task or course of activity. In the flowchart sequence, the diamond shape represents a question or a branch.

What is flowchart?

A flowchart is a diagram that shows a process' individual steps in their proper order.

It is a general tool that may be customised for a wide range of uses and used to define a variety of processes, including a project plan, an administrative or service process, or a manufacturing process.

These four typical forms are excellent for outlining organisational structure, how various departments interact, and economic, industrial, or administrative operations.

In a process, a decision point is represented by a diamond. Usually, the statement in the symbol will call for a "yes" or "no" response and, in accordance, branch to other locations in the flowchart.

Thus, this is the main use of diamond symbol in a flowchart.

For more details regarding a flowchart, visit:

https://brainly.com/question/14598590

#SPJ2

To simply the task of creating a heading for a science report, a student can create a _____ to run when a specific button is pressed on the quick access toolbar.

i need answer asap
citation

caption

macro

template

Answers

Answer:

macro

Explanation:

The answerrrrr is macro (:

Name the application pagram used in creating the
document above​

Answers

Answer:

Excel or Google Sheets

Explanation:

how does air conditioner work
please short answer please​

Answers

It draws the warm/ hot air from inside to outside and the AC unit (usually outside) turns the vapor into a liquid which removes any excess heat. (This is the way I learned it)
The air conditioner in a central heating and cooling system provides cool air through ductwork inside your home, by providing a process that draws out the warm air inside, removing its heat.

What is a row of data in a database called?
Field
File
Record
Title

Answers

Answer:

record

Explanation:

i took the test and got it right but give brainliest to the person above me

what are the software is there ? their uses

Answers

Answer:

Computer software is programming code executed on a computer processor. The code can be machine-level code, or code written for an operating system. An operating system is software intended to provide a predictable and dependable layer for other programmers to build other software on, which are known as applications.

I’m sorry but I don’t think you worded that correctly

Meet my horse! ask questions about him too!

Answers

Answer:

no answer, just horse

Explanation:

how much does he eat and is his hair soft? jdnfnnan

Answer:

Hi I have a horse too. He is so handsome

what dicapline do you do?

Explanation:

My notifications keep glitching and saying i got messages
But they dry

Answers

Answer: just reset the phone

Explanation: if it keeps doing that then you have some app that's not supposed to be there

describe oxfird cleric​

Answers

Answer:

Explanation:

The Oxford Cleric, or otherwise just known as the Cleric, is from a series of tales called the Canterbury Tales. He had a rather simple life as a cleric and was more commonly seen as a philosopher. The Cleric was just a student who used all of his money on books instead of on clothes and was considered poor.

Type the correct answer in the box. Spell all words correctly.
How is it possible to access data from any location?
Storing data on the _________ enables access from any location.

Answers

Answer:

Storing data on the cloud enables access from any location.

Explanation:

Answer:

the answer is cloud becus i get it right

Explanation:

Your school is hosting a diving contest, and they need a programmer to work on the scoreboard! Your job is to calculate each diver's total after the three judges hold up their individual scores. Write the function calculate_score which takes a tuple of three numbers from 0 to 10 and calculates the sum. A perfect dive is worth 30 points, a belly flop is worth 0. For example: calculate_score((10, 10, 10)) # => 30 calculate_score((9, 9, 6)) # => 24

Answers

Answer:

def calculate_score(setss):

    num1, num2, num3= setss

    if num1 >= 0 and num1 <=10 and num2>= 0 and num2<=10 and num3>= 0 and num3<=10:

         print(num1+ num2+num3)

    else:

         print("Out of range")

Explanation:

I've added the full source code as an attachment, where I used comments as explanation

An instrument used to measure the amount of electrical current intensity in a circuit

Answers

the instrument is an ammeter

Dan works for an automobile company. He has designed a new model of a car based on an older version. Which technology can he use to present the model at a board meeting?
A.
wearable computing
B.
3-D printing
C.
grid computing
D.
screenless display

Answers

Answer:

a

Explanation:

i did the test

Answer:

The answer is B (3-D printing)

Explanation:

i think it is a or c is it right?

Answers

C
She is emailing her boss that something is wrong.

What is the output?
password = "sdf# 356"
>>> password. isalnum()

Answers

The output is False because the string password contains #.

Answer:

The answer is False.

Explanation:

The answer is false becasue it has other characters than letters and numbers.

Have a great day, I hope this helped.

Changing the position of the wing will

Answers

Answer:

will cause error in your pc many many many

Answer:

change the center of gravity and neutral point

Explanation:

Which of the following behaviors is considered ethical?

A. copying another user’s password without permission
B. hacking software to test and improve its efficiency
C. using a limited access public computer to watch movies
D. deleting other user’s files from a public computer

Answers

Answer:

answer is c. using a limited access public computer to watch movies

Answer:

using a limited access public computer to watch movies

Explanation:

It is the only one that will not get you in big trouble

When determining the cost of an item, the seller will often analyze the demand as well as the supply before setting the price of the blank
.

Answers

Answer:

The price of a commodity is determined by supply and demand. therefore the answer is COMMODITY. that other person is wrong

Answer:  The correct answer is Commodity

Explanation:  This answer is confirmed correct.

Commodity pricing is established based on supply and demand.

Which statement best illustrates the relationship between three different
elements of the circular flow of products?
O A. Households pay wages to businesses, which can then set up
product markets.
O B. Product markets offer labor to businesses, which creates jobs for
households.
O C. Businesses create goods for product markets, which sell them
directly to households.
O D. Resource markets sell goods to product markets, which sell the
goods to businesses

Answers

Answer:

C

Explanation:

GDP can be represented by the circular flow diagram as a flow of income going in one direction and expenditures on goods, services, and resources going in the opposite direction. In this diagram, households buy goods and services from businesses and businesses buy resources from households.

In Word you can _____ or merge two different copies of the same document into one document. a. replicate b. duplicate c. copy d. combine

Answers

D) combine
combine and merge are synonyms of each other.
hope this helps x

Compare the different specialties of video game design in which a video game designer can concentrate.

Answers

Answer:

design animators, visual effects, 3d animators

Explanation:

You need both designers and programmers.

Answer:

A game can't be created without both the designer and programmer working closely together from start to finish. Game designers are responsible for the overall creative vision of the game while programmers have the technological know-how to implement the game designers' ideas and bring them to life using computer code.

Explanation:

:)

8. It is a computer component that converts AC power to DC power to be used
by the computer system.

Answers

Answer:

power supply unit.

A power supply unit (PSU) converts mains AC to low-voltage regulated DC power for the internal components of a computer. Modern personal computers universally use switched-mode power supplies.

Explanation:

I HOPE THIS HELPS

PLZ MARK ME AS BRAINLIEST

THANK U!

Select the correct answer.

What is the drawback of the linear model?

A. communication is only in one direction

B. too much noise is created

C. no feedback is sent on receiving the message

D. long travel between the sender and the receiver

I NEED this asap
20 points

Answers

long travel between the sender and the receiver

Answer:

D. long travel between the sender and the receiver

Explanation:

Which is the civil penalty for COPYRIGHTS violations? Choose the answer. $200-$150,000 fine up to five years in jail Fines and court costs 1 year in jail

Answers

Answer: $200-$150,000 fine

Explanation:

I took the Quiz

As the senior analyst responsible for data staging, you are responsible for the design of the data staging area. If your data warehouse gets input from several legacy systems on multiple platforms, and also regular feeds from two external sources, how will you organize your data staging area? Describe the data repositories you will have for data staging.

Answers

Answer:

The corresponding schemas I use such as given below.

Explanation:

Dim: Used in the design for certain artifacts belonging to measurements. Fact: Used for these artifacts throughout the design relevant to the truth Admin: Used for all configuration-related artifacts that could be open to professional end-users. Audit: That used to hold audit-related particles. Etl: Is used for keeping objects, particularly staging details, directly connected to something like the ETL method. Report: Used to keep objects utilized explicitly for programs for documentation.Olap: Used for keeping objects directly used for systems for study. Test: Used to carry objects which have been used exclusively for research. Useful- Used to carry objects that just about any member including its implementation may typically use.

________ were developed to allow computers to communicate using networking standards.
A. Nodes B. Sound cards C. network interface cards
A ______ is an interconnection of computers sharing data and peripherals.
A. Node B. Network C. peripheral
A ______ is any computer or digital device (wired or wireless) using the network to exchange data between other computers.
A. Nodes B. Network C. Analog
Walking the data to someone else is called ______.
A. Network B Sneaker-Net C. peripherals
_______ transformed computing by they providing fast, easy access to messages or data and to other users.
A. Digitals B. Peripherals C. Networks

Answers

1.) Network interface cards

2.) Network

3.) Nodes

4.) Sneaker-net

5.) Networks

Answer: Trust the person up top

Explanation:

What is one step taken when solving a computer software problem?

Answers

scanning the computer and deleting any viruses

[ if this helped you please give brainliest :) ]

Answer:

B. scanning the computer and deleting any viruses

Explanation:

edge 2020

Find the value of 1/2 of 1/2​

Answers

Answer:

1/2 of 1/2​ is 1/4 or 0.25

Explanation:

Answer:

0.25 or 1/4

Explanation:

because 0.50 is 1/2 so half of 0.50 is 0.25 or 1/4

Reflect on the questions below.

1.) Why do some people resist help from others?

2.) Is it useful to work separately at some point in time during pair programming?

3.) How is pair programming beneficial?

4.) In pair programming, how can we better work together?

Answers

Answer:

Why do some people resist help from others? Because they fear that their ideas might be rejected.

Is it useful to work separately at some point in time during pair programming? Yes, it is helpful because one can do coding while the other one is navigating or doing something else, it allows the pair to work faster and more efficient.

How is pair programming beneficial? It is beneficial because you can cover more stuff with the help of other people that what you would cover by yourself.

In pair programming, how can we better work together? By communicating with each other, discovering our strengths and working on our weaknesses. 

Explanation:

Other Questions
4) Find the LCM of 20 and 9 PLEASE HELP look at the highlighted queastion. PLEASE Determine the zeros or roots of each function or equation. You can use the quadratic equation if you need to. f(x)=-8x^2+2x+1 If you have a sore throat, dry cough, fever, and chills, what is my diagnosis? ConclusionDespite its harsh conditions, the Dead Sea is an important resource for the people who live near its shores. They benefit from the seas attraction as a tourist destination and from the seawaters minerals, which are used to make many products. What products do you use that may have come from this important region? Which of the following expressions is modeled on the number line? (x/x+1) - (2x+1)? how do i do this people? The text cites___________ as the first step to conquering anger. And ___________ as a component to dealing with anger constructively involving stating no to an unreasonable request.Group of answer choicesTaking positive action;Being assertiveStaying calm;Taking positive actionCommunicating your feelings;Taking positive actionUnderstanding what caused it;Being assertiveThe text cites___________ as the first step to conquering anger. And ___________ as a component to dealing with anger constructively involving stating no to an unreasonable request.Group of answer choicesTaking positive action;Being assertiveStaying calm;Taking positive actionCommunicating your feelings;Taking positive actionUnderstanding what caused it;Being assertive Given: -4x + 2y = 8Prove: y = 4 + 2x While mining, Jason found a large metal bar that weighed 50 ounces. Jason was also able to determine that the bar contained 60% nickel. How many ounces of nickel are in the metal bar? Page1of 30ZOOM3. A cat is moving at 18 m/s when it accelerates at 4 m/s? for 2 seconds. What is his newvelocity? If you had 4 protons and 5 neutrons you created which element * Conjugate the verb in the parenthesis in the preterite tense.Mis amigos y yo ______ (levantar) pesas la semana pasada Why do you think the hot red water sank to the bottom? Sura 3 states which of the following?A. Allah never forgivesB. Endurance is a sinC. Never humble yourself before AllahD. Allah is able to do all thingsE. All of the above When the curtain closed, I breathed a sigh of relief. "We did it! I exclaimed to Riya, knowing she would be equally thrilled. I wiped the sweat from my brow and prepared to take a bow when the curtain reopened. The thundering applause of the audience suggested that it approved.Which statement describes the narrative voice of this paragraph?The paragraph has a first-person narrator offering thoughts and feelings.The paragraph has a second-person narrator addressing the reader.The paragraph has a third-person narrator sharing observations.The paragraph has an omniscient narrator with knowledge of the future. Please help !! I am having trouble, I keep getting this question wrong. PICTURE PROVIDED JUST TELL ME IF IT IS A FUNCTION AND WHY Centripetal acceleration must involve a change in PLS HELP WILL MARK BRAINLIESTHypothesis(Answer here)Questions 1. Check your original prediction or hypothesis about how the layers were correlated. Did you predict the correct layer that would have the dinosaur fossil? Explain whether your prediction was correct. Tell what clue made the biggest difference.2. How would you use your results to tell the relative ages of the rock layers in a new section of strata?3. In your own words, explain why you think that geologists find relative dating useful.