Page 119 - IT-802_class_12
P. 119
B. Competency-based/Application-based question: Experiential Learning
Ms Kanika has all her students’ subject marks and their totals in a spreadsheet. She wants to find the names of the three
students with the highest marks. Which feature of the spreadsheet should she use?
Lab aCtiVity
Group Practice: [NCERT]
Working on a presentation in LibreOffice impress.
Material required: Computer with LibreOffice Impress, pen, notebook, etc. Subject Enrichment
Procedure:
• Divide the class into groups, depending on the number of computers. Each group will perform the following
activities.
– Save a presentation file by the name ‘Water Cycle Project’
– Close the file
– Open the file again
– Print the presentation
• Make sure that each student in the group gets a chance to perform at least one activity. Other members can watch
and give feedback on what was done correctly and what could be improved upon.
Previous Years’ Questions
1. A ............................ is rectangle shaped box, where row and column meet in a spreadsheet. [2023]
Ans. cell
2. In Open Office Calc ............................ contains the Name Box which shows the location of the selected cell. [2023]
(a) Formula Bar (b) Status Bar
(c) Menu Bar (d) Title Bar
Ans. (a) Formula Bar
3. Write down the main steps to apply filter to a tabular data in Calc. [2023]
Ans. The main steps to apply a filter to tabular data in LibreOffice Calc:
Step 1: Select the cell in the data.
Step 2: Go to “Data” > “Filter.”
Step 3: Click the filter arrow in the header.
Step 4: Set your filtering criteria.
Step 5: Click “OK” to apply the filter.
4. In spreadsheets content of a cell appears in ............................ and the cell. [2022]
(a) Title bar (b) Formula bar
(c) Address box (d) Sheet tab
Ans. (b) Formula bar
5. Select the correct option with respect to spreadsheets: [2022]
(i) A workbook is a spreadsheet that has one or more worksheets.
(ii) A worksheet that has one or more workbooks.
(iii) A cell is a grid of rows and columns.
(iv) By default, data is sorted in ascending order in spreadsheets.
(a) (i) is correct (b) (ii) and (iii) are both correct
(c) (i) and (iv) are both correct (d) (i), (iii) and (iv) are correct
Ans. (c) (i) and (iv) are both correct
ICT Skills-IV 117

