Page 67 - Artificial Intellegence_v2.0_Class_12
P. 67
Advanced Features in Calc
There are various advanced features of Calc. Let us learn about some of them in detail.
S or ting Data
Calc spreadsheet software helps people to organise and process data by the use of columns and rows with formulas and
some cool features. Let us understand how to sort data—arrange data alphabetically or in ascending/descending order.
onsider the follo ing spreadsheet
In order to see the student obtaining the highest total, e need to sort the data in descending order of otal . ollo
the given steps
tep Select the data to be sorted.
tep Click on Data Sort on the menu bar. The Sort dialog box will open.
tep elect ort criteria tab and select otal from the drop do n list.
tep Then, tick on the checkbox selecting descending order.
tep lick on the O button. his ill arrange the data in descending order of otal as sho n
IC T S ki l l s- IV 65

