BIS 155 Week 5 Quiz.............(BIS 155 Advanced PC Applications with Lab - DeVry)

profileGuide4Students
 (Not rated)
 (Not rated)
Chat
  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)
    • 10 years ago
    BIS 155 Week 5 Quiz.............(BIS 155 Advanced PC Applications with Lab - DeVry)
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bis_155_week_5_consolidating_data_and_what-if_analysis_-_quiz.docx