Excel Worksheet Creation - Quick Reference Notes (TVE ICF Module 3)

A workbook is the primary file type in Excel, holding one or more worksheets and global data.
New workbooks can be created instantly with Ctrl + N or via File > New for more options including templates.

Workbook: The entire Excel file, containing one or more worksheets.
Worksheet: A single grid within a workbook where data is entered.
Cell: The intersection of a column and a row; the basic unit for data entry.
Active Cell: The currently selected cell where data is entered.
Cell reference: The unique address of a cell (e.g., A1), combining its column letter and row number.
Column heading: Alphabetical labels (A, B, C…) for vertical columns. Excel has $16,384$ columns (up to 'XFD').
Row heading: Numerical labels (1, 2, 3…) for horizontal rows. Excel has $1,048,576$ rows.
Formula Bar: Displays and allows editing of data or formulas in the active cell.
Name Box: Shows the active cell's reference and can be used for navigation.
Sheet tabs: Enable switching between worksheets within a workbook, located at the bottom.

Entering data: Select a cell, type data, then press Enter (moves down), Tab (moves right), or an arrow key to commit.
Editing data: Double-click the cell, use the F2 key, or click within the Formula Bar to modify content. Press Enter to commit changes.
Data Types: Excel supports Text, Numbers, Dates and Times, and Formulas (always start with $=$ ).

Active Cell: The cell where input/action takes place.
Cell reference: Unique address (e.g., A1) for formulas.
New workbook/worksheets: Use Ctrl + N for new workbooks; + button on sheet tabs for new sheets.
Sequential numbers: Use the 'Fill Handle' (small square at cell corner) to quickly generate series (numbers, dates, days).
Saving: Regularly save (Ctrl + S or File > Save/Save As) to prevent data loss.

Three main creation methods for a new workbook: File > New, Quick Access Toolbar New button, Ctrl + N.
A cell’s location is defined by its column letter and row number (e.g., A1).
Excel’s grid supports $16,384$ columns (from A to XFD) and $1,048,576$ rows.
Column headings are letters; row headings are numbers.
To insert or modify data: click a cell, type, then Enter or use the F2 key/Formula Bar for editing.

A workbook is the primary container for Excel data, holding one or more worksheets.
A cell is the fundamental unit for data entry; the active cell is the one currently selected for input.
Data entry and editing are straightforward: select, type, and commit using methods like Enter or the Formula Bar.
New workbooks can be created quickly via multiple methods, and data sequences can be generated efficiently with the Fill Series feature.