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