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
<span>1. Deleting files accidentally
</span>
2. Viruses and damaging malware
3. Mechanical damages of hard drive
4. Power failures
5. Theft of computer
6. Spilling coffee, and other water damages
7. Fire accidents and explosions
<span>Hope this helps.</span>
This question should be in physics so this is my answer in C&T format-go to a online shop and order one or the pieces then follow the instructions that will be given.
integer userInput
integer i
integer mid
integer array(20) number
userInput = 1
for i = 0; userInput >= 0; i = i + 1
if number[i] > -1
userInput = Get next input
number[i] = userInput
i = i - 1
mid = i / 2
if i > 9
Put "Too many inputs" to output
elseif i % 2 == 0
Put number[mid - 1] to output
else
Put number[mid] to output