Explanation

Excel provides tools to quickly improve the appearance and structure of a worksheet.

Styles

Conditional Formatting: Automatically applies formatting when specified conditions are met.

Example: Highlight marks below 40.

Cell Styles: Applies predefined combinations of formatting.

Format as Table: Converts a range into an Excel Table with built-in formatting and useful data features.

Cells

The Cells group provides tools to:

  • Insert cells
  • Delete cells
  • Adjust Row Height
  • Adjust Column Width
  • Hide Rows or Columns
  • Unhide Rows or Columns

Example

If a student’s name is not fully visible, increase the Column Width.

Practice

Create a student table and:

  1. Adjust column widths.
  2. Change row height.
  3. Apply a cell style.
  4. Convert the data into a table.
  5. Use Conditional Formatting to highlight marks below 40.
PreviousNext