Because a Line Chart is usually used to display data over a period of time – this is why a date field is required. The scatter plot needs two different numeric variables, therefore no date field is required.

Because the difference is expressed in units of months without decimals, so 1 month and 16 days the result is 2. If you would want to calculate the difference in months with decimals you should apply a custom division (number of days divided to the average number of days per month or another month lenght in days you wish).

Tricky but useful Qs

Good questions to practice.

9th question answer is 48.. I am not sure how 2 is coming. can you explain

Months not days

Hi Kumar,

The formula refers to a difference between the 2 dates in months, so the answer 2 is correct in this case.

Hope this makes it clear,

Narcis

I don’t understand the first question, why line chat requires data field but scatter plot doesn’t ?

Hi Troy,

Because a Line Chart is usually used to display data over a period of time – this is why a date field is required.

The scatter plot needs two different numeric variables, therefore no date field is required.

Hope this helps,

Narcis

Why question 9 is 2 months? The difference between November 14th, 2017, and January 1st, 2018 is 1 month and 16 days.

Hi Sisi,

Because the difference is expressed in units of months without decimals, so 1 month and 16 days the result is 2. If you would want to calculate the difference in months with decimals you should apply a custom division (number of days divided to the average number of days per month or another month lenght in days you wish).

Hope this helps,

Narcis