EXCEL · DATA SKILLS
Cells and ranges
Browse Excel lessons
- Excel for basic data analysis
- Cells and ranges
- Columns and readable headings
- Enter and edit cells
- Share files and embed objects
- Fill a series
- Save a practice copy
- Prepare data for analysis
- Dates and number formats
- Variables and score definitions
- Enter and check practice data
- Insert and delete rows
- AutoSum and totals
- Copy formulas with relative references
- Calculate the mean
- Calculate standard deviation
- Excel references and next steps
A workbook is an Excel file; each worksheet contains rows and columns. Column letters and row numbers identify a cell: B5 is column B, row 5. A range such as B5:B9 includes five cells.
- Open the practice workbook and select Sheet1.
- Select B5. Look at its address in the Name Box and its value in the formula bar.
- Select B5:B9 by dragging, or type B5:B9 into the Name Box and press Enter.
The practice workbook keeps labels in column A and scores in columns B–D.
Reference: Microsoft Support. Menu names may vary by platform and update.