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 specific formatting should be applied to the columns in the Customer Data tab?

How should the column width be set for all columns in the worksheet?

What theme and font should be applied to the Customer Data Theme worksheet?

Describe the steps to apply number formatting to the columns.

What color and style should the column headings have?

How can you ensure that all data in the table is aligned to the middle?

What is the final step to complete the formatting of the worksheet?