Google Sheet For Intermediate Date Function | Quizalize

My Classes
Find resources
My Library
Create

Loading...

Google Sheet For Intermediate Date Function | Quizalize

placeholder image to represent content

Google Sheet For Intermediate Date Function

Quiz by grace

Customize this quiz to suit your class

Instantly translate to 100+ languages

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

Loading...

3 questions

Q.

Which function will convert a date in the text format to date format?

1

300 sec

Q.

John was born on 1 July 2000. What would be the correct date function to calculate his age?

2

300 sec

Q.

Which function is use to calculate the working days in between two dates?

3

300 sec

Loading...

Q 1/3
Score 0
Which function will convert a date in the text format to date format?
300
=Now()
=Datevalue(date_string)
=Today()
=Datedif(start_date, end_date, unit)
Q 2/3
Score 0
John was born on 1 July 2000. What would be the correct date function to calculate his age?
300
=DATEDIF("2000/7/1",today(),"Y")
=today()-date(year(2000),month(7),day(1))
=today()-2000/7/1
=DATEDIF(2000 July 1,today(),"Y")

Give this quiz to my class

as a classroom game

as homework

as an exam

as a printed PDF

Related quizzes

Google Sheet For Intermediate
Google Sheet For Intermediate (Logical Function)
Google Sheet For Beginners (Part 3)
Google Sheet For Beginners ( Part 2)
Google Sheet For Beginners (Part 1)
(not using) Google Sheet For Beginners (Part 2)
How To Do SEO Keyword Research In Google Sheets Using An API For Free
Import NBA Basketball Data Into Google Sheets Using An API For Free