Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - format data, apply, and customize themes

The video tutorial covers formatting data and applying themes in a spreadsheet. It begins with an introduction to the Customer Data tab, where viewers are instructed to format data to match a reference tab. Key formatting tasks include setting column widths, applying number formats, and aligning text. The tutorial also covers applying borders with varying thicknesses. In the second part, viewers learn to change the theme, font, and colors of the worksheet. The tutorial provides step-by-step instructions to ensure the formatted data matches the reference.

What is the initial task for the Customer Data tab?

• To format it like the Custom Data Formatted tab

• To apply a new theme

• To delete unnecessary columns

• To add new data entries

What should be the width of all columns on the Customer Data tab?

• 30

• 25

• 15

• 20

Which number format is applied to column B?

• Currency

• Long date

• Short date

• Percentage

How should the data in the table be aligned?

• Top

• Right

• Middle

• Left

What is the color of the thicker border applied to column headings?

• Light blue

• Dark gold

• Red

• Green

Which theme should be applied to the worksheet?

• Aspect

• Ion

• Metro

• Savon

What font should be used for the theme?

• Calibri

• Cambria

• Times New Roman

• Arial