BIS 155 WEEK 5
Week 5 Quiz
Question :
(TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT:
Question :
(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?
Question :
(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.
Question :
(TCO 5) In Excel, which of the following is NOT a method for removing a split window?
Question :
(TCO 5) Which of the following functions do NOT work with 3D formulas?
Question :
(TCO 5) Before you can create an external reference you must first __________.
Question :
(TCO 5) Which of the following is the proper use of a 3D formula?
Question :
(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.
Question :
(TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables.
Question :
(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?
Question :
(TCO 6) The Goal Seek command is located in the ________ command on the Data tab.
Question :
(TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:
Question :
(TCO 6) Where is Solver located if it is already loaded onto Excel?
Question :
(TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?
Question :
(TCO 6) The maximum number of scenarios Scenario Manager can handle is:
USA 
India