Skip to main content

IT Tools In Business BBA 4th Semester Important Questions

Image
By

 



✅ UNIT–I: SPREADSHEETS — Important Questions

Short Questions

  1. What is the difference between a worksheet and a workbook?

  2. Define relative, absolute and mixed cell referencing with examples.

  3. What are Named Ranges? How are they created?

  4. What are common formula errors in Excel (e.g., #DIV/0!, #VALUE!)?

  5. What is the purpose of Data Consolidation?

  6. What is the use of Page Breaks in spreadsheet printing?

  7. Define Data Series and Data Points in charts.

  8. What is a Sparkline?

  9. What is Goal Seek?

  10. What do you mean by OLE (Object Linking and Embedding)?

Long Questions

  1. Explain various types of cell referencing and show their usage with examples.

  2. Discuss the steps involved in creating, modifying and formatting Pivot Tables.

  3. Explain any five categories of functions in Excel with examples.

  4. What is What-If Analysis? Explain Data Tables, Scenario Manager and Goal Seek.

  5. Describe chart elements and explain how charts can be formatted.

  6. Explain methods of protecting workbooks and worksheets.

  7. Write a detailed note on consolidating data using formulas and Data Consolidate command.

✅ UNIT–II: WORD PROCESSING — Important Questions

Short Questions

  1. What is the difference between styles and formatting?

  2. What are section breaks? Why are they important?

  3. What is the function of headers and footers?

  4. Define footnotes and endnotes.

  5. What is a Table of Contents (TOC)?

  6. What is Mail Merge?

  7. What is the purpose of Bookmarks and Cross-referencing?

  8. What are the uses of Find and Replace?

  9. What is the difference between a caption and a label?

  10. What is a Bibliography?

Long Questions

  1. Explain character and paragraph formatting in MS Word.

  2. Describe the process of creating and formatting tables in MS Word.

  3. Explain the steps involved in creating newspaper-style columns.

  4. What is Mail Merge? Explain the process of creating main documents and data sources.

  5. Explain referencing tools: captions, cross-references, bibliography creation.

  6. Describe spell-checking and grammar tools used in Word.

  7. Explain linking and embedding objects in Word documents.

✅ UNIT–III: POWERPOINT PRESENTATION — Important Questions

Short Questions

  1. What is a design template?

  2. What is the purpose of Slide Sorter view?

  3. What are Master Slides?

  4. What is the difference between Animation and Transition?

  5. What are Action Buttons?

  6. What are multimedia elements in presentation?

  7. Define Handout Master.

  8. What is a custom show?

  9. What is the use of the On-Screen Pen?

  10. What are Placeholder objects?

Long Questions

  1. Explain the steps involved in creating a presentation using templates.

  2. Describe the various slide views available in PowerPoint.

  3. What is Slide Master? Explain its features.

  4. Discuss animation schemes and custom animations with examples.

  5. Explain how sound and video clips are inserted into a presentation.

  6. Describe transitions. How do you control transition speed?

  7. Explain advanced navigation features like action settings and hyperlinks.

✅ UNIT–IV: DATABASES (MS ACCESS) — Important Questions

Short Questions

  1. Define Database, Table, Record and Field.

  2. What is a Primary Key?

  3. What is a Data Type? Name any four.

  4. What is Referential Integrity?

  5. Define Indexing.

  6. What is a Select Query?

  7. What are Parameter Queries?

  8. What is the difference between bound and unbound controls?

  9. What is a Subform?

  10. What is a Report?

Long Questions

  1. Explain database terminology: tables, fields, records, data types, relationships.

  2. Explain steps to create tables in design view and set field properties.

  3. What is a query? Explain Select, Update, Append and Delete queries.

  4. Explain different join types with examples.

  5. What are validation rules? Explain field level and record level validation.

  6. Explain the process of creating forms and adding various controls.

  7. Explain the steps involved in creating and formatting reports.

  8. Discuss sorting, filtering and record manipulation in MS Access.

  9. Explain Crosstab, Find Unmatched and Find Duplicate queries.

  10. Write a note on grouping and creating sub-reports

Comments

Post a Comment

Thank you for comment.

Popular posts from this blog

C++ Object Oriented Programming Language Important Questions For BCA Students(One liner)

By
 Q1. What is OOP? Ans Object-Oriented Programming focuses on objects and classes rather than procedures. Q2.What is a class? Ans A class is a blueprint for creating objects. Q3. What is an object? Ans An object is an instance of a class. Q4. What is encapsulation? Ans Encapsulation is binding data and methods together in a single unit. Q5.What is inheritance? Ans Inheritance allows a class to acquire properties and behavior of another class. Q6. What is polymorphism? Ans The ability of functions or operators to behave differently based on context. Q7. What is overloading? Ans. Defining multiple functions with the same name but different parameters. Q8. How is C related to C++? Ans. C++ is an extension of C that adds object-oriented features. Q9. What is the use of cout? Ans cout is used for displaying output on the screen. Q10 What is the use of cin? Ans cin is used for taking input from the user. Q11. What is a preprocessor directive? Ans A statement that begins with # and is proc...
Post a Comment
Read more

Project Ideas For College students

By
 1. Online Voting System: Build a secure voting platform where people can vote remotely. Add OTP verification or blockchain integration for tamper-proof results. 2. College Event Management System Design an event registration and ticketing system with admin controls for approvals, schedules, and sponsor details. 3. Online Food Ordering System Create a food ordering platform similar to Swiggy or Zomato with real-time tracking, discount codes, and delivery partner integration. 4. Hospital Management System Build a system to handle patient records, appointments, billing, and prescriptions while improving doctor-patient communication. 5. Weather Forecasting Website Show real-time weather updates, weekly forecasts, and storm alerts with visual maps and charts. 6. Online Library Management System Allow students to search, borrow, and return books online. Add recommendations, late-fee tracking, and admin inventory management. 7. Blood Bank Management System Connect donors with hospitals b...
Post a Comment
Read more

Applications Of Computers || Basic Guide

By
The computer has applications in almost every aspect of life. Some of the important ones are: Business Banking Insurance Education Marketing Healthcare Engineering design Defense Communication Governments Medicine Entertainment Home Sports Business A computer has a high speed of calculation, diligence, accuracy, reliability, or versatility which has made it an integrated part in all business organizations. The computer is used in business organizations for − Payroll calculations Budgeting Sales analysis Financial forecasting Managing employee database Maintenance of stocks, etc. Banking Today, banking is almost totally dependent on computers. Banks provide the following facilities − Online accounting facility, which includes checking current balance, making deposits and overdrafts, checking interest charges, shares, and trustee records. ATM machines that are completely automated are making it even easier for customers to deal with ban...
Post a Comment
Read more