SRI HARI DEGREE COLLEGE
BALAJINAGAR KADAPA
                             (AUTONOMOUS)
         I BCA/BCOM                   Office Automation Tools Question Bank Sem-II
                                          UNIT-I
Four Marks Important Questions:
  1.   Define computer. What are the characteristics of computer?
  2.   Explain primary and secondary memory
  3.   What are the features of MS word?
  4.   Explain about proofing text?
  5.   Explain about header and footer?
Ten Marks Important Questions.
  6. Explain about Block Diagram Computers?
  7. Explain about Generations of Computers?
  8. Explain about input and output devices with examples?
  9. What are the features of MS-Word?
  10.Explain about components of MS-Word Window?
                                          Unit-II
Four Marks Important Questions:
  1. Write about customize quick access toolbar?
  2. Write about printing documents?
  3. Define Hyperlink. Write steps to create a Hyperlink?
Ten Marks Important Questions.
  4. Define Mail Merge. Write steps to create a Mail Merge in MS-Word?
  5. Define Macro. Write stepwise procedure for Create (or) Record, Run, Delete a
     Macro?
  6. Explain Formatting a text documents, Paragraph formatting in MS word?
  7. Define Table. Write steps to create a Table in MS- Word?
                                         Unit-III
Four Marks Important Questions:
  1. How to enter and Edit the data in cell?
  2. Write procedure for creating, saving and editing a work book?
  3. Explain Spell-check, Find and Replace and goto commands?
Ten Marks Important Questions.
  4. Explain features of Ms-Excel?
  5. Define Function? Explain about different Types of functions in MS-Excel?
  6. Explain about formatting a worksheet?
                                         Unit-IV
Four Marks Important Questions:
  1. Write about data Sorting and Filtering?
  2. Write about scenario?
Ten Marks Important Questions.
  3. Define Cell Reference? Explain different Types of Cell Reference with examples?
  4. Define Chart? Explain about different types Charts in MS-Excel?
  5. Explain about what if - analysis?
     a) Goal Seek Scenarios b) Scenario Manager         c) Data Table
                                           Unit-V
Four Marks Important Questions:
  1. Write stepwise procedure for create presentation?
  2. Explain Various presentations Views in Ms-PowerPoint?
  Ten Marks Important Questions.
  3. How to create a slide, delete, rearranging the slides in Ms-PowerPoint?
  4. Difference b/w template & Wizard?
  5. Explain adding sub-headings, edituing text, formatting text using master slides in Ms-
     PowerPoint?
  6. Explain different types of slide Transitions & Animations in Ms-PowerPoint?
  7. Write stepwise procedure for to inserting music or sound on slide Ms-PowerPoint