Page 225 - IT_Play_V1.0 Class9
P. 225
Recap Zone
A spreadsheet package is an application software that does analysis, calculations, comparisons and
displays information in the required format and in charts and graphs.
Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position.
Columns are the vertical set of rectangular boxes that are placed adjacent to each other.
A rectangular box formed by the intersection of a row and column is called a cell.
The active cell in a spreadsheet is known as the Cell Pointer.
A group of cells is known as a cell range.
Each cell in the sheet has a unique address that is formed by the intersection of its column and row.
Navigator is a feature in LibreOffice Calc by which the cursor can be placed anywhere on a sheet
directly.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. What is the primary purpose of a spreadsheet application?
i. To write articles ii. To store images
iii. To perform calculations and display information iv. To create graphics
2. Which menu in LibreOffice Calc contains commands like Open, Save, and Print?
i. Edit ii. View iii. File iv. Insert
3. Which type of range includes cells A1 to A5 in a column?
i. Horizontal Range ii. Vertical Range iii. Mixed Range iv. None of these
4. What is the maximum number of columns available in a LibreOffice Calc's sheet?
i. 1024 ii. 2048 iii. 10,48,576 iv. 256
5. Which of the following is a valid cell address?
i. 1A ii. A5 iii. 5A iv. B2C
B. State whether the following statements are true or false:
1. A cell address is a combination of row number and column label. .......................
2. Horizontal scroll bars help move the spreadsheet vertically. .......................
3. A spreadsheet consists of multiple sheets by default. .......................
4. The Sidebar in LibreOffice Calc provides access to Properties and Functions. .......................
5. The cell A1 in a spreadsheet is always highlighted when a new sheet is created. .......................
21 st
C. Assertion and reasoning questions. Century #Information Literacy
Skills
The following questions consist of two statements – Assertion (A) and Reason (R). Answer these questions by
selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
iii. A is true but R is false.
iv. A is false but R is true.
Create a Spreadsheet 223

