High School

You are preparing an accreditation report for your university. You have several workbooks of data for each college, such as Arts, Sciences, and Business. Assuming the individual workbooks are stored in the same folder as the University workbook, how would a link to cell B15 in the Digital Media worksheet in the School of Computing workbook appear in the University workbook?

Answer :

Final answer:

To create a link to cell B15 in the Digital Media worksheet in the School of Computing workbook from the University workbook, use the formula: '[School of Computing.xlsx]Digital Media'!B15.

Explanation:

To create a link to cell B15 in the Digital Media worksheet in the School of Computing workbook from the University workbook, you would use a formula that includes the file path, workbook name, and worksheet name. The formula would look like this:

= '[School of Computing.xlsx]Digital Media'!B15

Here, '[School of Computing.xlsx]' is the name of the School of Computing workbook, 'Digital Media' is the name of the worksheet, and 'B15' is the cell reference.

Learn more about Workbook links here:

https://brainly.com/question/32818309

#SPJ11

Other Questions