Monday, 7 August 2017

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

Advertisemtnt
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.



UNIT-I 
MS-EXCEL

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

  1. Explain different types of formatting techniques in Excel
  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.

Chapter-II (Functions)
  1. Explain the use of function wizard in Excel.
  2. Explain various categories of functions with examples.

UNIT-III
Chapter-I ( Charts)

  1. What is Chart? Explain different types of charts available in Excel.
  2. Write about different components of chart in Excel.
  3. Explain the use of chart wizard in creating charts instantly.
  4. What are the different editing operations on chart? Explain.
  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.
  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.
Chapter-II ( Macros)

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

UNIT-IV ( MS-ACCESS)
  1. Write about different features of MS-Access.
  2. Describe access work space and tools available within it.
  3. Explain the procedure to create database by using the table wizard.
  4. Explain the procedure to create database by without using the table wizard.
  5. Write about importing VS linking tables.
  6. Explain the procedure to create form by using the table wizard.
  7. Explain the procedure to create form by without using the table wizard.
  8. Explain how to modify a form in Access.
  9. What are the various sections of form.
  10. Explain how to create a chart using chart wizard in Access.

UNIT-V
  1. What are queries and dynasets? How can I Query a database.
  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.
  7. How to create Mailing Labels in MS Access.
  8. How to modify reports manually.
  9. Write about Flat files Vs Relation Database.
  10. What is Relation explain different types of Relations.
  11. How to define, view, deleting and redefining relations in Access.
  12. What is referential integrity constraint in Access? Explain.

Note: First Read the question which are in bold.

0 comments:

Post a Comment

Notifications

More

Results

More

ANU ICT-II Material

ANU ICT-II Material
Click on Image to Buy

Advertisement

important questions

More

Materials

More
Top