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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

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.

Read more

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Data Validation

Remove Duplicates

Conditional Formatting

Filter

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Currency

Short Date

Long Date

Percentage

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Ampersand (&)

TEXTJOIN

CONCAT

CONCATENATE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

StoreCode-Country

StoreCode/ Country

StoreCode - Country

StoreCode:Country

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Sales_Records

Data_Table

Sales_Data

Store_Sales

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?