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)