web technology Online Quiz - 149

DSTDEVP is the Excel database function that calculates standard deviation based on the entire population of selected database entries. The 'P' suffix indicates population rather than sample. DVAR calculates variance, not standard deviation.

DSUM is the Excel database function that adds the numbers in a field column of records that match the specified criteria. It's the database-specific version of the SUM function.

DVAR is the Excel database function that estimates variance based on a sample from selected database entries. DVARP would calculate variance for the entire population. DVARIABLE is not a valid function name.

EDATE is the Excel function that returns the serial number of a date that is the indicated number of months before or after the start date. It preserves the day of the month (adjusting for month-end if needed).

EOMONTH is the Excel function that returns the serial number of the last day of the month before or after a specified number of months. The 'EO' prefix stands for 'End Of'.

The DATE function in Excel returns a serial number representing a specific date when given year, month, and day arguments. Excel stores dates as sequential serial numbers so they can be used in calculations. DATEVALUE is for converting text dates, not constructing dates from components.

DATEVALUE converts a date stored as text into a serial number that Excel recognizes as a date. This is useful when importing data or working with dates that are formatted as text strings. DATE itself constructs a date from numeric components.

DAVERAGE is a database function that calculates the average of values in a column of a database list that match specified conditions. The 'D' prefix indicates it's a database function, not the regular AVERAGE function. Options like AVERAGEDATE and AVGDATE don't exist in Excel.

The SECOND function extracts the seconds component (0-59) from a time serial number. Excel stores times as fractional parts of a day, and SECOND returns just the seconds portion. Functions like ESECOND, GETSECOND, and CONVSECOND don't exist in Excel.

WEEKDAY returns a number (1-7) representing the day of the week for a given date serial number. By default, Sunday=1 and Saturday=7, though this can be customized. COUNTWEEK and COUNTDAY are not valid Excel functions.

WEEKNUM returns the week number (1-52 or 1-53) of a specific date within the year. This helps identify which week of the year a date falls in. Functions like GETWEEK and GETWEEKNUM don't exist in Excel.

WORKDAY calculates a date that is a specified number of working days before or after a given date, excluding weekends and optionally holidays. This is essential for business date calculations. WEEKNUM and DAYS serve different purposes.

The YEAR function extracts the year component (as a 4-digit number) from a date serial number. This is straightforward and commonly used in date analysis. YEARS and YEARSFRAC are not standard Excel functions (YEARFRAC exists but serves a different purpose).

YEARFRAC calculates the fraction of a year represented by the number of whole days between two dates. This is useful for financial calculations involving partial years. The correct spelling is YEARFRAC, not YEARSFRAC. YEAR simply extracts the year from a date.

The TIME function returns a serial number representing a specific time when given hour, minute, and second arguments. Excel stores times as fractional parts of a day. NOW returns both date and time, DATE only handles dates.

TIMEVALUE converts a time stored as text into a serial number that Excel recognizes as a time. This is the time equivalent of DATEVALUE. Functions like TIMEVALUES and STRINGTIME don't exist in Excel. TIME itself constructs a time from numeric components.

TODAY returns the serial number of the current date (no time component). NOW returns both date and time. TIME only deals with time values. WEEKDAY extracts the day of week from a date. TODAY is the correct function for getting just today's date.

Stateful session beans maintain conversational state with a specific client and are created when the client invokes the create() method on the Home interface. They cannot be shared between clients - each client gets its own bean instance.

Message-driven beans are different from session and entity beans - they don't have business interfaces (Remote/Local) that clients call directly. Instead, they listen to JMS messages and process them asynchronously, so they lack a Component interface.

When passing objects to remote methods in Java RMI, objects are passed by serialized copy (deep copy). This serialization process creates an object copy on the receiving side. By reference is not possible across JVM boundaries.