Acharya Nagarjuna University Report Generator Unit Wise Important Questions

Report Generator is a computer application subject appeared in all the degree courses of B.Com computers. The syllabus is completely covers the concept of Microsoft Excel. Here are the some important questions for you.

UNIT-I

1. What are the features of MS-Excel ?
2. Explain entering and editing,number,formulas.
3. Write about protecting and unprotecting documents and cells.
4. What is cell reference? Explain various cell reference Techniques.
5. Explain about Auto format and custom format.  
6. Explain about Auto fill and custom fill.   
7. Explain about moving cells,copying cells,sorting cell data.
8. Explain about inserting columns,inserting rows,inserting cell.

UNIT-II

1. Explain page setup options in MS-Excel 
2. Explain auto format feature in ms excel 
3. Explain various formatting techniques in excel.
4. Explain about number formatting in excel.
5. Explain about format painter feature in excel

UNIT-III

1. What is function ? What are its advantages? explain parts of a function.
2. Explain different types of functions in excel.
3. Explain the error messages from functions.
4. Explain about function wizard.
5. What is a chart? Explain the various types of charts offered by MS-Excel?
6. Explain about editing chart.
7. what is data map? Explain.

 UNIT-IV

1. Explain how to create and place graphics in excel.
2. What is macro? Explain creating and Running a macro.
3. Explain how to assigning macros to buttons.

UNIT-V

1. What  is database? Explain about creating database in excel.
2. What is a database and how it can be maintained using a data form ?
3. Explain in detail about filters in MS-Excel.
4. Explain sorting excel databases.
5. How sub totals and grand totals are calculated in excel?
6. Explain what-if Analysis.
7. What is scenario management? explain.
8. What is solver ? How to find right number using solver.
9. Explain the use of information window to find errors. 

       One important notice to all the viewers, If you like our content please share with your friends and also like us on Facebook. Any one don't have permissions to copy and reproduce  this site content. 

Advertisemtnt