Quiz

  1. 1
    Beginner

    Imagine that you have two workbooks, called 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 new row was inserted at A4 in Sheet1 of the Data workbook, then saved and closed. Next time the Master workbook is opened, what does the formula read?

  2. 2
    Beginner

    Imagine that you have two workbooks, called 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, the Data workbook was moved to a new folder: D:\Courses\GoSkills. Next time the Master workbook is opened, what does the formula read?

  3. 3
    Beginner

    Suppose you link to cell A5 on Sheet1 of a workbook called “Target.xlsx”. When you initially create the link in Excel, how will it read?