BBASemester 22024-25It Application – IiBBA206
View PDFDownload

It Application – Ii (BBA206) - AKTU Question Paper 2024-25

BBA · Semester 2 · Free PDF Download

This is the official AKTU It Application – Ii Previous Year Question Paper for BBA Semester 2, academic session 2024-25. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:BBA
Semester:Semester 2
Session:2024-25
University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

It Application – Ii (BBA206) — complete question paper · 70 marks · 3 Hours

Section AAttempt all q u e s t i o n s i n b r i e f . 0 2 x 7 = 1 4
  • a
    How does the COUNTIF function work? Give a use case
  • b
    Explain the use of the AVERAGE function
  • c
    What is the use of the Goal Seek tool in Excel?
  • d
    Mention the importance of data consolidation
  • e
    What is a Pivot Table? Mention any two uses
  • f
    Mention precautions while using social media
  • g
    Explain the role of AI in business
Section BAttempt any three o f t h e f o l l o w i n g : 0 7 x 3 = 2 1
  • a
    Explain various mathematical functions in MS Excel with appropriate examples
  • b
    Discuss the role of Excel in statistical data analysis. Mention tools for regression, correlation, and moving averages
  • c
    Describe the role of dashboards in decision-making. Mention key components of a business dashboard
  • d
    Write a detailed note on cyber threats and their prevention in the context of social communication
  • e
    Discuss the role of IT in digital marketing, artificial intelli gence, and virtual reality
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 0 7 x 1 = 0 7
  • a
    Write a detailed note on logical operations in Excel. How can t hey be used for decision-making?
  • b
    Create a monthly expense tracker in Excel and use formulas to identify maximum, minimum, and average expense categories. 1 K3 IT APPLICATION – II
  • a
    Describe the difference between VLOOKUP and HLOOKUP functions. Provide syntax and real-time applications
  • b
    Use Scenario Manager to evaluate best-case, worst-case, and ave rage-case profit margins based on changing cost and selling price
  • a
    Create a Pivot Table using sales data of different products acr oss various regions and summarize total sales
  • b
    Discuss the use of tools like ggplot2 in R and Matplotlib in Py thon for advanced data visualization
  • a
    Explain the risks and precautions related to sharing personal information on social media
  • b
    Analyze how social media is used for networking and personal br anding in business
  • b
    Write a detailed note on the structure and application of a Man agement Information System

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

More BBA Semester 2 (2024-25) Papers

Other subjects from same semester and session

Principals Of Economics2024-25Soft Skills –I2024-25Basics Of Statistics2024-25Management Accounting2024-25Organizational Behavior2024-25
View all BBA Semester 2 2024-25 papers →