Solved

If You Want to Create a Cell Reference to the Range

Question 111

Multiple Choice

If you want to create a cell reference to the range B5:E5 on the Summary Info worksheet of the Sales.xls workbook you would use the following external reference: ____.


A) '[Sales.xlsx]Summary Info'\B5:E5
B) '(Sales.xlsx) Summary Info'!B5:E5

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q106: You can use the _ dialog box

Q107: When you save a worksheet as a

Q108: Once a file has been stored in

Q109: Excel will prompt you to update the

Q110: Identify the letter of the choice that

Q112: To add total sales from two worksheets-cell

Q113: The default template contains the default formatting

Q114: The default template contains the default formatting

Q115: Identify the letter of the choice that

Q116: When the destination file is closed and