Monday, 24 September 2018

ANU UG / Degree B.Con (CA) 3rd Semester Office Automation Tools(OAT) Important Questions

ANU UG / Degree B.Con (CA) 3rd Semester Office Automation Tools(OAT) Important Questions for all units are now available. The candidates can prepare these questions to get good marks. The question paper is for 75 marks, consists of 8 questions and you need to answer any 5 question, each question carries 15 marks.Note: First Read the question which are in bold.


  1. Explain important features of MS Excel [AU-17,BRAU-17,AKNU-17,ANU-17]
  2. Explain the parts of the worksheet with the help of the diagram. [AU-17]
  3. Explain entering and editing number,formula in Excel.[BRAU-17]
  4. What is cell reference? Explain different types of cell Reference Techniques in Excel.
  5. Write about auto format and custom format.
  6. What is auto fill and custom fill? [BRAU-17,AKNU-17,ANU-17]
  7. Write about Various printing options in Excel. [AU-17,BRAU-17]
  8. Write about Number formatting in Excel.[AKNU-17]
Chapter-I ( Formatting Options)

  1. Explain different types of formatting techniques in Excel [AU-17, BRAU-17]
  2. Explain the following 
       a) Changing row, column Height and width.
         b) Inserting row and column.
        c) Deleting row and column.
        d) Hiding row and column.
    3. How formulas react to worksheet design.
    4. How to use format painter option in Excel.
    5. Write short note on Auto format in MS Excel. [AU-17]

Chapter-II (Functions)
  1. Explain the use of function wizard in Excel.
  2. What are operators? Explain with examples. [BRAU-17,AKNU-17]
  3. Explain various categories of functions with examples. [AU-17,BRAU-17,AKNU-17, ANU-17, KRU-17]

Chapter-I ( Charts)

  1. What is Chart? Explain different types of charts available in Excel. [AU-17,AKNU-17, ANU-17]
  2. Write about different components / parts of chart in Excel. [ANU-17]
  3. Explain the use of chart wizard in creating charts instantly.[AKNU-17]
  4. What are the different editing operations on chart? Explain.[KRU-17]
  5. What is data map in Excel? Explain.
  6. How to create and place graphics in Excel? Explain.
  7. How to sort excel data / database? Explain. [BRAU-17]
  8. Explain about the auto filter feature in Excel.
  9. How to add sub totals to Excel database 
  10. What is scenario? How to define and view them? How to obtain scenario in Excel.
  11. Write about What-If Analysis method.[BRAU-17,ANU-17]
Chapter-II ( Macros)
What is March? Explain various Advantages of Macros in MS Excel. [AU-17]

What is March in Excel? How to create, run, edit, view and delete Macros in Excel? 

  1. Write about different features of MS-Access.
  2. Describe access work space and tools available within it. [BRAU-17,KRU-17]
  3. Explain the procedure to create database by using the table wizard.[ANU-17,KRU-17]
  4. Explain the procedure to create database by without using the table wizard. [BRAU-17, KRU-17]
  5. Explain various data types available in MS Access. [AU-17,BRAU-17,AKNU-17]
  6. Write about importing VS linking tables.
  7. Explain the procedure to create form by using the table wizard. [AU-17,AKNU-17]
  8. Explain the procedure to create form by without using the table wizard.
  9. Explain how to modify a form in Access.
  10. What are the various sections of form.
  11. Explain how to create a chart using chart wizard in Access.

  1. What are queries and dynasty? How can I Query a database. [AU-17,ANU-17,KRU-17]
  2. How to do multilevel sorts suing quires in Access?
  3. How to find incomplete matches in a query of Access?
  4. How to save queries for later use in Access.
  5. What are crosstab quires? How to build to build them?
  6. How to create reports in Access.[BRAU-17]
  7. Describe different sections of a report. [KRU-17]
  8. How to create Mailing Labels in MS Access.
  9. Database Printing. [ANU-17]
  10. How to modify reports manually.
  11. Write about Flat files Vs Relation Database.[AKNU-17,ANU-17]
  12. What is Relation explain different types of Relations. [AU-17, BRAU-17]
  13. How to define, view, deleting and redefining relations in Access.[AKNU-17]
  14. What is referential integrity constraint in Access? Explain.

Note: First Read the question which are in bold.


Post a Comment


Follow Us

ANU PGCET 2019 Info


previous question papers




important questions




ANU Materials


This Blog is protected by