Microsoft Excel
Definition: Electronic Spreadsheet software used for organizing, calculating, and analyzing data.
Extension: .xlsx (2007 onwards), .xls (2003 and earlier).
1. Key Terminology
- Workbook: A collection of worksheets. The file itself.
- Worksheet: A single page or sheet used to enter data.
- Row: Horizontal line of cells. Identified by Numbers (1, 2, 3...).
- Column: Vertical line of cells. Identified by Letters (A, B, C...).
- Cell: Intersection of a Row and Column. Basic unit of data storage.
- Cell Address: Location of a cell (e.g., A1, B5).
- Active Cell: The cell currently selected (Green border).
- Name Box: Displays the address of the active cell.
- Formula Bar: Displays the content or formula of the active cell.
- Range: A block of selected cells (e.g., A1:B10).
2. Data & Functions
Formulas: Always start with an = (Equal to) sign.
Common Functions:
=SUM(A1:A5): Adds values in the range.=AVERAGE(A1:A5): Calculates the average.=MIN(A1:A5): Finds the smallest value.=MAX(A1:A5): Finds the largest value.=COUNT(A1:A5): Counts cells containing numbers.=NOW(): Returns current date and time.=TODAY(): Returns current date only.=LEN(text): Returns the number of characters in a text string.=UPPER(text): Converts text to uppercase.
3. Charts
Graphical representation of data.
- Column Chart: Vertical bars. Good for comparisons.
- Bar Chart: Horizontal bars.
- Pie Chart: Shows parts of a whole (Percentages).
- Line Chart: Shows trends over time.