Class 6th computer chapter 5

A. Tick the correct option

1. b. Workbook
2. a. Home
3. c. Year
4. a. Delete
5. b. Textual data

B. Fill in the blanks (Help Box: Orientation, Sorting, Merge and Center, Conditional formatting, Workbook)

1. Merge and Center
2. Sorting
3. Workbook
4. Orientation
5. Conditional formatting

C. Write T for true and F for false

1. F
2. F
3. T
4. T
5. T

D. Match the following

1. New Sheet button → b. Helps to insert a new worksheet in the file.
2. Clear button → d. Helps to remove formatting from the selected cells.
3. Top-align button → a. Helps to align the text on the top of the cell.
4. Alignment Group → e. Helps to align the text.
5. Insert button → c. Helps to insert cells, rows, columns and sheets.

E. Short answers

1. Workbook: The file used by Excel that contains one or more worksheets.
   Worksheet: A single sheet (grid of rows and columns) inside a workbook where you enter data.
2. Two orientations: Portrait and Landscape.
3. How to sort data in a worksheet: Select the range (or a column), then use Home → Sort & Filter → Sort A to Z / Sort Z to A (or Data → Sort) to arrange data alphabetically or reverse.
4. Conditional formatting: A feature that highlights or formats cells automatically when they meet a specified condition (for example cells > 60%).
5. Insert a new row/column: Right-click on the row number or column letter where you want the new one and choose Insert, or use Home → Insert → Insert Sheet Rows / Insert Sheet Columns.

F. Application-based answers

1. Use Conditional Formatting (set rule: marks > 60%).
2. Use Number Format / Format Cells (Home → Number group or right-click → Format Cells → Number) to format numbers.
3. Use Sort (Data → Sort or Home → Sort & Filter → Sort A to Z) to display customer data in alphabetical order.

If you want these written neatly for pasting into the workbook or printed, say so and I’ll format them for you.