where is the goal seek option available ? a) pivot table. b)freeze. c)panes. d) what if analysis
Answers
Explanation:
Among the various options given in question statement the correct option is the last one.
In order to get to the goal seek option, first click on the Data tab, placed in the pane of Data Tools group. From there click on What-If Analysis and then one will see Goal Seek.
In Microsoft excel , a spreadsheet is the main area where data is entered. This spreadsheet is contains numerous cells.
In Microsoft Excel spreadsheet, rows and columns are key components in defining the exact location of any cell.
Given : Goals Seek option in Excel
To Find : where is this available in Excel
a) pivot table. b)freeze. c)panes. d) what if analysis
Solution:
First go to Data Tab
Then in toll bar - select what if analysis
then goal seek option is available there
Check attached screen shot for better idea
what if analysis is correct option
Goal Seek is used to for backward calculation
when output is know then it helps to find that what input will result in the output
Learn More
Difference between sorting and filtering in excel - Brainly.in
brainly.in/question/8773232
i am located near top of the excel window, below the quick access ...
brainly.in/question/11521467
