Microsoft Excel Tutorial: How to Enter and Format Dates in Excel

Microsoft Excel Tutorial: How to Enter and Format Dates in Excel

Assessment

Interactive Video

Information Technology (IT), Architecture

10th Grade - University

Practice Problem

Hard

Created by

Wayground Content

FREE Resource

This video tutorial covers how to enter and format dates in Excel. It explains the standard numeric format for dates and demonstrates how to customize date formats using slashes and other separators. The tutorial also covers using Excel formulas to extract specific components of a date, such as the day, month, or year. Viewers are encouraged to practice these techniques and reach out with any questions.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the standard format of a date in Excel?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you customize the date format in Excel?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What options are available for displaying dates in Excel?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What formula would you use to get today's date in Excel?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the steps to display only the month from a date in Excel.

Evaluate responses using AI:

OFF

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?