Office Automation and Data Entry Operations
Office Automation and Data Entry Operations tests practical use of word processing, spreadsheets, presentations, keyboard shortcuts, and accurate data entry. Expect menu-name, shortcut, formula, and validation questions rather than long theory.
Word processing and presentations
- Word uses .docx; mail merge combines a main document with a data source; headers and footers repeat on pages; styles give consistent headings.
- PowerPoint uses .pptx; the slide master controls layout; transitions occur between slides, while animations apply to objects.
Spreadsheets
- A formula begins with =; relative reference A1 changes when copied; absolute $A$1 stays fixed; mixed $A1 or A$1 locks one part.
- SUM adds, AVERAGE averages, COUNT counts numeric cells, COUNTA counts non-empty cells; IF makes decisions; VLOOKUP searches the first column.
- Sorting rearranges rows; filtering hides rows; charts reference ranges.
Data entry
- Accuracy beats speed; use validation, verify OCR output, and back up files; 10-key practice improves numeric entry; know Ctrl+C, Ctrl+V, Ctrl+X, Ctrl+Z, Ctrl+Y, and Ctrl+S.
Worked example
In C1 you enter =A1+$B$1 and copy it to C2. C2 becomes =A2+$B$1. A1 is relative, so its row increases by one; $B$1 is absolute, so it stays fixed. If you had used =$A$1+$B$1, both references would stay on row 1. Reasoning: the dollar sign locks the column, row, or both before copying.
Traps
COUNT ignores text while COUNTA includes it; dates are stored as serial numbers, not text; a transition is not an animation; mail merge needs a data source; Ctrl+S saves, it does not print.