Page 287 - TP_IT_V1.0_C10_flipbpookl
P. 287
7. Which of the following menu contains the Consolidate option?
a. View b. Tools
c. Data d. Insert
8. A is the method used to refer to a cell or a range of cells within a spreadsheet.
a. Macro b. Cell reference
c. Subtotal d. Solver
9. Which of the following is the correct method to make a cell reference using another workbook?
a. =’file.ods’ #sheet1.A3 b. =’file.ods’ @sheet1.A3
c. =’file.ods’ &sheet1.A3 d. =’file.ods’ +sheet1.A3
10. Which of the following options is used to delete a worksheet?
a. Delete Sheet b. Remove Sheet
c. Exit Sheet d. Rename Sheet
B. Fill in the blanks.
1. is the default extension of LibreOffice Calc.
2. At the bottom of each worksheet window is a small tab that indicates the of the worksheets in the
workbook. [CBSE Handbook]
3. When you open a new worksheet, the default number of sheet(s) is/are .
4. Formulas in a spreadsheet must begin with a sign.
5. option creates a hyperlink to connect to a web address.
6. refers to reaching to the linked file by writing the complete address starting from the root directory.
7. A refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you
want formula to calculate. [CBSE Handbook]
8. Data found in the original file but not in the edited version is marked as .
C. State whether these statements are true or false.
1. The Hyperlink icon is present in the Drawing toolbar.
2. Comments in spreadsheets serve the purpose of providing additional information, context, or
explanations about specific data or formulas within the spreadsheet.
3. Linking a section of the same worksheet cannot be done.
4. Comments once created can easily be edited.
5. Changes made in a shared document can easily be accepted and rejected.
6. Spreadsheet software allows the user to share the workbook and place it in the network location
where several users can access.
7. We can rename a worksheet by using the Rename Sheet dialog box.
SECTION B (Subjective Type Questions)
A. Short answer type questions.
1. Give the steps to rename a sheet.
2. Differentiate between relative and absolute hyperlink.
3. Write the steps to show or hide comments in LibreOffice Calc.
4. Write the steps to enable the Macro Recording feature.
5. Give the steps to compare two worksheets?
6. How can we record a macro? [CBSE Handbook]
Electronic Spreadsheet (Advanced) using LibreOffice Calc 285

