Goal Seek changes the value of on cell by modifying:Group of answer choicesOnly one other cellMultiple cellsA Scenario SummaryA Pivot Table

Use the image below to answer the questions that follow. Flag question: Question 6Question 6Tips1 pts6.1Which of the following functions would you use to calculate the value of cell C18.(1)Group of answer choices=SUM=COUNT=COUNTIF=COUNTA Flag question: Question 7Question 7Tips2 pts6.2In column D certain cells have been shaded and the text has been changed by the use of conditional formatting, you can specify certain through the use of to apply this formatting.(2) Flag question: Question 8Question 8Tips1 pts6.3Which function can be used in cell C16 to determine the lowest price value?(1)Group of answer choices=MINIMAL=LOWEST=MIN=LOW Flag question: Question 9Question 9Tips1 pts6.4Looking at cell D2 in our image we can see that the heading text for for this particular cell is displayed on 2 lines one below the other. Which formatting option of Microsoft Excel was used for this?(1)Group of answer choicesText RotationMerge and CenterText GroupingText Wrapping Flag question: Question 10Question 10Tips1 pts6.5Which of the following functions can be used to calculate the total income received by all of the AI companies as displayed in cell C15?(1)Group of answer choices=SUM=COUNT=AVERAGE=TOTAL Flag question: Question 11Question 11Tips1 pts6.6The cell range A1:E12 has only outside borders applied to it.(1)Group of answer choicesTrueFalse

The Goal Seek command allow the user to get the desired result by making changes in *One cell.Two Cells.Three Cells.N no. of cells.

A work sheet includes columns forGroup of answer choicesadjusting entriesclosing entriesreversing entriesadjusting and closing entries

The purpose of the Goal Seek function in Excel is: Group of answer choices To evaluate what needs to be changed in the input variables in order to achieve a certain output variable value To evaluate what can be done to the output variable value in order to update the values of input variables To evaluate what needs to be changed in the input variables in order to maximise the value of the output variable To evaluate what needs to be changed in the output variable’s value in order to minimise mistakes To evaluate the best calculation in order to achieve a certain goal.

Use Goal Seek to find the value for cell C2 that will result in a value of $550,000 for cell B15. Accept the solution.