Page 56 - 2501_KVS_C-6
P. 56
4. Then filter is applied on all fields as shown in fig 3.31. Then few records/rows can
be selected based on a certain criterion.
Fig. 3.31
Aryan selected pasta and pizza from drop down of liked food item cell.
Let us revise what we have learnt:
You can add row and column in a table anywhere. You can also increase or decrease
Ø
row/column width.
The Format Menu is the fifth menu located on Menu Bar. It has options to format
Ø
cells, rows and columns.
We have option to add or delete any row or column or single cell in Sheet Menu.
Ø
In Calc, it is also possible to hide the current sheet on which you are working.
Ø
The Show Sheet option will only be activated after you hide a sheet.
Ø
Data menu has certain options such as sorting in ascending or descending order and
Ø
AutoFilter etc.
Exercise
Something to know
A. State whether these statements are true or false.
1. The Sort option is in Insert menu. _____
2. The AutoFilter option is in Data menu. _____
3. The shortcut key to clear cells is Backspace. _____
4. The rename sheet is in Data Menu. _____
5. Sorting on data can be done in ascending or descending order. _____
54 KVS DELHI REGION 2025

