BIS 155 Advanced PC Applications
Week 5
Data Consolidation and What-if Analysis (Graded)
Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.
Week 5 Quiz
(TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2)
(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2)
(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the…. (Points:2)
(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening __file. (Points:2)
(TCO 5) Which of the following functions do NOT work with 3D formulas? (Points : 2)
(TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT: (Points : 2)
(TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)
(TCO 6) In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5% and 6.5% are the ________ values. (Points : 2)
(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of…..? (Points : 2)
(TCO 6) After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to: (Points : 2)
(TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)
(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools…..? (Points:2)
(TCO 6) Which of the following is NOT one of the three parameters in Solver? (Points : 2)
(TCO 6) Which of the following is NOT required for Solver to generate a solution? (Points : 2)
(TCO 6) The initial results of a Goal Seek are: (Points : 2)
Week 5 iLABS
BIS 155 Week 5 iLab (Bruno s Pizza Analysis)