Page 56 - 2501_KVS_C-6

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