Which option represents the location of the Goal Seek function? Goal tab Data tab, Forecast group Formulas tab, Forecast group Insert tab on the ribbon

Question

Social Studies

Stephen Duke

30 January, 19:40

Which option represents the location of the Goal Seek function? Goal tab Data tab, Forecast group Formulas tab, Forecast group Insert tab on the ribbon

+4

Answers (2)

Know the Answer?

Kayley · Answer 1

Goal Tab Data Tab

Explanation:

For example, a spreadsheet is created. Select the desired cell, then from the data tab select what if analysis and then goal seek.

Brendon Gates · Answer 2

Data tab

Explanation:

The Object Seek function (also known as What-if-Analysis) is an analysis mode in which the solution to the desired output is achieved by changing an assumption that guides it. This famous function basically uses trial and error, that is, to solve the problem, repeated attempts are made until reaching the result. The most used software to perform this type of analysis is Excell.

With that in mind, to perform this type of analysis you gotta open Excell and its location is On the Data tab, in the Data Tools group.