Page 57 - 2501_KVS_C-6

B. Match the following:
1. Format cells a. Sort

2. Insert cells b. Ctrl+-
3. Clear cells c. Ctrl+1

4. Delete cells d. Backspace

5. Data e. Ctrl++

C. Fill in the blanks.
1. The _____________ ascending feature is used to arrange data in ascending order

2. The _____________ feature is used select rows based on a specific criteria.
3. The _____________ feature is used to display hidden sheet.

4. The insert rows option is present in _____________ menu.

5. The merge cells option is present in _____________ menu.

D. Answer the following questions:

1. A wants to see only specific rows based on a condition in the spreadsheet. Which
feature of LibreOffice Calc is required to do this task?
2. B wants to sort the data in descending order of marks so that first three toppers
come on top in a spreadsheet. Which feature of LibreOffice Calc will be used by him?

3. A wants to combine cells of data given in a spreadsheet. Which feature of LibreOffice
Calc will be used by her to do it?

4. B wants to insert a new sheet in the end of the existing spreadsheet. Write the
steps to do it?
5. Name the menu which has the option to change row height and column width.

LibreOffice Calc 55