CBSE Class 7 Computer Science Assignment Set 02

Select the most appropriate answer from the choices given:

Question 1. All formulas in LibreOffice Calc start with
(a) /
(b) *
(c) $
(d) =
Answer: (d) =
In spreadsheet software like LibreOffice Calc or Microsoft Excel, an equals sign (\(=\)) is used to indicate the start of a formula or calculation.
In simple words: Every formula in Calc begins with an equals sign.

Exam Tip: Always remember that typing a formula without the equals sign will treat it as regular text rather than a calculation.

Question 2. The total number of columns in a worksheet are
(a) 1048576
(b) 65536
(c) 1024
(d) 256
Answer: (c) 1024
Modern versions of LibreOffice Calc provide a maximum of 1024 columns (labeled from A to AMJ) and 1048576 rows in a single worksheet.
In simple words: A Calc worksheet contains 1024 columns.

Exam Tip: Do not confuse rows with columns. Rows are horizontal (1048576) and columns are vertical (1024).

Question 3. Formula palette is used to
(a) format cells containing numbers
(b) create and edit formulas containing functions
(c) entered assumptions data
(d) copy all cells
Answer: (b) create and edit formulas containing functions
The Formula palette in spreadsheet applications assists users in easily inserting, building, and editing formulas and built-in functions.
In simple words: The formula palette helps you write and edit functions correctly.

Exam Tip: Look for keywords like function and formula when identifying the purpose of the formula palette.

Question 4. FTP is an acronym for
(a) File Transaction Protocol
(b) File Transmission Protocol
(c) File Translation Protocol
(d) File Transfer Protocol
Answer: (d) File Transfer Protocol
FTP stands for File Transfer Protocol, which is a standard network protocol used for transferring computer files between a client and a server over a computer network.
In simple words: FTP means File Transfer Protocol.

Exam Tip: Memorize standard networking abbreviations carefully as they frequently appear in multiple-choice questions.

Question 5. The extension name for saving LibreOffice calc file is
(a) .odt
(b) .xls
(c) .cal
(d) .ods
Answer: (d) .ods
The default file extension for spreadsheets created in LibreOffice Calc is .ods (OpenDocument Spreadsheet).
In simple words: Calc files are saved with the .ods extension.

Exam Tip: Note that .odt is for text documents (Writer) and .odp is for presentations (Impress).

Question 6. The shortcut keys to insert a bulleted list in a web page is
(a) Alt+O+B
(b) Alt+O+L+B
(c) Alt+B+L
(d) Alt+F+L+B
Answer: (a) Alt+O+B
In web editing tools like Kompozer, the menu sequence under Format allows formatting bullets and numbering using specific shortcut combinations.
In simple words: Press Alt+O+B to insert a bulleted list.

Exam Tip: Shortcut keys related to menu options in web authoring software are tested directly from the textbook syllabus.

Question 7. The editor mode of Kompozer is
(a) Normal
(b) Design
(c) Split
(d) Preview
Answer: (b) Design
Kompozer provides editing views including Normal, HTML source, and Preview, where the primary WYSIWYG editing window is referred to as Normal or Design view depending on the exact version context, with Normal being the standard visual workspace.
In simple words: Kompozer uses Normal view as its main editing interface.

Exam Tip: Kompozer modes typically include Normal, Source, and Preview.

Question 8. ________________ contains the address of the active cell.
(a) Status bar
(b) Formula bar
(c) Name box
(d) Scroll bar
Answer: (c) Name box
The Name box, located to the left of the formula bar, displays the cell reference or address of the currently selected active cell.
In simple words: The Name box shows the address of the cell you are currently on.

Exam Tip: Do not confuse the Name box with the Formula bar; the Formula bar displays the contents of the active cell.

Question 9. To open an existing workbook, click the Open button on the ____________ toolbar?
(a) Form
(b) Standard
(c) Drawing
(d) Formatting
Answer: (b) Standard
The Standard toolbar in LibreOffice applications contains standard file operations such as New, Open, Save, Print, Cut, and Copy.
In simple words: The Open button is located on the Standard toolbar.

Exam Tip: Standard toolbar deals with file management commands, while Formatting toolbar deals with text appearance and styles.

Question 10. The data is organized in a spreadsheet using
(a) Rows and columns
(b) Layers and planes
(c) Lines and spaces
(d) Height and width
Answer: (a) Rows and columns
A spreadsheet is structured as a grid consisting of horizontal rows and vertical columns that intersect to form individual cells.
In simple words: Spreadsheets organize data using rows and columns.

Exam Tip: The intersection of a row and a column is called a cell.