One tool under What-If-Analysis is Scenarios. Which best describes the purpose of setting up and using scenarios

1. to quickly combine multiple formulas from different cells into just one
2. to instantly compare results when data in numerous cells change to specified values
3. to conduct automatic complex statistical analysis on a range of cells
4. to constrain some cells to certain values so that the wrong data are rejected if entered​

Answers

Answer 1

Answer:

Option B, to instantly compare results when data in numerous cells change to specified values

Explanation:

Scenario setting with in the What If Analysis is used to compare various scenarios with in the same excel sheet. Scenarios has set of values that are saves and updated automatically as the values with in the cell changes. Also the scenarios can be switched.

Hence, option B is correct


Related Questions

Choose the first programming language for personal computers that was released in the 1970s by Microsoft

Answers

Answer:

Altair BASIC programming language

Explanation:

The Altair BASIC programming language was built for the Altair 8800 microcomputer by childhood friends, Bill Gates and Paul Allen in March 1975

The interpreter for the Altair BASIC programming language was developed by Bill Gates while Paul Allen worked on the simulator

The newly developed programming language worked without flaw during the demonstration to Micro Instrumentation and Telemetry Systems, MITS

Microsoft was founded by Bill Gates and Paul Allen on the 4th of April 1975

Answer:

C.) Altair BASIC programming language

Explanation:

You have been given an assignment to create a webpage that has a calming effect on the viewer. Which of these is most likely to achieve that goal?A.multiple font sizes B.a textured background C.rotating elements D.use of blues and greens

Answers

Answer:

The answer should be D.

Explanation: Cool colors make someone feel calm,mainly blue and green

Answer:

“Use of blues and greens”

Explanation:

James’s work computer has lost its Internet connection but is otherwise working. If James’s colleagues have lost their Internet connections, too, which of the following is most likely to be true?

A. A server is down somewhere.
B.They need a repairman to fix the hardware on their computers.
C.Their computers are not part of a network anymore.
D.They have a software problem on their computers.

Answers

A. Server is down somewhere

Answer:

A server is down somewhere.

Explanation:

Edge

According to the video, what are common tasks performed by Tour Guides? Check all that apply.

leading trips
maintaining equipment
shepherding tourists and luggage
socializing
purchasing tickets for flights
selling equipment
setting up meals
teaching first aid

Answers

Common tasks of the tour guide.

As per the question, the video shows us the tour guide n the ways he handles the tasks. The tour guide can be seen using making techniques such as providing tips, giving information, socializing with people, and setting up meals and other arrangements.

Thus the answer is leading trips, maintaining equipment, shepherding the tourists and luggage, and socializing, setting up meals.

Thus the duty of the tour guide its provide the latest information and provide the cratered services to the clients. The services like hotel, travel and maintains of the equipment's is essential for them. Thus the option 1, 2, 3,4 and 7 are correct.

Learn more about the according to the video.

brainly.com/question/19175630.

Answer: 1 2 3 4 7

Explanation:

what the other guy said

If you type =5*3 into a cell, what do you expect the answer will be?
A. 5*3
B. 15
C. E3
D. 8

Answers

Answer:

I think 15

what do you mean by cell

Explanation:

Answer:

15

Explanation:

right on edge

You have a spreadsheet of x values that need to
be entered into the following formula to calculate y
values:
y = 5x + 19 - 7
Which of the following is the quickest way to
accomplish this task?
A. Use a calculator to find the y value for each x
value, then enter those results into the
spreadsheet
B. Enter the formula into the spreadsheet to
calculate the y value for each x value.
DONE

Answers

Answer: Its B

Explanation:

Answer:

Enter the formula into the spreadsheet to calculate the y value for each x value

Does anybody know how to get this little search bar thing off of my task bar on a HP laptop.

Answers

Try clicking the down arrow on the search bar or right clicking it and selecting an option no if that doesn’t work then drag the || to somewhere or right click it. If none of those work you can right click the taskbar and see if there is anything that looks like it could be the search bear and uncheck it

How is net pay different from gross pay?

Answers

Net pay is your gross pay reduced by any state and federal taxes.

Help help help!!!please

Answers

Answer:

A. 1 AWG

Explanation:

The larger the AGW number or wire gauge, the smaller the size of the wire

The largest conductor in the list is 1 American Wire Gauge (AWG)

What are conductors?

Conductors are substances that allows electricity to flow through it.

In a conductor, electrical charge carriers, usually electrons or ions, move easily from atom to atom when voltage is applied.

In a simpler term conductors are substance that can conduct electricity.

American Wire Gauge (AWG) is the standard way to denote wire sizes.

Therefore, 1 American Wire Gauge (AWG) conducts more electricity in the list.

learn more on conductors here: https://brainly.com/question/18084972

#SPJ9

which kind of blocks is used to hold values​

Answers

Answer:

Variable block.

Explanation:

In Computer programming, a variable can be defined as a placeholder or container for holding a piece of information that can be modified or edited.

Basically, variable stores information which is passed from the location of the method call directly to the method that is called by the program.

For example, they can serve as a model for a function; when used as an input, such as for passing a value to a function and when used as an output, such as for retrieving a value from the same function. Therefore, when you create variables in a function, you can can set the values for their parameters.

For instance, to pass a class to a family of classes use the code;

\\parameter Name as Type (Keywords) = value;

\\procedure XorSwap (var a,b :integer) = "myvalue";

Hence, variable block is used to hold values. Also, it can be used to hold strings in variables, which may be displayed through the computer monitor.

What responsibilities does the film editor have? (Select all that apply).

Answers

Answer:

“Revising the script”, “reading the script”, and “manipulating graphics, plot, sound, and score”

Explanation:

Elliott is trying to normalize a database that he has designed. Which is not one of the elements of 1NF or 2NF?

Each cell of a table must contain a single value.
The table must not contain repeating groups.
Each table must depend on the entire primary key.
Each table must depend on the entire foreign key.

Answers

Answer: I think it’s D

Explanation: the rest apply to the the rules of 1NF and 2NF

2.32 LAB: Musical note frequencies On a piano, a key has a frequency, say f0. Each higher key (black or white) has a frequency of f0 * rn, where n is the distance (number of keys) from that key, and r is 2(1/12). Given an initial key frequency, output that frequency and the next 4 higher key frequencies. Output each floating-point value with two digits after the decimal point, which can be achieved by executing cout << fixed << setprecision(2); once before all other cout statements. Ex: If the input is: 440.0 (which is the A key near the middle of a piano keyboard), the output is: 440.00 466.16 493.88 523.25 554.37

Answers

Answer:

Explanation:

[tex]\text{This is a python code:}[/tex]

[tex]\text{import math}[/tex]

[tex]your {\_} {value 1 }= float(inpu \ t ())[/tex]

[tex]your{\_}value 2 = your{\_}value1*math.exp(1 * math.log(2) / 12)[/tex]

[tex]your{\_}value 3 = your{\_}value1*math.exp(2 * math.log(2) / 12)[/tex]

[tex]your{\_}value 4 = your{\_}value1*math.exp(3 * math.log(2) / 12)[/tex]

[tex]your{\_}value 5 = your{\_}value1*math.exp(4 * math.log(2) / 12)[/tex]

[tex]print('\{:.2f\} \{:.2f\} \{:.2f\} \{:.2f\} \{:.2f\}'.format(your\_value1, \ your\_value2, \ your\_value3,[/tex][tex]\ your\_value4, \ \ your\_value5))[/tex]

[tex]\mathbf{OUTPU \ T :}[/tex]

[tex]\mathbf{440.00 \ 466.16 \ 493.88 \ 523.25 \ 554.37}[/tex]

The code for musical note frequencies On a piano, a key has a frequency, say f0 is in the explanation part below.

Here is a C++ program to the stated problem:

#include <iostream>

#include <iomanip>

#include <cmath>

int main() {

   double frequency;

   std::cout << "Enter the initial key frequency: ";

   std::cin >> frequency;

   std::cout << std::fixed << std::setprecision(2); // Set output precision to 2 decimal places

   std::cout << frequency << " ";

   for (int i = 1; i <= 4; ++i) {

       frequency *= std::pow(2, 1.0 / 12); // Calculate the next frequency

       std::cout << frequency << " ";

   }

   return 0;

}

Thus, in this program, we use the user's original key frequency as input. The starting frequency and the following four higher key frequencies are then calculated and produced using a loop.

For more details regarding C++ program, visit:

https://brainly.com/question/33180199

#SPJ6

What color is (255, 0, 255)?

A) lime
B) yellow
C) fuchsia
D) cyan

Answers

Answer:

Fuschia!

Explanation:

Try using rgb.to to find specific colors

Which is the hanging indent on the ruler?



A
B
C
D

Answers

My question needs to put 20 character long but the answer is C

One benefit of open source software is that it

Answers

Answer:B

Explanation:

What are the differences between linear algorithm and iterative algorithm

Answers

Answer:

For example Tower of Hannoi algorithm is made easy by recursion while iterations are widely used, efficient and popular. Recursive vs Iterative Algorithms: Approach: In recursive approach, the function calls itself until the condition is met, whereas, in iterative approach, a function repeats until the condition fails.

what is ur favorte star wars person?

Answers

Answer:

Hi, mi favorite is Darth Vader maybe °-°

Answer:

This is hard because there are SOOOO many from comics, movies, video games, and shows.

I'm gonna go with commander wolfe or captain rex. And yes wolfe is spelled like that.

Explanation:


Nano technology uses include...
A: Tennis racquets (high strength to weight)
B: Self-cleaning fabrics
C. Antibacterial fabrics
D: All of the above

Answers

The answer is c. Antibacterial fabrics

You learned that you can use the tags to insert a link to another webpage. One problem that webpage developers face is that, after a time, links may no longer work. Can you think of ways that you can avoid broken links?

Answers

Answer:Image Control

We can use the height and width properties to control the size of our image. Let’s say we only want the recipe image to take up approximately one-third of the page. Do you remember from math class what percentage one-third is? Type in the following CSS rule, and watch your picture change size before your very eyes!

img {

   height:33%;

   width:33%;

}

That wasn’t too difficult, right? Let’s make the image stand out a bit more by adding a border. Inside the img rule, add the following declarations:

border-style:dashed;

border-width: 5px;

Your picture should now have a dashed border around it that is five pixels in width. Play around with the different border styles that are available. You should see a drop-down box of choices, including dotted, dashed, double, groove, inset, and outset. You can also adjust the width of your border. Using your informative guessing skills, can you predict what property you might use to change the color of the border? Try it and see if you’re right!

Explanation:

 this is a direct quote from my lesson

Here is a sequence of binary digits:
011000101110010100110100010001110101001110001010101
What could this sequence represent? What could it mean?

A. A piece of text
B. A number
C. A set of instructions
D. Musical notes
E. Any piece of information

Could I have some help please?

Answers

Answer:

E

Explanation:

trust me

Even though data travels at the speed of light, networks can be slow. What affects the download speed of the network? Check all of the boxes that apply.

Answers

Answer:

bandwidth and internet connection

Explanation:

Answer: bandwidth and internet connection

Explanation:

choose one of the following about video games

Increases physical health/mobility concerns
Decrease in social interactions
Increases violent behaviors
Increases awareness in practical life skills
Decreases stress levels

Answers

Answer:

decrease in social interactions

Explanation:

if you play a video game you are starring at a screen and you are not interacting with people

Please help I will mark brainliest

Answers

Answer:

you are correct

Explanation:

Answer:

Yes it is C.

B is wrong because you need your work done and A is wrong because if your annoying she may not answer or get annoyed

What do you type in the “subject” box

(A)The title of your email/summary of what you need

(B) The persons name you are sending an email to

(C) The question you are asking

I will mark brainliest

Answers

Answer:

the correct answer is: (A) The title/summary of what you need.

Explanation:

The subject is what the receiver see's when going across the email. Putting the summary of what the email is about in subject allows them to see what the email is mainly about seeing if they should continue reading the email or not. So providing the summary pf the email lets the receiver know what the email is about. Hope this helps! :D

Color codes are stored as:


A) int
B) float
C) dec
D) Strings

Answers

Answer:

the correct answer is Strings, have a great evening yall

Explanation:

Use the drop-down menu to complete the steps for using the Goal Seek feature.
1. Go to the
tab.
2. In the
from the drop-down What-If Analysis menu.
3. Specify the cell that contains the formula to solve and enter the desired result.
4. Specify the
that contains the value to adjust.
5. Click OK
group, select

Answers

Answer:

1. Go to the  data tab.

2. In the  forecast ribbon from the drop-down What-If Analysis menu.

3. Specify the cell that contains the formula to solve and enter the desired result.

4. Specify the  changing cell that contains the value to adjust.

5. Click OK

Answer: see below

Explanation:

bob has 2 candy bars he is fat what hapennes

Answers

Answer:

he eats The candy Bar

Explanation:

I think cause As You told he is fat He might like sugary items

Answer:

It is thought that some people are destined to gain weight because they have inherited “fat genes” from their parents. There can be no doubt that people vary in their genetic makeup and some people are inclined, because of genetic reasons, to become tall, or broad-shouldered, or squat, or fat.

Explanation:

it also has to do that your digest system do not digest it fast enough

Which of these factors needs to be considered when filming in HD?
The screen is a rectangle.
The screen is a square.
There are no pixels involved.
There will be less definition in each shot.

Answers

Note that the factors that need to be considered when filming in HD is: "

There are no pixels involved. (Option C)There will be fewer definitions in each shot. (Option D)

What is HD Filming?

High-definition video is greater in resolution and quality than standard-definition video. While there is no accepted definition of high-definition, it is commonly defined as any video picture with much more than 480 vertical scan lines or 576 vertical lines.

High Definition video is of greater quality than standard definition video (or Standard Definition). The image will be crisper in HD than in SD.

Note that the screen being a rectangle or square does not need to be considered when filming in HD. However, the presence of pixels and potential loss of definition in each shot are factors that should be considered.

Learn more about filming:
https://brainly.com/question/14824318
#SPJ1

What preference should you set prior to importing a bunch of photographs?

Answers

Answer: Timeline

Explanation:

Other Questions
A roll of ribbon was 12 meters long. Diego cut 9 pieces of ribbon that were 0.4 meters each to tie some presents. He then used the remaining ribbon to make some wreaths. Each wreath required 0.6 meter. How many meters of ribbon were available for making wreaths?_____ metersHow many wreaths could Diego make with the available ribbon? _______wreaths Find A, B so that y = A sin(2) + B cos(2) is a solution to the differential equation4y'' +y' + 5y = 2 cos(x).A=BESubmit Question (Please I will mark BRAINLIEST, not lie)Use this equation to solve for the missing variable:y = 8x + 12If x = -6, y = _____If y = 13, x = _____ What is the purpose of context, or background information, in a reflective essay?to explain the effect of an eventto help readers understand the storyto show how the narrative endsto remind readers of similar stories What methods did Europeans use to colonize and maintain power and authority in this area? How do you write Days in French in the most casual way?(Please don't use a translator.) Plz help thank you!!! | -11|>2 true or false What role do race and class play in gentrification? (only do C!! ignore the other ones) but pls do thissss (HELP ASAP I'LL GIVE YOU BRAINLIEST)Willie is just starting out on his entrepreneurial journey and is looking for tools and resources to assist with structuring his business, researching the market, creating and registering his business name, and determining the right legal setup for taxes, licenses and permits. What government-based resource might Willie find helpful?A. Small Business Innovation Research (SBIR) ProgramB. Small Business Investment Company (SBIC) ProgramC. The U.S. Small Business Administration (SBA)D. GovLoans The use of a grass filter _____can help block nitrates and pesticides from washing into the water system in run off from cultivated fields. The civil and religious ruler of Muslim state Five moles of trucks would be____trucks. Jim drank 2 4/5 cups of orange juice and Jack drank 1 1/10 cups less than Jim. How much juice did jack drink? Explain your answer. 3x + 10 = -14CAN SOMEONE HELP MEEE Jack is swimming along the surface of the ocean.Max is sitting on the deck of a ship above Jack.Alex is diving beneath Jack searching for sea life.Who could be at an elevation of -5m? How does Luke react to not being able to find his family? How did the Great Depression impact Japan? What is the sum of 13.75 and -11.25 ? Show yourwork