Quiz

  1. 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?

  2. 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?

  3. 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?