Question 5. Question:( TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?
"[ New. Jersey. xlsx ] Qtr4!" B6 '[ New. Jersey. xlsx ] Qtr4!' B6 [ New. Jersey. xlsx ] Qtr4!, B6
[ NewJersey. xlsx ] Qtr4! B6
Question 6. Question:( TCO 5) Which formula would return the # NAME? error?
= SUM( B6. B12) = MAX( B6: B12) = AVG( B6: B12) = 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