# Devry BIS 155 Quiz 5 Latest

\$16

## Devry BIS 155 Quiz 5 Latest

These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the “Details” section below. Date Taken: Time Spent: 13 min , 35 secs

Question Type: # Of Questions: # Correct:

Multiple Choice 15 15

Question 1. Question : (TCO 5) The tabs of grouped worksheets are displayed with a ________ background.

Question 2. Question : (TCO5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets:

Question 3. Question : (TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.

Student

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.

Instructor Explanation: Textbook Chapter 8

Question 5. Question : (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?

Question 6. Question : (TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT:

Question 7. Question : (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)?

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.

Question 9. Question : (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?

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?

Question 11. Question : (TCO 6) The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal Seek dialog box.

Question 12. Question : (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

Question 13. Question : (TCO 6) Which of the following is NOT one of the three parameters in Solver?

Question 14. Question : (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?

Question 15. Question : (TCO 6) The maximum number of scenarios Scenario Manager can handle is: