Maxima and Minima

The "Maximum" (MAX) function in Excel calculates the largest value in a set of numbers. "Average" calculates the mean, "Count" counts the cells with numbers, and "Minimum" (MIN) finds the smallest value.

Group functions (aggregate functions) like MIN(), MAX(), and SUM() operate on multiple rows and return a single result. SQRT() is a scalar function that operates on individual values, returning the square root of a single number, making it the correct answer as 'not a group function'.

In IBM COBOL with ARITH(COMPAT) compiler option, the FACTORIAL function accepts integer arguments from 0 to 28 maximum. This is due to the storage size limitations for the result - values beyond 28! exceed standard numeric representation capacity.

Scalar functions operate on single values and return single values. MID() extracts a substring from a text value, and NOW() returns the current timestamp - both are scalar. MAX() and SUM() are aggregate functions that operate on multiple rows and return summary values.

Math.max(x, y) returns the larger of two numbers. Option A is correct. Option B is a non-existent function, and options C and D use ceil which rounds up a single number rather than comparing two.

Math.max(x, y) returns the largest of zero or more numbers. Option B (Math.ceil) rounds up to the nearest integer but doesn't compare values. Options A and C are non-existent functions.

The system limits keyword functions to a maximum of 63 characters. This is a common technical constraint in many systems that ensures manageable function names and prevents excessively long identifiers.

The system limits keyword functions to a maximum of 63 characters. This is a common technical constraint in many systems that ensures manageable function names and prevents excessively long identifiers.

The MAX function returns the largest value in a range of numbers. Average calculates the mean, Count tallies numeric entries, and Min finds the smallest value. These are all basic statistical functions in Excel.

S9(8) specifies an 8-digit signed integer in binary computational format. The maximum value is 99999999 (8 nines), which fits within the 4-byte binary storage used for S9(5) through S9(9) fields.

F(x) = 3x⁴ –16x³ + 24x² + 37 f₁ (x) = 12x³ – 48x² + 48x Here, f₁ (x) = 0 ^{$\Rightarrow$} x³ – 4x² + 4x = 0 ^{$\Rightarrow$} x(x – 2)² = 0 ^$\therefore$ x = 0, 2, 2 

-2^8-1 = -128