Microsoft Excel 2021365 - Beginner to Advanced - Applying Date and Time Formats

Microsoft Excel 2021365 - Beginner to Advanced - Applying Date and Time Formats

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers the basics of number formatting in Excel, focusing on date and time formatting. It explains how dates are stored as numbers in Excel, starting from January 1, 1900, and how to apply short and long date formats. The tutorial also discusses the importance of locale settings for date formats, especially when working with international clients. Additionally, it covers time formatting options, including 24-hour and 12-hour clocks, and how to apply formatting to empty cells.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF