Questions Library

Class 11

Information Technology (802)

443 questions available

Refine

All questions

443 results
201

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).
202

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.
203

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).
204

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.
205

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).
206

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.
207

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).
208

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.
209

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).
210

Explain the difference between Relative, Absolute, and Mixed addressing in a spreadsheet with examples.

LONG Hard
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Relative Addressing: cell references adjust automatically based on their relative position when copied, e.g., =A3 in cell A4 becomes =B3 when copied to B4. Absolute Addressing: uses $ before column and row (e.g., =$A$3) so the reference does not change when copied. Mixed Addressing: combines both, e.g., $A3 or A$3, where only the part prefixed with $ remains fixed while the other part changes relatively when copied.
211

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

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

Which Impress view shows all slides in miniature form for easy rearrangement?

MCQ Easy
a. Normal
b. Outline
c. Slide Sorter
d. Notes Page
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Slide Sorter
Explanation: Slide Sorter view presents all slides in miniature form, allowing easy viewing and moving of slides.
213

What is the valid range of values for the Java 'byte' data type?

MCQ Medium
a. -128 to 127
b. 0 to 255
c. -2147483648 to 2147483647
d. -1 to 1
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
-128 to 127
Explanation: The byte data type in Java has the range -128 to 127.
214

Which view allows a presenter to add notes visible only to them, not the audience?

MCQ Medium
a. Slide Show
b. Notes Page
c. Handout Page
d. Outline
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Notes Page
Explanation: Notes Page view allows the presenter to add notes for a slide, visible only to the presenter, not the audience.
215

What is the valid range of values for the Java 'short' data type?

MCQ Medium
a. -32768 to 32767
b. 0 to 255
c. -2147483648 to 2147483647
d. -1 to 1
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
-32768 to 32767
Explanation: The short data type in Java has the range -32768 to 32767.
216

Formatting changes made in which feature are automatically applied to all slides of the presentation?

MCQ Medium
a. Slide Sorter
b. Slide Master
c. Handout Page
d. Outline View
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Slide Master
Explanation: The Slide Master allows changing background color, text color, bullet style, etc., which then applies to all slides.
217

What will be the result of the Calc formula =4+3*2 ?

MCQ Medium
a. 10
b. 9
c. 11
d. 20
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
10
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =4+3*2 evaluates to 10.
218

The Slide Show view allows editing of slide content during the presentation.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: Slide Show view shows the slides as they will be actually presented; no editing can take place in this view.
219

What will be the result of the Calc formula =10-2*3 ?

MCQ Medium
a. 4
b. 8
c. 3
d. 5
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
4
Explanation: Following operator precedence (parentheses, then multiplication/division, then addition/subtraction, left to right), =10-2*3 evaluates to 4.
220

What is the purpose of the Handout Page view in a presentation?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Handout Page view displays slides on a page as they would appear when printed, and the number of slides per handout page can be varied.

Related resources

More for Information Technology (802)
Question papers Notes Practice quiz

Latest questions

Convert: 7 GB = ______ MB.
Information Technology (802) Sep 26, 2026
The term 'Computer' is derived from which word?
Information Technology (802) Sep 26, 2026
Convert: 2 TB = ______ GB.
Information Technology (802) Sep 26, 2026
Which characteristic of a computer refers to producing wrong output due to wrong input, commonly called GIGO?
Information Technology (802) Sep 26, 2026
Convert: 3 TB = ______ GB.
Information Technology (802) Sep 26, 2026
Which of the following is an example of secondary storage?
Information Technology (802) Sep 26, 2026