Question

Rohan has created 12 worksheets, in a single workbook, for each
month for the sale of medicines. To check the sale of entire year,
he needs to prepare a single worksheet. Which out of the following
feature will be helpful for him:
(a) Goal Seek
(b) Consolidate
(c) Solver
(d) Macro
​

Answer 1

Answer:

d) Macro

Explanation:

Answer 2

Concept introduction:

Other objects, like the Worksheet object, are contained in the Workbook object. Other objects, like the Range object, are contained in the Worksheet object. The chapter on creating macros provides an example of how to execute code by selecting a command button.

Explanation:

Given that, Rohan has created $12$ worksheets, in a single workbook, for each month for the sale of medicines.

We have to find, Which out of the given feature will be helpful for him.

According to the question,

We can record a macro to automate any repetitive Microsoft Excel activities you may have. A macro is a single activity or a group of related activities that may be executed repeatedly. We capture our mouse movements and keystrokes when you develop a macro. VBA is a programming language used to construct macros, whereas macros are computer instructions that operate in the Excel environment to carry out common operations automatically.

Final Answer:

(d) Macro

#SPJ3