Bios 350 Week 5 Midterm Exam 2016

BIOS 350 Week 5 Midterm exam 2016

Click Link Below To Buy:
http://hwcampus.com/shop/bios-350-week-5-midterm-exam/

1. (TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT:
2. (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?
3. (TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes
4. (TCO 5) In Excel, which of the following is NOT a method for removing a split window?
5. (TCO 5) Which of the following functions do NOT work with 3D formulas?
6. (TCO 5) Before you can create an external reference you must first __________.
7. (TCO 5) Which of the following is the proper use of a 3D formula?
8. (TCO 6) When creating a range for the substitution values in a one-variable data table, it is best to arrange them in a(n) ________ orientation.
9. (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables
10. (TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?
11. (TCO 6) The Goal Seek command is located in the ________ command on the Data tab
12. (TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:
13. (TCO 6) Where is Solver located if it is already loaded onto Excel?
14. (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?
15. (TCO 6) The maximum number of scenarios Scenario Manager can handle is: