EXCEL · DATA SKILLS
Enter and check practice data
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
Confirm that the workbook contains these values in A5:D9:
| Case | Anxiety | Depression | Anger |
|---|---|---|---|
| 1 | 5 | 3 | 5 |
| 2 | 4 | 4 | 3 |
| 3 | 5 | 2 | 4 |
| 4 | 2 | 5 | 1 |
| 5 | 1 | 2 | 5 |
Optional practice: select B5:D9 and use Data → Data Validation → Whole number → between 1 and 5. Verify pasted and imported values as well; validation is an entry aid, not a complete data-quality check. Leave missing data blank rather than entering zero.
Reference: Microsoft Support. Menu names may vary by platform and update.