Using Date and Time Function Excel

Using Date and Time Function Excel

7th Grade - University

7 Qs

quiz-placeholder

Similar activities

Test Excel

Test Excel

10th - 12th Grade

9 Qs

Access - Lesson 14

Access - Lesson 14

9th - 12th Grade

10 Qs

Web-II-Loop and Function

Web-II-Loop and Function

University

10 Qs

Programming

Programming

University

12 Qs

What would you do if...

What would you do if...

1st - 12th Grade

10 Qs

แบบทดสอบก่อนเรียนวิชาโปรแกรมฐานข้อมูล

แบบทดสอบก่อนเรียนวิชาโปรแกรมฐานข้อมูล

9th - 12th Grade

10 Qs

Xâu kí tự

Xâu kí tự

10th Grade

10 Qs

NHTW Programming

NHTW Programming

9th Grade

10 Qs

Using Date and Time Function Excel

Using Date and Time Function Excel

Assessment

Quiz

Computers

7th Grade - University

Practice Problem

Hard

Created by

Ekaterina Rudakova

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the function that shows the current date and time from your local computer

NOW

TODAY

DATE

TIME

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

TODAY function does not take any arguments.

True

False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What date Excel’s serial number begins on?

January 1, 1900

December 31, 1899

January 1, 0000

Excel's serial numbers cover any date

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function is useful for extracting only the month value for a date.

mmmm

MONTH

SHOWM

DATE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function calculates the number of days between two dates as a whole number.

DAYS

=end date - start date

SUM

DAY

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would we use to calculates the end date of the project that lasts 25 business days?

=WORKDAY(start date, # of days, holiday date range)

=WEEKDAY(date value, return type)

=DATEVALUE(date in text form)

=DAYS(end date, start date)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function will show the day of the week for the date stored in cell A2, assuming that Monday is the first day of the week?

=WEEKDAY(A2,2)

=DAY(A2)

=DAY(A2,1)

=WEEKDAY(A2,0)

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?