BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 107

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 :
the #NAME? error?

(TCO 5) Which formula would return

=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