Faculty of Business Management and Commerce, Education & Humanities
School of Business Management, Commerce, Law, Liberal Arts & Social Sciences
Assignment Questions
Academic Year: 2025-26
Program: F Y BBA, BCOM, BBA LLB, MA Maximum Marks:50
Course Code: 230VBCB10_01 Course Name: Advanced Excel
Year: First Semester: I
Q. No. Question Statement Due Date
a) Explain the difference between basic functions (SUM, 30/09/2025
AVERAGE, COUNT, MAX/MIN) and conditional
Q.1
functions (SUMIF, COUNTIF, AVERAGEIF).
b) List Down the Shortcut keys used in MS Excel. 30/09/2025
a) Explain the difference between: Relative, Absolute, and 08/10/2025
Q.2 Mixed cell references with example
b) List Down Functions and Formulas in Excel. 08/10/2025
a) Discuss how Charts (bar, pie, line, slicers) enhance 15/10/2025
decision-making.
Q.3
b) Give a real-life example where Conditional 15/10/2025
Formatting can be applied for decision-making.
a) Explain sorting types and give real-world examples of 3/11/2025
business use of sorting.
b) 1. Which of the following would NOT be found under 3/11/2025
the Formulas tab in Excel?
a. NPV
b. Goal Seek
c. Formula Auditing
d. Name Manager
2. Which of the following steps is required to apply a
filter to a financial dataset in Excel?
a. Press Ctrl + D
b. Click Insert > Filter
c. Go to the Data tab and click Filter
d. Use the Home tab > Format Cells
Q.4 3. To add a new line item in the middle of an income
statement without disrupting formulas. What’s the
safest method?
a. Select a cell and press Enter
b. Overwrite an existing row.
c. Use right-click > Insert Row
d. Cut and paste the section elsewhere
4. What function would you use to find the highest
revenue in a dataset?
a. MIN()
b. COUNT()
c. MAX()
d. AVERAGE()
5. To apply filters to a dataset, which keyboard shortcut
would you use?
a. Ctrl + L
b. Ctrl + Shift + L
c. Ctrl + F
d. Ctrl + T
a) Explain the use of the following text functions with 17/11/2025
examples: MID, LEFT, RIGHT, TRIM, PROPER,
Q.5 SUBSTITUTE
b) Differentiate between VLOOKUP, HLOOKUP, INDEX, 17/11/2025
MATCH, OFFSET, and INDIRECT functions.
a) Prepare a short case study: How a company can use 24/11/2025
Excel to prepare a sales forecast?
Q.6
b) Differentiate between Charts and Sparklines with 24/11/2025
examples.
Dr. Namita Mane
Course Teacher