Question bank

Class 11

1 subject · 443 questions

Refine

All questions

443 results
401

A macro in Calc records:

MCQ Medium
a. Only mouse clicks
b. Only keystrokes
c. Both mouse clicks and keystrokes performed while working
d. Only cell formatting changes
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Both mouse clicks and keystrokes performed while working
Explanation: A macro records every mouse click and keystroke performed to complete a task, so it can be played back later.
402

By default, recorded macros in Calc use which type of cell referencing?

MCQ Hard
a. Relative referencing
b. Absolute referencing
c. Mixed referencing
d. No referencing
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Absolute referencing
Explanation: By default, recorded macros use absolute cell referencing, recording exact cell locations.
403

Which menu is used to start recording a macro in Calc?

MCQ Medium
a. File > Macros > Record Macro
b. Tools > Macros > Record Macro
c. Insert > Macros > Record Macro
d. Format > Macros > Record Macro
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Tools > Macros > Record Macro
Explanation: Macros are recorded via Tools > Macros > Record Macro on the Menu bar.
404

While printing a spreadsheet, you can choose to print all sheets, selected sheets, or selected cells only.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
TRUE
Explanation: The Print dialog box in Calc allows selecting All Sheets, Selected Sheets, or Selected Cells, along with page ranges and number of copies.
405

A chart, once inserted in Calc, cannot be resized or moved afterward.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: Charts can be moved by dragging and resized using the resizing handles that appear on the chart border after it is inserted.
406

What is an Active Cell in a spreadsheet?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: The Active Cell is the currently selected cell in a spreadsheet, identified by its column letter and row number.
407

What is the AutoFill feature used for in Calc?

SHORT Easy
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: AutoFill is used to automatically generate data in a range of cells based on a defined series (e.g., continuing a sequence of numbers or dates, or copying a formula relatively across cells).
408

Explain the steps to filter data using Standard Filter in Calc to display male students having more than 75 marks (using AND).

LONG Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Step 1: Select the data range. Step 2: Go to the Data menu and click Filter -> Standard Filter, which opens a dialog box. Step 3: Add the criteria Gender = 'Male' AND Marks > 75 in the dialog box. Step 4: Click OK. The AND operator ensures that only rows satisfying both criteria are displayed.
409

List the steps required to insert a chart in Calc, and name any three types of charts available.

LONG Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Step 1: Select the data to be included in the chart. Step 2: Go to Insert menu and select Chart (or click the Chart icon on the Standard toolbar). Step 3: The Chart Wizard dialog box opens allowing selection of chart type, data range, data series, and chart elements. Step 4: Select the desired chart type and click Finish. Calc offers a choice of 10 chart types including Column chart, Bar chart, Pie chart, Line chart, and Scatter chart.
410

Which tab in OpenOffice Impress is used to check the spelling of content in a presentation?

MCQ Easy
a. Format
b. Tools
c. Insert
d. Slide Show
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Tools
Explanation: The Tools tab contains the Spelling command to check the spelling of presentation content.
411

Which tab contains commands like Slide Show Settings, Custom Animation, and Slide Transition?

MCQ Medium
a. View
b. Format
c. Slide Show
d. Window
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Slide Show
Explanation: The Slide Show tab contains commands used during presentation of the slide show, such as Slide Show Settings, Custom Animation, and Slide Transition.
412

Which term refers to the visual pattern applied when moving from one slide to the next (e.g., wheel, diamond)?

MCQ Medium
a. Slide Animation
b. Slide Transition
c. Slide Master
d. Slide Layout
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Slide Transition
Explanation: Slide Transition is the pattern shown when one slide changes to the next; Slide Animation applies to elements within a single slide.
413

How many tabs does OpenOffice Impress have according to the textbook?

MCQ Medium
a. Six
b. Seven
c. Eight
d. Nine
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Eight
Explanation: OpenOffice Impress has eight tabs: File, Edit, View, Insert, Format, Tools, Slide Show, and Window.
414

Slide animation applies to the pattern shown when transitioning between two different slides.

TRUE FALSE Medium
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: Slide animation applies to how elements within a single slide appear (their order, effect); slide transition applies to the change between slides.
415

Differentiate between Slide Transition and Slide Animation.

SHORT Medium
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Explanation: Slide Transition is the visual pattern that appears when one slide changes to the next (e.g., wheel, diamond). Slide Animation applies to elements within a single slide, controlling how and in what order they appear on screen.
416

Which of the following is NOT a popular DBMS mentioned in the textbook?

MCQ Easy
a. MySQL
b. Oracle
c. Microsoft Access
d. Adobe Photoshop
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
Adobe Photoshop
Explanation: Popular DBMSs mentioned include MySQL, PostgreSQL, Microsoft Access, Oracle, Microsoft SQL Server, DB2, and Sybase. Adobe Photoshop is image-editing software, not a DBMS.
417

If a table T1 has columns C1, C2, C3 as a combined (composite) primary key, which of the following is true?

MCQ Hard
a. Any one of C1, C2, C3 individually can contain NULL
b. None of C1, C2, C3 can contain NULL values
c. Duplicate combinations of C1,C2,C3 are allowed
d. Only C1 needs to be unique
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
None of C1, C2, C3 can contain NULL values
Explanation: For a composite primary key, no column forming the key can contain NULL values, and the combination of all key columns must be unique across rows.
418

What is the main similarity between Primary Key, Candidate Key, and Alternate Key?

MCQ Hard
a. They are all data types
b. They can all uniquely identify a row (or could have, in the case of candidate/alternate keys)
c. They must all be numeric
d. They are all optional and can be duplicated
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
They can all uniquely identify a row (or could have, in the case of candidate/alternate keys)
Explanation: Primary Key, Candidate Key, and Alternate Key are all capable of uniquely identifying rows in a table; only one candidate key is chosen as the primary key.
419

MySQL is a proprietary (closed-source) RDBMS software that requires payment for use.

TRUE FALSE Easy
a. TRUE
b. FALSE
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
FALSE
Explanation: MySQL is an Open Source RDBMS Software, available free of cost.
420

Which statement is used to modify data in a table (from the textbook's MCQ exercise)?

MCQ Easy
a. CHANGE
b. MODIFY
c. UPDATE
d. SAVE AS
Information Technology (802) · Class 11 · Sep 26, 2026
Show answer
UPDATE
Explanation: UPDATE is the correct SQL statement used to modify existing data in a table.