MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

Explain the following terms giving suitable examples:

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 2051


i) Pivot table : A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages, or display the details for areas of interest.

ii) Scenario : A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.
Allows you to create, manipulate and save a number of different scenario, that use different input variable to produce different outputs.It can allow upto 32 cells to change the value in order to see the changes and it can print a summary.

iii) Goal Seek : Allows you to find the correct input to the desired output. Simple to use but limited in power and flexibility. When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature. When goal seeking, Microsoft Excel varies the value in one specific cell until a formula that's dependent on that cell returns the result you want.


Didn't find what you were looking for? Find more on Explain the following terms giving suitable examples: Or get search suggestion and latest updates.

Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].