what is the purpose of the \create links to source data\ button? it generates a link to an index of the…
what is the purpose of the \create links to source data\ button? it generates a link to an index of the formulas available with excel. it generates a link to the contributing worksheets. it generates a link to the top row of the worksheet.
Answer
Brief Explanations:
In Excel, the "Create links to source data" button in the Consolidate feature creates links to the worksheets that contribute data to the consolidation. This allows for easy updating of the consolidated data if the source - data changes.
Answer:
It generates a link to the contributing worksheets.