Which of the following references is written incorrectly?
A) =[e09h2Indianapolis_LastFirst.xlsx]Yearly Totals!$F$3
B) ="October Sales"!E3+"November Sales"!E3+"December Sales"!E3
C) ="[e09h2Bloomington_LastFirst.xlsx]Yearly Totals"!$F$3
D) =SUM("Qtr1:Qtr4"!E3)
Correct Answer:
Verified
Q4: To examine multiple worksheets in the same
Q5: When worksheets are grouped,[Group] is displayed in
Q6: A hyperlink to a worksheet always references
Q7: When creating a data validation rule,you can
Q8: You would use _ to monitor data
Q10: When using Trace Precedents and Trace Dependents,tracer
Q11: When referencing a worksheet in another workbook,the
Q12: In a 3-D reference,worksheets references are separated
Q13: To ungroup worksheets,right-click any one of the
Q14: To group adjacent worksheets,you:
A)click the first worksheet
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents