Top Posters
Since Sunday
c
6
r
4
c
3
m
3
h
3
1
3
n
3
s
3
d
3
c
3
r
3
e
3
New Topic  
JohnAmera JohnAmera
wrote...
Posts: 432
Rep: 0 0
6 years ago
Match each of the following references to its best description:

I.   [mineapolis.xlsx]Qtr3!A1
II.   '[St Paul.xlsx]Qtr3'!A1
III.   '[International Falls.xlsx]Qtr 3 Sales'!A1
IV.   'C:\Data[Minneapolis.xlsx]Sheet1'!A1
V.   B3

A.   External reference in which Workbook or worksheet name contains spaces; source and destination files are in the same folder.
B.   External reference in which Workbook and worksheet names do not contain spaces; source and destination files are in the same folder returning the same value for ties.
C.   Cell reference in the same worksheet.
D.   External reference in which source workbook is in a different folder than the destination workbook.
E.   External reference in which Worksheet name contains spaces; source and destination files are in the same folder.
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 87 times
1 Reply
Exploring Microsoft Office Excel
Replies
Answer verified by a subject expert
zatan_zazatan_za
wrote...
Posts: 265
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here

Related Topics

JohnAmera Author
wrote...

6 years ago
Helped a lot
wrote...

Yesterday
Thank you, thank you, thank you!
wrote...

2 hours ago
This helped my grade so much Perfect
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1301 People Browsing
Related Images
  
 114
  
 968
  
 313
Your Opinion
Which country would you like to visit for its food?
Votes: 262