DAY 2: TUESDAY – MICROSOFT EXCEL

2. Excel Worksheet Basics

 Rows, Columns, and Cells

• Rows run horizontally and are numbered

• Columns run vertically and are labeled with letters

• A cell is the intersection of a row and a column

 Entering and Editing Data

Data is entered by clicking a cell and typing.
Editing can be done by double-clicking a cell or using the formula bar.

Basic Calculations in Excel

 Formulas and Functions

Formulas start with an equals sign (=).
Examples:

• =A1+A2 (addition)

• =SUM(A1:A5) (total)

Functions make calculations easier and faster.

 Creating Simple Charts

Charts are used to present data visually.
Steps:

• Select data

• Click Insert → Chart

• Choose chart type (bar, pie, line)