= IF ( A6 =" Atlanta ", A3,0 )
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 )? A1 A2 A3 A1 & A2
Question 8 . Question : ( TCO 6 ) A one-variable data table must have at least _____ blank row ( s ) and _____ blank column ( s ) between the dataset and the data table . two , two two , one one , two one , one
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 ? Scenario Manager Goal Seek One-variable data table Two-variable data table
Question 10 . Question : ( TCO 6 ) After entering the substitution values and the reference to a formula , the next step to complete a twovariable data table and view the results is to enter the cell references in the Column input cell box . enter the cell references in the Row input cell box . click the What-If analysis command . drag to select the data table boundaries .
Question 11 . Question : ( TCO 6 ) The Goal Seek command is located in the _____ command on the Data tab . What-If Analysis