Practical's 1 : Formatting cells in Excel

 Formatting cells in Excel allows you to control the appearance of your data, making it easier to read and understand. Here are some common formatting options:

1. Number formatting:

    - General

    - Number

    - Currency

    - Accounting

    - Date

    - Time

    - Percentage

2. Alignment:

    - Left

    - Center

    - Right

    - Justify

    - Top

    - Middle

    - Bottom

3. Font:

    - Font style (e.g., Arial, Calibri)

    - Font size

    - Bold

    - Italic

    - Underline

4. Border and shading:

    - Border style (e.g., solid, dashed)

    - Border color

    - Fill color

5. Protection:

    - Lock cells

    - Hide formulas

6. Conditional formatting:

    - Highlight cells based on conditions (e.g., values, formulas)

    - Use icons, colors, or data bars to visualize data

To format cells in Excel:

1. Select the cells you want to format.

2. Right-click and choose "Format cells" or use the Home tab in the Excel ribbon.

3. Select the desired formatting options.

4. Click "OK" to apply the changes.

Remember to use formatting consistently to make your spreadsheet easy to read and understand.