Correctly

Correctly

Assessment

Interactive Video

Other, Social Studies, Information Technology (IT), Architecture

KG - University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

The video addresses a common issue in Excel where dates do not sort correctly by year. The instructor investigates the problem, finding that dates are formatted as text rather than dates. A solution is provided using Excel's 'Text to Columns' feature to correctly format the dates, allowing them to be sorted properly. The video concludes with a verification of the solution, ensuring that dates are now recognized and sorted correctly.

Read more

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What issue did Imran face with sorting dates in Excel?

Dates were missing from the spreadsheet.

Dates were not sorting by year.

Dates were not formatted correctly.

Dates were duplicated.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What was the first step in investigating the date sorting issue?

Checking if the dates were formatted as text.

Checking if the dates were formatted as numbers.

Checking if the dates were formatted as dates.

Checking if the dates were formatted as currency.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula was used to test if a cell contained text?

=ISDATE()

=ISTEXT()

=ISNUMBER()

=ISBLANK()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What tool in Excel was used to convert text-formatted dates to recognized dates?

Data Validation

Conditional Formatting

Text to Columns

Data Consolidation

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What format should be selected in the 'Text to Columns' wizard to ensure dates are recognized?

Currency

Date

Text

General

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you visually identify if a date is recognized by Excel?

It is bold.

It is right-aligned.

It is italicized.

It is left-aligned.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

After applying the solution, what was the final step to verify the dates were sorted correctly?

Check if the dates are bold.

Check if the dates are italicized.

Check if the dates are sorted by month.

Check if the dates are sorted by year.

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?