Excel Date and Time Functions

This video tutorial explains how to quickly enter the current date and time in Microsoft Excel. It covers using keyboard shortcuts to input the current date and time, as well as utilizing Excel functions like TODAY() and NOW() to achieve the same results. The tutorial provides step-by-step instructions and examples to help users efficiently manage date and time entries in Excel.

What keyboard shortcut is used to enter the current date in Excel?

• Ctrl + Shift + Alt + ;

• Ctrl + Alt + ;

• Ctrl + ;

• Ctrl + Shift + ;

Which key combination will input the current time in an Excel cell?

• Ctrl + ;

• Ctrl + Shift + ;

• Ctrl + Alt + ;

• Ctrl + Shift + Alt + ;

What happens if you hold the keys too long when entering the current time in Excel?

• Nothing will happen

• The time will not be entered

• The time will be entered multiple times

• The time will be entered incorrectly

Which formula can be used to get the current date in Excel?

• =DATE()

• =NOW()

• =TODAY()

• =CURRENTDATE()

What does the formula '=NOW()' return in Excel?

• Only the current date

• Only the current time

• Neither date nor time

• Both current date and time

How is the output of '=NOW()' formatted in Excel?

• As a time only

• As a date and time

• As a number

• As a string