ITPEC IP April 2025 Question 22
In document creation software, spreadsheet software, and other such software, which of the following is a function that predefines and executes a series of operation procedures?
Explanation
Macro — a recorded or written series of operations that the application then runs in one step.
Office software such as word processors and spreadsheets lets the user record a sequence of operations (select a range, format it, sort it, print) or write it in the application's macro language. Running the macro repeats the whole procedure automatically, saving time and avoiding slips in routine work.
Answer (d)
Why not others:
- •(a) Autocomplete — suggests the rest of a word or entry from what was typed before; it helps input, it does not run a procedure
- •(b) Source code — the text of a program written in a programming language, not a function of office software
- •(c) Plug and play — the OS detects a newly connected device and installs its driver automatically; it concerns hardware, not operation procedures
Key rule: Macros can run any operation automatically when a document is opened, which is why macro viruses spread through attached documents and office software disables macros from unknown sources by default.
Software · AI-written, may contain errors
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.