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

Computer Fundamentals Important Questions For BCA Students

By
                                                                                                                                                                     UNIT-1   Q1 . Explain the block diagram of a computer system and describe the functions of each component in detail. Q2.   Describe the different generations of computers and discuss the major technological developments in each generation. Q3. Compare the different types of computers – micro, mini, mainframe, and supercomput...
Post a Comment
Read more

Computer Fundamentals Important Questions For BCA Students(One Liner)

By
 Q1. Who is called the Father of Computers?    Ans  Charles Babbage. Q2. What is processor speed measured in? Ans  Hertz (Hz), usually in GHz. Q3. What are registers? Ans Small high-speed memory locations inside the CPU. Q4. What is the full form of ALU? Ans Arithmetic Logic Unit. Q5. What is EPROM? Ans Erasable Programmable Read Only Memory. Q6. What does CD-R stand for? Ans Compact Disc – Recordable. Q7. What does DVD stand for? Ans Digital Versatile Disc. Q8. What is OCR? Ans Optical Character Recognition – reads printed text. Q9. What is OMR? Ans Optical Mark Recognition – reads marks on answer sheets or forms. Q10. What is MICR? Ans Magnetic Ink Character Recognition – used in bank cheques. Q11. What is a joystick? Ans  A pointing device used for gaming and simulation. Q12. What is a digitizer? Ans Converts drawings into digital data. Q13. What is a CRT monitor? Ans Cathode Ray Tube monitor – uses electron beams to display images. Q14. What is an LCD m...
Post a Comment
Read more

Computer Fundamentals MCQ Questions For BCA 1st sem. Students

By
  Q1.Which of the following is not a characteristic of a computer? a) Accuracy b) Diligence c) Intelligence d) Speed → Answer: c) Intelligence Q2.The first generation of computers used a) Transistors b) Vacuum tubes c) Integrated Circuits d) Microprocessors → Answer: b) Vacuum tubes Q3. Which of the following is a microcomputer? a) Laptop b) Mainframe c) Supercomputer d) Minicomputer → Answer: a) Laptop Q4. The ALU of a computer performs a) Logic and arithmetic operations b) Storage functions c) Data transfer d) Input-output operations → Answer: a) Logic and arithmetic operations Q5. The brain of a computer is: a) CPU b) Monitor c) Keyboard d) Hard Disk → Answer: a) CPU Q6. Which component interprets and executes instructions? a) Control Unit b) ALU c) Memory Unit d) Input Unit → Answer: a) Control Unit Q7. The speed of the processor is measured in a) Hertz b) Bits c) Bytes d) Seconds → Answer: a) Hertz Q8. Which of the following represents the fifth generation of computers? a) Vac...
Post a Comment
Read more