IPA IP 2024 Question 58

Topic: Software

A question IPA Japan published in 令和6年度 ITパスポート試験 公開問題 問58, translated into English. ITPEC is based on the same exams.

Same question on ITPEC: Apr 2025 Q22

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 the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.