Question

Which feature in a spreadsheet can store a series of commands?

a) Goal Seek
b) Subtotals
c) Macros
d) Charts​

Answer 1

Answer:

charts is the correct answer

Answer 2

Option c) Macros

• A macro is a feature of Excel. It refers to a set of instructions and operations that are kept in a Microsoft Visual Basic module and can be executed anytime the task they are intended for is needed.
• You can record a macro to automate actions in Microsoft Excel that you perform frequently. A macro is an action or series of acts that can be repeated endlessly. You are capturing your keystrokes and mouse clicks when you construct a macro.
• An action or collection of actions can be recorded, named, stored, and executed as many times as necessary and whenever desired using an Excel macro.
• We can automate repetitive processes related to data manipulation and reporting that need to be done repeatedly by using macros.
• By creating and using macros in Word, you may automate routine operations.
• A macro is a collection of instructions and commands that you can use as a single command to carry out a task automatically. Combine the procedures into a macro to save time on routine chores.

#SPJ3