The Complete Excel Guide: Beginners to Advanced - Module 4 - Practice Exercise

This video tutorial guides users through navigating Excel workbooks, focusing on a loan workbook with two sheets: terms of loan and detail sheet for a five-year loan. It covers navigating sheets, linking cells with formulas, freezing rows, and using the split screen option. The tutorial concludes with a transition to the next module on page setup and print options in Excel.

What are the names of the two sheets available in the loan workbook?

What information can you list on the 'terms of loan' sheet?

How do you link cell C9 on the detail sheet to D3 on the terms of loan sheet?

What is the purpose of freezing rows one through seven in the detail sheet?

Describe the split option and its function in the workbook.