Basic Computer and Data Entry Skills
What the domain tests
Basic Computer and Data Entry Skills covers accurate keyboard entry, file and folder organization, spreadsheet basics, data validation, and safe handling of information. The exam focuses on producing clean, retrievable data rather than advanced programming.
Core rules
- Enter data in the correct field and format; preserve leading zeros by formatting the cell as text when an identifier requires them.
- Use copy, paste, undo, and save deliberately; confirm the active cell before typing.
- In spreadsheets, a range such as B2:B10 includes both endpoints. =SUM(B2:B10) adds the range; =B2+B10 adds only two cells.
- Check totals against an independent estimate or a second calculation.
- Keep file names descriptive and consistent; store records in the approved location.
- Follow privacy rules: lock the screen, share only permitted files, and avoid personal email for records.
Worked example
A spreadsheet has quantities in B2:B10 and unit prices in C2:C10. To total the line amounts, enter =SUMPRODUCT(B2:B10,C2:C10). Reasoning: SUMPRODUCT multiplies each quantity by its matching price and sums the results, avoiding ten separate multiplication formulas and reducing copy errors.
Traps
Assuming autosave has stored a file; typing over a formula instead of a value; treating “00123” as the number 123; confusing a range with a single cell; and emailing a file without checking whether it contains confidential data.