29.1.15

Acharya Nagarjuna University Report Generator Unit Wise Important Questions

Advertisemtnt
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

0comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Results / Notifications / Timetables

Advertisement

AP and TS 2021 Entrance Exams

Exam Name Telangana Andhra Pradesh
EAMCET 5th-9th July 2021 17th-25th Sept 2020
ICET 19th-20th August 2021 10th-11th Sep 2020
ECET 1st July 2021 14th Sept 2020
PGECET 19th-22nd June 2021 28th Sept 2020
EDCET 24th-25th August 2021 10th Nov 2020(FN)
LAWCET 23rd August 2021 10th NOV 2020(AN)
PECET Updated Soon 2nd-5th Nov 2020

Notifications

More

Latest Results

More

JNTU Fast Updates

More

AP / TS CETS Exams Info

Ed.CET
AP
TS
ECET
TS
EAMCET
AP
TS
ICT
AP
TS
LAWCET
AP
TS
PGLAWCET
AP
TS
PECET
AP
TS
PGECET
AP
TS
LPCET
AP
TS
POLYCET
AP
TS
SET

Hall tickets

More

Previous Question Papers

More
Top