Unit- 7 Electronic Spreadsheet (Advanced)
Chapter- 15 Data Analysis in MS Excel
I. Multiple choice questions. Tick the correct answer.
1. Which of the following features allows you arrange data in a worksheet in a particular order?
a. auto filter b. sorting c. custom formatting d. consolidation
Answer: Sorting
2. Which tab will you open to access the consolidate option?
a. home tab b. insert tab c. data tab d. analysis tab
Answer: Data tab
3. Which of these is not a valid formula in Microsoft Excel?
a. =123+456 b. A3*B2+C5 c. =A1+B1+C1+D1 d. =$D3+B$2
Answer: A3*B2+C5
4. Which tab will you open to access the filter option?
a. tools tab b. sheet tab c. data tab d. insert tab
Answer: Data tab
5. Which of these data types is not allowed in Excel worksheets?
a. text b. double c. formulas d. numbers
Answer: Double
6. Which of the following will open the consolidate dialog box?
a. Data tab--->consolidate b. Home tab-->consolidate c. Data tab-->Analysis group--->consolidate d. Formulas---->consolidate
Answer: Data tab--->consolidate
7. Which of the following is not a What if analysis tool?
a. scenarios b. Goal seek c. Data table d. consolidate
Answer: Consolidate
8. Which of these function helps us to calculate EMIs on a loan amount?
a. =avg() function b. =EMI() function c. PMT() function d. None of these
Answer: =EMI() function
9. Which mechanism helps us to filter out unnecessary data while viewing a worksheet?
a. sorting b. searching c. validating d. filtering
Answer: Filtering
10. Which statement best describes an Excel What if analysis Goal Seeking?
a. Allows you to define output results and then shows what input values are needed to generate that result.
b. Allows you to investigate how changes to one or two input variables in a formula changes output results.
c. Allows you to define input variables in various situations. The output result for each situation is show in a summary table.
d. All of these
Answer: All of these
11. Which of the following is OT an example of a what if analysis?
a. find the how raises will affect employee salaries
b. find the five top sales people in a company
c. find the business profits for different levels of sales
d. find the loan payments based for different interest rates.
Answer: Find the five top sales people in a company
12. Which of these options are available in the data tab of MS Excel?
a. sort, filter b. consolidate, data validation c. subtotals, solver d. all of these
Answer: All of these
13. Which of these groups will contain the solver command in the data tab?
a. sort & filter group b. connections group c. analysis group d. none of these
Answer: Analysis group
14. Which of these will help you to generate a summary report for different scenarios?
a. summary button b. report button c. add button d. none of these
Answer: Summary button
II. Fill in the blanks:
1. The ____ toolbar displays icons to perform most common operations while working in Excel.
Answer: Quick Access
2. _____ are mathematical expressions to perform calculations on data.
Answer: Formulas
3. _____ is a process of inspecting, cleansing, transforming, and modeling data with the aim of deriving useful information from it.
Answer: Data Analysis
4. The feature that allow us to put together data from various locations within a spreadsheet at one place is called_________
Answer: data consolidation
5. The _______ tool is nothing but a more elaborate form of the Goal seek.
Answer: Solver
6. The ______ feature determines input values needed to achieve a specific goal.
Answer: Goal seek
7. A ________ is a set of values that Excel saves and can substitute automatically on your worksheet.
Answer: Scenario
8. After scenarios are added to a spreadsheet, we can jump to a particular scenario by selecting it from the list in the ______ dialog box.
Answer: Scenario manager
9. You can click on the ______--->what-if Analysis-->--________from the data tools group to open the Goal seek dialog box.
Answer: Data tab, Goal seek
10. In Excel, there are mainly three kinds of what if data analysis tools_____ , Goal seek and Data tables.
Answer: Scenario
11. ____ help you to retrieve only the relevant information filtering away the un-desirable data.
Answer: Filtering
12. To remove subtotals, open the subtotal dialog box and click on the_____.
Answer: Remove all button
13. The ______ feature allows us to divide data into groups so that it can be easily viewed and analyzed.
Answer: Subtotal
14. We use the _______ function to calculate EMIs on a loan amount.
Answer: =EMI()
Some other Links:
No comments:
Post a Comment