Rows Columns and Cells
Key Concepts
Cells: The basic building blocks in Excel where data is stored. Each individual box in a spreadsheet is a cell.
Example: Highlighted cell represents a current focus.
Rows: Horizontal collections of cells. Each row is identified by a number.
Example: Rows mentioned include Row 1, Row 14, Row 26.
Columns: Vertical collections of cells. Each column is identified by a letter.
Example: Column A, Column B, Column C, and so forth.
Basic Functionality
Copying and Pasting:
To copy a cell's content, use Ctrl + C and to paste, use Ctrl + V (e.g., from cell A1 to D1).
An alternate method is by right-clicking to select copy and paste.
Navigating the Spreadsheet:
Use arrow keys to move up, down, left, right.
To select entire columns or rows, use Shift + Command/Control plus the arrow keys.
Basic Data Entry and Formulas
Entering Formulas:
Formulas start with an equal sign
=followed by cell references and operations (e.g.,=E2 + F2).Example calculation for total salary:
June salary in cell E2 = 10,000
July salary in cell F2 = 12,000
Total in G2 =
=E2 + F2= 22,000.
Dragging Formulas:
Dragging down a formula in Excel adjusts cell references automatically.
E.g., dragging
=E2 + F2down updates to=E3 + F3, etc.
Additional Features
Data Types:
Different types of data can be stored in cells, including text, integers, and floating-point numbers.
Searching Data:
Use Ctrl + F (or Command + F on Mac) to find specific data in large datasets.
Resizing Rows and Columns:
Dragging the edge of a row or column allows resizing.
Formatting Cells:
Use formatting options to change font color, background color, and cell aesthetics.
Copy formatting from one cell to another by using the format painter tool.