Unit- 7 Electronic Spreadsheet (Advanced)
Chapter- 15 Data Analysis in MS Excel
Part-2
III. Short Answer Questions:
1. Differentiate between a worksheet and a workbook.
Answer: A Workbook is a spreadsheet file that we open in MS Excel to do our work. Workbook open with three worksheets.
A Worksheet is like a page of the workbook file. It is a grid of numerous rectangular boxes arranged in horizontal rows and vertical columns.
2. What is data sorting in Excel? How will you arrange data in an ascending order in the worksheet?
Answer: Sorting data means arranging it in a particular order. Arranging data in a worksheet in a particular order like ascending order or descending order.
Follow the steps to sort the data in ascending order:
1. Select the data that you want to arrange.
2. Click on Data tab
3. Click on Sort button on sort & filter group
4. Click on sort data in ascending order.
3. What is a filter? What is its utility?
Answer: When a sheet contains a large amount of data, it can be difficult to find information quickly. In that case filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.
4. What is data analysis in context of a spreadsheet program?
Answer: Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the aim of deriving useful information from it, which can further be used in an organizations decision making process.
5. What is data consolidation? Can it be implemented on multiple sheets?
Answer: Data Consolidate is a feature that allows us to combine information from multiple workbooks/worksheets into one place. The Excel is consolidate feature lets you select data from its various locations and creates a table to summarize the information for you using one of the several functions such as sum or average etc.
6. Differentiate between the Goal Seek and Solver features.
Answer: If you know the result that you want from a formulae, but you are not sure what input value, the formula requires to get that result, you can use the Goal seek feature.
Solver is a Microsoft Excel add-in program that can be used for what-if analysis. We use solver to determine the maximum or minimum value of one cell by changing other cells.
7. What is meant by what if analysis? List three types of what if analysis tools available in Excel.
Answer: The What if analysis is a powerful feature in MS Excel. During what if analysis we change the values in cells to see how these changes will affect the outcome of a formula on the worksheet. This makes it possible for us to experiment with the worksheet data and explore various outcomes for different set of values.
8. What is the scenario tool? Discuss in brief.
Answer: A Scenario is a set of values that excel saves for a group of cells. Whenever we run a scenario excel automatically substitutes the saved cell values into a connected formula to give us an output. By having different scenarios for a same group of cells we can get different results from the formula and compare these results to know which is the most suitable set of values for us.
9. How will you use the scenario manager to switch between different scenarios in a worksheet?
Answer: Open Data tab, in the data tools group click on what-if analysis command. From the drop down menu select scenario manager. This will open up the scenario manager dialog box.
In this dialog box, click the ad button to open the add scenario dialog box.
Enter a name for the scenario in the scenario name box. It's best to use a name that clearly identifies the scenario. Here we have named the scenario as carloan_scenario1.
10. What do you understand by data filtering? How many types of filters are there in Excel?
Answer: When a sheet contains a large amount of data, it can be difficult to find information quickly. In that case filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.
There are three types of filters like standard filter, auto filter and advanced filter.
11. What does the Excel's Subtotal feature help us to do?
Answer: The subtotal feature creates a summarized outline of data in a worksheet. It allows us to divide data into groups so that it can be easily viewed and analyzed. There are two ways of creating subtotals in an Excel worksheet.
1. Using the subtotals command from the data tab, and
2. Using the subtotal function from the insert function dialog box.
Some other links:
No comments:
Post a Comment