Date & Time
=DAYS360(start_date,end_date,[method])
Quiz =DAYS360 — 15 Questions
15 quiz questions about =DAYS360 — test syntax, arguments, examples & errors!
Questions:
10 questions
15 questions
Random 10 or 15 questions from the pool + shuffled options each time
Progress — 15 questions
1 of 15
Question 1 of 15
1/15
Is argument “dAYS360” required in =DAYS360?
Explanation: “dAYS360” is optional.
Question 2 of 15
2/15
What is the type of argument “dATE” in =DAYS360?
Explanation: Type of “dATE” is “Date”.
Question 3 of 15
3/15
Is argument “end_date” required in =DAYS360?
Explanation: “end_date” is optional.
Question 4 of 15
4/15
Is argument “start_date” required in =DAYS360?
Explanation: “start_date” is optional.
Question 5 of 15
5/15
Which use case fits =DAYS360?
Explanation: Use case “Date & Time Calculations” fits DAYS360.
Question 6 of 15
6/15
Is =DAYS360 volatile?
Explanation: DAYS360 is not volatile.
Question 7 of 15
7/15
Which function is NOT related to =DAYS360?
Explanation: “FORECAST.ETS.SEASONALITY” is not related to DAYS360.
Question 8 of 15
8/15
Is argument “dATE” required in =DAYS360?
Explanation: “dATE” is optional.
Question 9 of 15
9/15
How many arguments does =DAYS360 have in total?
Explanation: =DAYS360 has 0 required, 5 optional (5 total).
Question 10 of 15
10/15
What is the type of argument “method” in =DAYS360?
Explanation: Type of “method” is “Logical”.
Question 11 of 15
11/15
In =DAYS360, which is argument #1?
Explanation: Argument #1 is “start_date”.
Question 12 of 15
12/15
What is the type of argument “end_date” in =DAYS360?
Explanation: Type of “end_date” is “Date”.
Question 13 of 15
13/15
Is argument “method” required in =DAYS360?
Explanation: “method” is optional.
Question 14 of 15
14/15
Which is the correct syntax of =DAYS360?
Explanation: Correct syntax: =DAYS360(start_date,end_date,[method])
Question 15 of 15
15/15
Which function is related to =DAYS360?
Explanation: “DATEDIF” is related to DAYS360.