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

This video tutorial guides students through setting up a loan workbook in Excel. It covers modifying headers and footers, adding comments, adjusting page margins, centering content, setting print titles, and printing the workbook. The tutorial concludes with saving and closing the file, preparing students for the next module on working with rows, columns, and cells.

What is the first step in setting up the Excel workbook according to the tutorial?

• Create a new workbook

• Open the loan workbook and navigate to the detail sheet

• Check for spelling errors

• Insert a new worksheet

Where should you add the date in the Excel workbook?

• Top left corner

• Bottom left corner

• Top right corner

• Bottom right corner

What comment should be added to cell C9?

• This is the beginning balance of this loan

• This is the monthly payment

• This is the interest rate

• This is the loan term

How should the page be centered after adjusting the margins?

• Not centered

• Horizontally

• Diagonally

• Vertically

Which rows should be set as print titles?

• Rows 1 through 3

• Rows 8 through 10

• Rows 11 through 14

• Rows 4 through 7