A question bank for every class and subject

Practice questions, with answers and explanations included

794 questions available

Refine

All questions

794 results
321

Which function calculates the average of a set of numbers in Calc?

MCQ Easy
a. SUM()
b. AVERAGE()
c. PRODUCT()
d. COUNT()
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
AVERAGE()
Explanation: The AVERAGE() function calculates the average of the given arguments.
322

Evaluate the logical expression: (5 > 3) && (2 < 1)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: The expression (5 > 3) && (2 < 1) evaluates to false, based on the rules of && (both true), || (either true), and ! (negation).
323

Which arithmetic operator returns the remainder of division of two operands?

MCQ Easy
a. /
b. %
c. //
d. \
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
%
Explanation: The modulus operator (%) returns the remainder of the division of its operands.
324

As per operator precedence in spreadsheet formulas, which operation is performed first (in the absence of parentheses)?

MCQ Medium
a. Addition
b. Subtraction
c. Multiplication/Division
d. None, all are equal priority
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Multiplication/Division
Explanation: Multiplication and division are performed before addition and subtraction, unless parentheses dictate otherwise.
325

Evaluate the logical expression: (5 > 3) || (2 < 1)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: The expression (5 > 3) || (2 < 1) evaluates to true, based on the rules of && (both true), || (either true), and ! (negation).
326

Given int a=20, b=30; what is the value of a/b in Java (integer division)?

MCQ Medium
a. 0
b. 1
c. 0.67
d. 50
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
0
Explanation: In integer division, 20/30 evaluates to 0 since the quotient is truncated (fraction discarded).
327

Which function calculates the square root of a number n?

MCQ Easy
a. POWER(n;p)
b. SQRT(n)
c. ABS(n)
d. LOG(n;b)
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
SQRT(n)
Explanation: SQRT(n) calculates the square root of the number n.
328

Evaluate the logical expression: (10 == 10) && (4 != 4)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: The expression (10 == 10) && (4 != 4) evaluates to false, based on the rules of && (both true), || (either true), and ! (negation).
329

Given int a=20, b=30; what is the result of the expression a%b?

MCQ Medium
a. 0
b. 10
c. 20
d. 1.5
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
20
Explanation: a % b returns the remainder of a divided by b: 20 % 30 = 20 (since 20 is less than 30, the whole of a is the remainder).
330

What does the formula =A3+$B$3 become when copied from cell A4 to cell B4?

MCQ Hard
a. 2
b. 3
c. #VALUE!
d. 4
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
2
Explanation: This is mixed addressing: the relative part A3 becomes B3, while the absolute part $B$3 remains unchanged.
331

Evaluate the logical expression: (10 == 10) || (4 != 4)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: The expression (10 == 10) || (4 != 4) evaluates to true, based on the rules of && (both true), || (either true), and ! (negation).
332

Which operator returns true if the values of both operands are equal, and is NOT to be confused with the assignment operator?

MCQ Easy
a. =
b. ==
c. :=
d. ===
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
==
Explanation: The == operator is the relational 'equal to' operator; = is the assignment operator, a common source of confusion for beginners.
333

All cell references in a spreadsheet are relative by default.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: By default, cell references are relative and adjust automatically when formulas are copied or filled.
334

Evaluate the logical expression: !(5 > 3)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: The expression !(5 > 3) evaluates to false, based on the rules of && (both true), || (either true), and ! (negation).
335

Given int a=20, b=30; which relational expression evaluates to TRUE?

MCQ Easy
a. a==b
b. a>b
c. a<b
d. a>=b
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
a<b
Explanation: a<b (20<30) evaluates to true; a==b, a>b, and a>=b are all false.
336

In a formula, both operands and the operator must be provided, while in a function only the operands (arguments) are provided.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: Functions have predefined operations, so only arguments are supplied, unlike formulas which require explicit operators.
337

Evaluate the logical expression: !(2 > 5)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: The expression !(2 > 5) evaluates to true, based on the rules of && (both true), || (either true), and ! (negation).
338

Which assignment operator is shorthand for 'a = a + b'?

MCQ Easy
a. a =+ b
b. a += b
c. a -= b
d. a *= b
Information Technology (802) · Class 12 · Sep 26, 2026
Show answer
a += b
Explanation: The += operator adds the right operand's value to the left operand and assigns the result, equivalent to a = a + b.
339

What is a cell reference in a spreadsheet?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: A cell reference (or address) identifies the location of a cell or group of cells in a worksheet, using the column letter followed by the row number, e.g., A1.
340

Evaluate the logical expression: (6 >= 6) && (3 <= 3)

MCQ Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: The expression (6 >= 6) && (3 <= 3) evaluates to true, based on the rules of && (both true), || (either true), and ! (negation).