Question BIS 155 Advanced PC Applications

BIS 155 Advanced PC Applications

Week 5

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

1. (TCO 5) When multiple worksheets are selected, the word ________ appears in the title bar. (Points : 2)
2. (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? (Points : 2)
3. (TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the…. (Points:2)
4. (TCO 5) After saving the arrangement of windows, a workbook can be opened by opening __file. (Points:2)
5. (TCO 5) Which of the following functions do NOT work with 3D formulas? (Points : 2)
6. (TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT: (Points : 2)
7. (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)
8. (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)
9. (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of…..? (Points : 2)
10. (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)
11. (TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)
12. (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools…..? (Points:2)
13. (TCO 6) Which of the following is NOT one of the three parameters in Solver? (Points : 2)
14. (TCO 6) Which of the following is NOT required for Solver to generate a solution? (Points : 2)
15. (TCO 6) The initial results of a Goal Seek are: (Points : 2)

Week 5 iLABS

BIS 155 Week 5 iLab (Bruno s Pizza Analysis)

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.