Tag: web technology

Questions Related to web technology

Estimates variance based on a sample from selected database entries

  1. DVARIABLE

  2. DVARP

  3. DVAR

  4. None of the Above


Correct Option: C

Returns the serial number of the date that is the indicated number of months before or after the start date

  1. EDATE

  2. DDATE

  3. DATEVALUE

  4. None of the Above


Correct Option: A

Returns the serial number of the last day of the month before or after a specified number of months

  1. LASTDAYMONTH

  2. DMONTH

  3. EMONTH

  4. EOMONTH


Correct Option: D

Returns the serial number of a particular date

  1. DATE

  2. DATEVALUE

  3. DAY

  4. DGET


Correct Option: A

Converts a date in the form of text to a serial number

  1. DATE

  2. DATEVALUE

  3. DAYS360

  4. DGET


Correct Option: B

Converts a serial number to a second

  1. ESECOND

  2. GETSECOND

  3. CONVSECOND

  4. SECOND


Correct Option: D

Converts a serial number to a day of the week

  1. COUNTWEEK

  2. WEEKNUM

  3. WEEKDAY

  4. COUNTDAY


Correct Option: C

Converts a serial number to a number representing where the week falls numerically with a year

  1. GETWEEK

  2. GETWEEKNUM

  3. WEEKNUM

  4. COUNTWEEK


Correct Option: C

Returns the serial number of the date before or after a specified number of workdays

  1. WORKDAY

  2. WEEKNUM

  3. DAYS

  4. None of the Above


Correct Option: A