Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

To get data from cell A1 inside another workbook which answer is correct?

1) sheet1!$A$1

2) $A$1sheet1

3)(book1.xls)sheet1!A1

4)book1.xlsx.sheet1

5)[book1.xlsx]sheet1!A1

 

Programming Microsoft Excel Data Entry Computer Skills MS Office tools
user-image
Question added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/04/07
Upvote (1) Views (4) Followers (4) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Zaheer Ur Rahim Khan
by Zaheer Ur Rahim Khan , Assistant Manager Finance Accounts , Rafid for Automotive Solutions LLC

The right answer is

5)[book1.xlsx]sheet1!A1

Olu Olatubosun
by Olu Olatubosun , Head of Information Technology Department , Intercontinental Capital Markets Limited

The correct Answer is option5

Mohamed Rahimtulla
by Mohamed Rahimtulla , IT Administrator/Support , Hyper Direct Ltd

The answer is

1) sheet1!$A$1

Write Your Answer
More Questions Like This