MBA201-18
BUSINESS ANALYTICS FOR DECISION MAKING
QUESTION BANK
UNIT- V
Bloom Bloom Level
[Link] Question
Level Name
Apply the steps to record and run a macro for automating
1 III Apply
report formatting in Excel.
Apply a simple VBA procedure to display a message after
2 III Apply
completing an automated task.
Apply VBA variables to store and calculate total sales in an
3 III Apply
automated Excel report.
Apply conditional logic using VBA to classify employee or
4 III Apply
sales performance.
Apply a looping statement in VBA to automate repetitive
5 III Apply
data entry or formatting tasks.
Apply pivot tables to summarize large datasets for
6 III Apply
managerial reporting.
Apply slicers to create an interactive dashboard for sales or
7 III Apply
performance analysis.
Apply data consolidation techniques to combine data from
8 III Apply
multiple worksheets or files.
Apply error-handling functions to improve the reliability of
9 III Apply
dashboards.
10 Apply basic dashboard design principles to present KPIs III Apply
Bloom Bloom Level
[Link] Question
Level Name
effectively.
Analyze the difference between recorded macros and
11 IV Analyze
VBA-based automation in Excel.
Analyze how VBA automation improves efficiency and
12 IV Analyze
accuracy in business reporting.
Analyze the role of pivot tables in creating dynamic
13 IV Analyze
dashboards.
Analyze the impact of slicers and filters on dashboard
14 IV Analyze
usability and interpretation.
Analyze challenges involved in consolidating data from
15 IV Analyze
multiple Excel sources.
Analyze common errors that occur while recording macros
16 IV Analyze
and their impact on automation.
Analyze limitations of Excel dashboards in large-scale
17 IV Analyze
business environments.
Analyze how automation helps in reducing manual errors
18 IV Analyze
in business analytics.
Analyze the importance of separating raw data sheets and
19 IV Analyze
dashboard sheets in Excel.
Analyze security concerns associated with the use of
20 IV Analyze
macros and VBA in organizations.
Evaluate the effectiveness of VBA-based automation in
21 V Evaluate
improving business productivity.
Bloom Bloom Level
[Link] Question
Level Name
Evaluate the usefulness of dynamic dashboards as decision-
22 V Evaluate
support tools for managers.
Evaluate the advantages and risks of using macros in
23 V Evaluate
organizational reporting systems.
Evaluate best practices in dashboard design for effective
24 V Evaluate
managerial decision-making.
Evaluate the role of automation in supporting data-driven
25 V Evaluate
business decisions.
Evaluate the suitability of Excel dashboards compared to
26 V Evaluate
BI tools such as Power BI.
Evaluate control measures required to manage VBA
27 V Evaluate
security risks in organizations.
Evaluate how data consolidation improves enterprise-level
28 V Evaluate
reporting and analysis.
Evaluate the long-term impact of Excel automation on
29 V Evaluate
managerial efficiency.
Evaluate the role of Excel automation and dashboards in
30 V Evaluate
modern business analytics.