Computer Knowledge · JKSSB Accounts Assistant (Finance) — November 2026 · Last updated:

View the full solved paper: JKSSB Accounts Assistant (Finance) — November 2026

Which language is used to create macros in Excel?

  1. A. Java
  2. B. C++
  3. C. Python
  4. D. Visual Basic (Correct answer)

Correct Answer

Option D — Visual Basic

Detailed Solution & Explanation

In Microsoft Excel (and the Microsoft Office suite), macros and custom user-defined functions are programmed using Visual Basic for Applications (VBA), an event-driven dialect of Visual Basic (Option D) integrated into the Office VBE (Visual Basic Editor, accessed via `Alt + F11`). When a user records or writes an Excel macro, Excel generates and executes Visual Basic (VBA) code stored in `.xlsm` or `.xlsb` workbooks.

Topics covered: MS Office (Word, Excel, PowerPoint & Access)