Correctly

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.

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.

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.

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

• =ISDATE()

• =ISTEXT()

• =ISNUMBER()

• =ISBLANK()

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

• Data Validation

• Conditional Formatting

• Text to Columns

• Data Consolidation

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

• Currency

• Date

• Text

• General

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.

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.