PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-1 Create a Spreadsheet
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
C. SHORT ANSWER QUESTIONS:
Q1. What is a spreadsheet software? Give two examples.
Ans1.
Spreadsheet software is a computer application used to store, organize, calculate, and analyze data in the form of rows and columns.
It helps in performing mathematical calculations, preparing charts, maintaining records, and processing large amounts of information easily.
Examples: Microsoft Excel, Google Sheets, LibreOffice Calc.
Q2. Define a cell, row and column.
Ans2.
Cell: A cell is the basic unit of a spreadsheet. It is formed at the intersection of a row and a column, and it is the place where data is entered.
Row: A row is a horizontal line of cells in a worksheet. Rows are identified using numbers such as 1, 2, 3, etc.
Column: A column is a vertical line of cells in a worksheet. Columns are labeled with letters such as A, B, C, and so on.
Q3. How can you save a file in another file format?
Ans3.
- To save a file in a different format, you need to open the File menu and select Save As.
- A dialog box will appear where you can choose the desired file format from the list, such as .xlsx, .ods, .csv or .pdf.
- After selecting the format, click Save. The file will be saved in the new format without affecting the original file.
Q4. How can you rearrange the worksheets in a workbook?
Ans4.
- Worksheets can be rearranged by clicking on the sheet tab and dragging it to a new position.
- You can move a sheet to the left or right depending on where you want it to appear.
- Rearranging sheets helps in organizing data in a more meaningful order inside the workbook.
Q5. How can you insert or delete a worksheet?
Ans5.
- To insert a worksheet: Right-click an existing sheet tab and choose Insert Sheet or click the + (New Sheet) button.
- To delete a worksheet: Right-click on the sheet you want to remove and select Delete Sheet.
- These options allow you to add or remove sheets based on your requirements.
D. LONG ANSWER QUESTIONS:
Q1. State the difference between a worksheet and a workbook.
Ans1.
A worksheet and a workbook are two fundamental components of spreadsheet software, but they serve different purposes.
A worksheet is a single page consisting of rows and columns. It is the workspace where the user enters, edits, and processes data. Each worksheet allows calculations, creating charts, and performing operations with formulas.
A workbook, on the other hand, is the entire spreadsheet file that contains one or more worksheets. A workbook acts as a container that holds multiple worksheets under one file name. This helps users keep related data together, but separated into different sheets such as Sheet1, Sheet2, and Sheet3.
In simple terms, a workbook is like a book, and worksheets are the pages inside that book.
Q2. What is a formula? List its items.
Ans2.
A formula in a spreadsheet is an expression used to perform calculations automatically. Formulas can be used for addition, subtraction, multiplication, division, percentages, averages, and many other operations. Formulas help the user calculate results quickly and avoid manual mistakes.
Every formula must begin with an equal sign (=). This tells the spreadsheet that the text entered should be treated as a calculation and not as normal data.
- Items of a formula include:
- Equal Sign (=): Required at the beginning of every formula.
- Cell References: Addresses of cells (e.g., A1, B2) whose values will be used in the formula.
- Operators: Mathematical symbols such as + (add), – (subtract), * (multiply), / (divide).
- Functions: Built-in formulas like SUM, AVERAGE, MAX, MIN, etc., used for advanced calculations.
Q3. Define address.
Ans3.
A cell address is the unique name of a cell in a worksheet.
It is formed by combining the column letter and the row number where the cell is located.
For example, the address B4 refers to the cell present in column B and row 4.
Cell addresses are extremely important because they help identify the exact location of data in a worksheet. They are also used in formulas and functions to refer to specific values.
Q4. What will happen if you close the file without saving it?
Ans4.
- If you close a file without saving it, any changes you made will be permanently lost.
- Spreadsheet software stores changes only when the user saves the file.
- If the file is closed before saving, the program usually shows a warning message asking whether you want to save the changes.
- If you choose Don’t Save, or accidentally close without saving, the data will return to the last saved version, and all new work will disappear.
SOME OTHER LINKS YOU MAY LIKE:
No comments:
Post a Comment