Tag: web technology

Questions Related to web technology

Extracts from a database a single record that matches the specified criteria

  1. GETDATA

  2. GETDB

  3. DGET

  4. None of the Above


Correct Option: C

Returns the maximum value from selected database entries

  1. DMAX

  2. DBMAX

  3. MAXDATA

  4. None of the Above


Correct Option: A

Multiplies the values in a particular field of records that match the criteria in a database

  1. DMAX

  2. DPRODUCT

  3. DMIN

  4. DGET


Correct Option: B

Returns data stored in a PivotTable

  1. PIVOTTABLE

  2. PIVOTDATA

  3. GETPIVOTDATA

  4. None of the Above


Correct Option: C

Converts a serial number to an hour

  1. GETHOUR

  2. HOUR

  3. EHOUR

  4. None of the Above


Correct Option: B
  1. WORKDAY

  2. NETWORKDAY

  3. NETWORKDAYS

  4. WORKDAYS


Correct Option: C

Returns the serial number of the current date and time

  1. NOW

  2. TIME

  3. SYSDATE

  4. SYSTIME


Correct Option: A

Estimates the standard deviation based on a sample of selected database entries

  1. DAVERAGE

  2. DSTDEV

  3. DSTDEVP

  4. None of the Above


Correct Option: B

Calculates the standard deviation based on the entire population of selected database entries

  1. DVAR

  2. DSTDEV

  3. DSTDEVP

  4. DAVERAGE


Correct Option: C

Adds the numbers in the field column of records in the database that match the criteria

  1. DSUM

  2. DSTSUM

  3. SUMDATA

  4. ADD_DATA


Correct Option: A