Information Technology
Class-10
Part-B
Unit- 2 Electronic Spreadsheet (Advanced)
PART-II
C. Short Answer type Questions:
1. What is consolidating of data?
Answer: To summarize and view results from different worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet or in other workbooks.
2. Write the steps to create subtotals in a worksheet.
Answer: To create subtotals in a Microsoft excel worksheet, you can follow these steps:
1. Organize the data in your worksheet.
2. Select a cell in your data set.
3. Go to the data tab and click subtotal in the outline group.
4. In the subtotal dialog box, specify the following: Column to group by, Summary function, Columns to subtotal.
5. Click OK.
3. What is the use of what if scenario?
Answer: By using What-If analysis tools in MS-Excel, you can use several different sets of values in one or more formulas to explore all the various results.
4. What is the use of Goal Seek?
Answer: Goal Seek is a tool that helps you find the input value needed to achieve a desired result from a formula. Goal Seek is a type of what if analysis that's useful in financial modeling and other financial analysis.
It is also useful for:
* Determining the interest rate needed for a loan.
* Calculating the score needed on a test to earn a desired grade.
* Determining the score needed on a final exam to pass a class.
5. What is the use of Solver?
Answer: Solver is a Microsoft excel add-in program you can use for what-if analysis. It can solve for a maximum value of a number, a minimum value of a number or an exact number. It works within constraints so if one variable can't be changed or can only vary within a specified range, solver will take that into account.
6. Write the steps of using Goal Seek.
Answer: Steps to use Goal Seek excel:
1. Put the cursor on the cell that contains the output you want to change.
2. On the data ribbon, select what-if analysis, then select Goal Seek.
3. When the dialog box appears make "Set cell" equal to the revenue cell.
4. Set "To value" equal to the output you want to achieve.
5. Set "By changing cell" equal to the assumption you want to solve.
6. Press OK.
7. Write the steps of using Solver.
Answer: To use solver in excel you can:
1. Load the solver add-in.
2. Click data>solver
3. Define the problem.
4. In the solver parameters dialog box, click options.
5. Select the show iteration results check box.
6. Click ok.
7. Click solve.
8. Click stop to stop the solution process and display the solver result.
9. Click continue to continue the solution process and display the next trial solution.
.jpg)
