Excel Test

Core Spreadsheet Structure

  • Columns are vertical and identified by Letters (A, B, C).

  • Rows are horizontal and identified by Numbers (1, 2, 3).

  • A Cell is the intersection of a row and a column.

  • The Active Cell is the one currently selected, outlined by a thick border.

  • A Range is a group of cells, written with a colon (e.g., A1:C5 means all cells from A1 to C5).

  • Worksheets are the individual pages of a file; the Workbook is the entire file itself.

Entering & Managing Data

  • Labels are text entries (names, titles) that Excel does not use for calculations.

  • Values are numbers that can be used in formulas.

  • The Formula Bar shows the "under the hood" data or formula of the selected cell.

  • Cell Alignment options include Left, Center, Right, and Merge & Center (combining multiple cells into one large cell).

  • Number Formatting allows you to change how values appear (Currency, Percentage, Date, or Decimal places) without changing the actual number.

  • AutoFill (using the Fill Handle) quickly copies patterns, dates, or formulas into neighboring cells.

Formulas & Calculations

  • Equal Sign (=): The mandatory first character of any calculation.

  • Cell References: Using a cell's name (like B2) in a formula instead of typing the number. This allows the answer to update automatically if the data in B2 changes.

  • Operator Order: Excel follows PEMDAS (Parentheses, Exponents, Multiplication/Division, Addition/Subtraction).

  • SUM Function: Efficiently adds a long list of numbers.

  • AVERAGE Function: Calculates the arithmetic mean of a range.

  • MIN and MAX: Identify the lowest and highest values in a set of data.

  • COUNT: Tells you how many cells in a range contain numbers.

Charts & Visuals

  • Column/Bar Charts: Best for comparing different categories (e.g., sales of different fruits).

  • Line Charts: Best for showing data that changes over time.

  • Pie Charts: Used to show "parts of a whole" or percentages of a total.

  • Legend: The key that explains what the different colors or patterns on a chart represent.

Key Shortcuts & Formatting Tricks

  • Ctrl + Z: Undo the last action.

  • Ctrl + ` (Tilde): Shows all formulas on the entire sheet at once.

  • ##### Error: This happens when a column is too narrow to display the number inside; you must widen the column to fix it.

  • #DIV/0! Error: Occurs when a formula tries to divide a number by zero.