Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 - preparing data for analysis

The video tutorial guides viewers through a series of data preparation tasks in Excel. It covers removing blank rows and duplicate records, applying correct number formatting, adding a new column for Region Code, and combining store and country codes. Finally, it demonstrates how to organize the cleaned data into an Excel table named Store_Sales.

What is the first step in preparing data for analysis as mentioned in the video?

• Create a table

• Remove blank rows

• Add a new column

• Apply number formatting

Which Excel feature is used to remove duplicate records from a dataset?

• Data Validation

• Remove Duplicates

• Conditional Formatting

• Filter

What number format is applied to the date column in the video?

• Currency

• Short Date

• Long Date

• Percentage

Which function is NOT mentioned as a method to combine text in Excel?

• Ampersand (&)

• TEXTJOIN

• CONCAT

• CONCATENATE

What is the correct format for the new Region Code column?

• StoreCode-Country

• StoreCode/ Country

• StoreCode - Country

• StoreCode:Country

What is the final step in the data preparation process as shown in the video?

• Remove duplicates

• Apply number formatting

• Create an Excel table

• Add a new column

What name is given to the Excel table created in the video?

• Sales_Records

• Data_Table

• Sales_Data

• Store_Sales