Details of this Paper

DeVry Chicago BIS 155 Week 5 Quiz 2014




Week 5 Quiz1. Question: (TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT;Student Answer: create Pivot Charts.;group worksheets together to enter data.;display worksheets side by side.;create links among the worksheets.;Question 2. Question: (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?;Student Answer: Click the first tab, hold Shift, and then click the last tab.;Click the first tab, hold Ctrl, and then click the last tab.;Right-click a worksheet tab, then select Select All Sheets.;Right-click a worksheet tab, then select Group.;Question 3. 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.;Student Answer: horizontal;vertical;diagonal;square;Question 4. Question: (TCO 5) In Excel, which of the following is NOT a method for removing a split window?;Student Answer: Drag a split bar to the edge of the worksheet.;Double-click a split bar.;Click Split in the Window group on the View tab.;Right-click in the active cell and click Remove.;Question 5. Question: (TCO 5) Which of the following functions do NOT work with 3D formulas?;Student Answer: SUM;VLOOKUP;AVERAGE;COUNT;Question 6. Question: (TCO 5) Before you can create an external reference you must first __________.;Student Answer: select the cell or cells to hold the external reference.;open the destination workbook and all source workbooks.;switch to the source workbooks and click the cells.;click on Insert Function on the Formulas tab.;Question 7. Question: (TCO 5) Which of the following is the proper use of a 3D formula?;Student Answer: =SUM(Yr1:Yr5!C7);=SUM(Yr1-Yr5!C7);=SUM('Yr1:Yr5'!C7);=SUM("Yr1:Yr5"!C7);Question 8. 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.;Student Answer: horizontal;vertical;alphabetical;reverse;Question 9. Question: (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables.;Student Answer: one;two;three;four;Question 10. 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?;Student Answer: Scenario Manager;Solver;Data Table;Goal Seek;Question 11. Question: (TCO 6) The Goal Seek command is located in the ________ command on the Data tab.;Student Answer: What-If Analysis;Data Validation;Consolidate;Advanced;Question 12. 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;Student Answer: scenario names.;formatting of the results.;cells containing the formulas that generate the results.;final result.;Question 13. Question: (TCO 6) Where is Solver located if it is already loaded onto Excel?;Student Answer: Add-Ins tab;Formulas tab;Analysis group on the Data tab;Data Tools group on the Data tab;Question 14. Question: (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?;Student Answer: Add;Format;Change;Delete;Question 15. Question: (TCO 6) The maximum number of scenarios Scenario Manager can handle is;Student Answer: 30;32;18;16


Paper#35199 | Written in 18-Jul-2015

Price : $22