Question: Module 5 Generating Reports from Multiple Worksheets and Workbooks Excel EX 5-33 Session 5.2 Quick Check 1. What is the external reference to cell C20

 Module 5 Generating Reports from Multiple Worksheets and Workbooks Excel EX

Module 5 Generating Reports from Multiple Worksheets and Workbooks Excel EX 5-33 Session 5.2 Quick Check 1. What is the external reference to cell C20 of the Final Report worksheet located in the Annual Statement.xlsx workbook? 2. What is the external reference to cell D10 of the Sunday worksheet located in the Weekly Report.xslx workbook that is stored in the C:\Documents Reports folder? 3. When would you paste a copied cell using the Paste Link option? 4. How do you check the status of a link within the current workbook to determine whether the link's source file is accessible and up-to-date? 5. How does Excel indicate that a cell contains linked text? 6. What does Excel do when a hyperlink is clicked by the user

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!