Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
Assume you have two workbooks: Master and Data. A cell in Master contains a link to a cell in Data, with the formula ='C:\GoSkills\[Data.xlsx]Sheet1'!B5. While the Master workbook was closed, a user inserted a new row at A4 in Sheet1 of the Data workbook, saved it and closed it. Next time the Master workbook is opened, what will the formula read?
='C:\GoSkills\[Data.xlsx]Sheet1'!B5
='C:\GoSkills\[Data.xlsx]Sheet1'!B6
='C:\GoSkills\[Data.xlsx]Sheet1'!$B$5
Don’t know
2
Beginner
Assume you have two workbooks: Master and Data. A cell in Master contains a link to a cell in Data, with the formula ='C:\GoSkills\[Data.xlsx]Sheet1'!B5. While the Master workbook was closed, a user moved the Data workbook to a new folder: D:\Courses\GoSkills. Next time the Master workbook is opened, what will the formula read?
='D:\Courses\GoSkills \[Data.xlsx]Sheet1'!B5
='C:\GoSkills\[Data.xlsx]Sheet1'!B5 (but Excel would pop up an error message that the workbook couldn’t be found.)
='C:\GoSkills\[Data.xlsx]Sheet1'!B5 (with no obvious notification about the broken link.)
Don’t know
3
Beginner
If you want to convert all linked cells into values, so that you can send your file to another user, how would you do this?
Go to the File tab and select Check for Issues > Check Compatibility > Convert Links to Values
Go to Data > Edit Links, select the link in question, and click Break Link
Select all cells on the worksheet, copy them, then perform a PasteSpecial > Values operation
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement