Page 148 - IT_V1.0_Class10
P. 148
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activity and tick the circle.
A school conducts three tests in a year. The marks obtained by students in each test are stored
in separate sheets of a spreadsheet. Create a sheet named “Overall Performance” to calculate
the average marks obtained by each student in all three tests.
Notes
If you are continually working with the same range of data, then you can create a range and give it a
name. This will make the process easy and fast. The steps to define range are:
Data > Define Range
GROUP AND OUTLINE
Group and Outline in Calc allows you to organise selected data by creating an outline, it lets you group rows
or columns together. This feature enables you to collapse (-) to hide data or expand (+) it with a single click.
Step 1: Select the data you want to group.
Step 2: Click on Data menu.
Step 3: Select Group and Outline option. A drop-down menu appears.
Step 4: Click on Group option. The Group dialog box appears.
Step 5: Select Rows radio button to group by rows or Columns radio button to group by columns.
Step 6: Click OK button to group the data.
2
1
5
3 4 6
SUBTOTALS
LibreOffice Calc offers the Subtotals tool to create subtotals for data arranged in labelled columns. It also
groups subtotals by category and sorts them automatically, thereby eliminating the need to apply filter
categories manually.
146 Information Technology Play (Ver 1.0)-X

