To set up scenarios, you need to first use Goal seek to set up a list, then data table to set up the reference cell. Last you need to use VLOOKUP to set up the cells that display the output results from the scenario.
<h3>What is a Goal Seek in Excel?</h3>
Microsoft Excel is known to have a goal seeking tool that is said to be built-in and it is one that gives room for the user to know the desired input value for any kind of formula if the output value is said to be already known.
Hence, To set up scenarios, you need to first use Goal seek to set up a list, then data table to set up the reference cell. Last you need to use VLOOKUP to set up the cells that display the output results from the scenario.
See full question below
To set up scenarios, you need to first use to set up a list, then to set up the reference cell. Last you need to use to set up the cells that display the output results from the scenario. CHOOSE; VLOOKUP; data table Goal seek; data table; VLOOKUP Data validation; VLOOKUP; CHOOSE Data table; VLOOKUP;
Learn more about VLOOKUP from
brainly.com/question/14042837
#SPJ1
Answer:
the depth of the shaft,
the carrying load of the skip and the mass of the counterweight,
the approximate size of the winding drum,
the approximate height of the headgear and the sheave wheel
Ash is the answer. Hope this helps
I believe its E she can insert a picture in the text book
Text = “ I really like owls. Did you know that an owls eyes are more than twice as big as the eyes of other birds of comparable weight? And that when an owl partially closes its eyes during the day, it is just blocking out light? Sometimes I wish I could be an owl.
word = ‘owl’
texts = text.lower()
owlist = list(texts.split())
count = text.count(word)
num = [owlist, count] #num has no meaning just random var
print(num)
Alter in anyway you want so that you can succeed. ✌
