Spreadsheet Formulas | MCQs

Explanation

$ sign is used to create an absolute cell reference in MS Excel.

In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Explanation

The DATEDIF() function is used to get days, months, or years between two dates.

Syntax: =DATEDIF (start_date, end_date, unit).

Additional information:

 DATEDIFF()

The DATEDIFF() function returns the difference between two dates.

Syntax. DATEDIFF(interval, date1, date2).

*

DAYSBETWEEN

The daysBetween function takes startDateValue and endDateValue 

Syntax. daysBetween( date1 , date2 ).