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 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
Get step-by-step solutions from verified subject matter experts
