Digital Learning

Tuesday, November 18, 2025

How to apply functions in Spreadsheet? Class-9-PART-B UNIT-IV-CH-2:


PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-2 Apply formula and functions in spreadsheet

1. Fill in the Blanks:
1.In LibreOffice Calc, text entered into a cell is called a ________.
Answer: Label
2.The result of a mathematical calculation in a cell is displayed as a ________.
Answer: Value
3.A formula in LibreOffice Calc always starts with the ________ symbol.
Answer: =
4.The ________ function is used to find the highest value in a range of cells.
Answer: MAX
5.To count the number of cells in a range that contain numbers, you use the ________ function.
Answer: COUNT

2. True or False:
1.A formula can only perform addition in LibreOffice Calc.
Answer: False
2.Formulas include references and mathematical operators.
Answer: True
3.Labels are always aligned to the left side of the cell by default.
Answer: True
4.The AVERAGE function calculates the total of values in a range divided by the number of cells.
Answer: True
5.The MIN function calculates the total of a range of cells.
Answer: False

How to create a spreadsheet? Class-9-PART-B UNIT-IV-CH-1:


PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-1 Create a Spreadsheet

A. Fill in the blanks:
Q1. A ________ is the intersection of a row and a column.
Ans1. Cell
Q2. In the ________ you can enter or edit data, a formula or a function that will appear in a specific cell.
Ans2. Formula Bar
Q3. In Calc, rows are identified by ________.
Ans3. Numbers
Q4. The ________ displays the location or name of a selected cell.
Ans4. Name Box
Q5. A ________ is a group of cells that runs from the top of the page to the bottom.
Ans5. Column

B. True or False:
Q1. Each rectangle in a workbook is called a cell.
Ans1. True
Q2. Column is a group of cells that runs from the left of the page to the right.
Ans2. False
Q3. Excel files are called workbooks and each workbook holds one or more worksheets.
Ans3. True
Q4. You cannot rename a worksheet.
Ans4. False
Q5. You can switch to any worksheet by clicking on its tab.
Ans5. True

Wednesday, November 12, 2025

Create and use tables- Class-9-PART-B UNIT-III-CH-4:


PART-B Unit-3 Digital Documentation-LibreOffice(2025-26)
Chapter-4 Create and use tables

A. Fill in the Blanks
1._____ is an organised presentation of data separated by a number of rows and columns.
Answer: Table
2.To move from one cell to another cell in the table use the _____ key.
Answer: Tab
3.To delete a row, right-click and from the context menu select Row → _____.
Answer: Delete
4.Two or more adjacent cells can be merged together into one cell using the _____ feature.
Answer: Merge Cells
5.To delete a table, select Table → _____ from the main menu.
Answer: Delete

B. Write True or False
1.You can convert text into tables.
Answer: True
2.Writer also provides an option to change line style to the left of the column.
Answer: True
3.Once the table is created, it is not possible to split the cell in the table as per the requirements.
Answer: False
4.By default, tables have a black border.
Answer: True

What is Format the document? Class-9-PART-B UNIT-III-CH-3:


PART-B Unit-3 Digital Documentation-LibreOffice(2025-26)
Chapter-3 Format the Document

A. Fill in the blanks
1. Numbered list is a ______ list of items with numbers for each item.
Answer: Numbered
2.______ is the default Bullet list command.
Answer: Bullets
3.______ command creates small letters below the line of text. Writing chemical equation is an example of subscript text.
Answer: Subscript
4.______ are predefined formatting options that are used to emphasize text.
Answer: Styles
5.______ text is selected towards right.
Answer: Right-aligned

B. Write True or False
1.The default font is Verdana.
Answer: False
2.You cannot change the colour of the underline.
Answer: False
3.The Character Highlighting Colour command draws a line through the middle of the selected text.
Answer: False
4.Right align aligns text to the right with a ragged left edge.
Answer: True
5.The Background Colour button colours the background behind the selected text.
Answer: True

Monday, November 10, 2025

Small Basic-Looping and Graphics-Class-8-Chapter-8(2025-26):


CBSE SOLUTIONS-2025-26
CLASS-8
CHAPTER-8 Small Basic-Looping and Graphics

A. Multiple Choice Questions (MCQs)
Q1. The default width of Graphics Window is –
(A) 621  (B) 622  (C) 623  (D) 624
Answer: 621
Q2. The default pen colour is –
(A) Red  (B) Blue  (C) Black  (D) Green
Answer: Black
Q3. The default colour of the brush is –
(A) Green  (B) Yellow  (C) Light Blue  (D) None of these
Answer: Light Blue
Q4. There are ___ types of looping statements in Small Basic.
(A) 2  (B) 3  (C) 4  (D) 5
Answer: 3
Q5. The default height of Graphics Window is –
(A) 445  (B) 446  (C) 447  (D) 448
Answer: 446