Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - working with templates

This video tutorial guides viewers through creating an invoice template in Excel, setting up a new workbook with multiple sheets, entering and formatting data, and saving the workbook in a designated folder. The tutorial includes a demonstration of each step, ensuring learners can follow along and practice the skills taught.

What is the first step in creating a template from the template library?

• Search for the keyword 'invoice'

• Rename the worksheet

• Open a new workbook

• Enter data into the worksheet

After creating a new blank workbook, what should you rename the first sheet to?

• Template

• Invoice

• Summary

• Data

Which of the following is NOT a worksheet name you need to create?

• Sales Data

• Calculations

• Invoices

• Charts

What should be the font size and style for the title 'Sales Data for 2020'?

• 12 points, italic

• 10 points, regular

• 14 points, bold

• 16 points, underline

Which months should be filled in using the fill handle after entering 'Jan'?

• February and March

• August and September

• April and May

• June and July

What is the final task in this exercise?

• Format the title

• Enter data for revenue

• Create a new worksheet

• Save the workbook in a new folder

What should you name the folder where the workbook is saved?

• Excel Practice Files

• Excel Files

• Workbook Templates

• Practice Workbook