NSHM College of Management and Technology
MTSC Exam
BBA
MIC402C [2025]
Group A [10 marks]
1. ________ is the graphical representation of information and data.
2. ____________ is used to describe the process involved in figuring out your input
value based on an already known output value
3. In the context of optimization solvers, a _____________ is a restriction or
condition that a solution to the problem must satisfy, defining the feasible region
within which the solver searches for the optimal solution
4. _____________ is a powerful tool for summarizing and analyzing data, allowing
you to reorganize, aggregate, and view data in different ways by dragging and
dropping fields into different areas
5. ___________ is the process of systematically collecting, cleaning, transforming,
modeling and interpreting data to extract meaningful insights and make
informed decisions.
6. The __________ function is used to retrieve a value from a vertical lookup table
based on a matching key in the first column.
7. In Excel, __________ cell referencing keeps the reference fixed even when the
formula is copied to other cells.
8. The combination of MATCH and INDEX functions can be used as an alternative
to __________ for more flexible lookups.
9. Inserting a new column shifts the existing columns to the __________ direction.
10. The __________ function can be used to calculate the internal rate of return for
a series of cash flows.
Group B (5 marks each = 15 marks) Any 3
1. Discuss the usage of What-if-Analysis ?
2. Analyze the role of Solver in MS-Excel?
3. What are the steps and tools used in data visualization?
4. Differentiate between absolute, relative, and mixed cell referencing with the
help of examples and explain their impact when formulas are copied across
multiple cells.
5. Explain how nested VLOOKUP with MATCH is more advantageous than
standard VLOOKUP. Provide a scenario where this combination improves data
retrieval accuracy.
Group C (15 marks) any 3
1. a) What-if analysis is a process of exploring the potential outcomes of
changing variables in a model to understand how those changes might
affect the results - Discuss
b) State and explain the use of Goal seek (10+5)
2. Basic Excel functions are invaluable for data analysis, enabling tasks
like summarizing data, performing calculations, and extracting insights -
Discuss (15)
3. Short Notes: (Any 3) [5 * 3 ]
a. Solver
b. Pivot Table
c. Pie Chart
d. Dispersion Calculation (using excel)
4. (a) Describe the steps and logical functions needed to create a complex
conditional expression using IF, AND, OR, and NOT that calculates a
student’s grade based on multiple criteria. [7 marks]
(b) Implement the logic in Excel using a nested formula and explain each
part in detail.
[8 marks]
5. (a) Explain the use of VLOOKUP to consolidate data from multiple
worksheets. How does referencing across sheets work? [5 marks]
(b) Design a scenario with three worksheets (Sales_Q1, Sales_Q2,
Sales_Q3) and show how you would build a master summary sheet using
VLOOKUP and table references to retrieve total sales for each product. [10
marks]
6. (a) Describe in detail how text functions (such as LEFT, RIGHT, MID, LEN,
CONCAT, TEXTJOIN) can be used to clean and format imported textual data
for analysis. [8 marks]
(b) Given a dataset containing employee names, IDs, and joining dates in
an unstructured format, write Excel formulas to standardize names,
extract ID numbers, and format the dates. [7 marks]
