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 is the purpose of the 'terms of loan' sheet in the loan workbook?

• To display a summary of all loans

• To calculate the total interest paid over the loan term

• To list the principal amount, interest rate, and term in months

• To provide a detailed breakdown of monthly payments

Which cell on the 'detail sheet' should be linked to D3 on the 'terms of loan' sheet?

• D10

• B5

• C9

• A1

What is the purpose of freezing rows in Excel?

• To keep specific rows visible while scrolling

• To lock the entire sheet from editing

• To prevent accidental deletion of data

• To highlight important data

How does the split option help in navigating a workbook?

• It allows you to edit multiple cells at once

• It provides a summary of all data in the sheet

• It enables viewing two parts of the sheet simultaneously

• It automatically adjusts column widths

What should you do after completing the navigation tasks in module 4?

• Share the workbook with a colleague

• Rewatch the entire module for better understanding

• Move on to module 5 to learn about page setup and print options

• Close the workbook and shut down the computer