BIS 155 Week 5 Quiz( New) For more course tutorials visit www. uophelp. com
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) 16. =========================================
BIS 155 Week 5 Quiz( New) For more course tutorials visit www. uophelp. com
Question 1. Question:( TCO 5) The tabs of grouped worksheets are displayed with a _____ background. gray yellow blue white