EFImportantquestions

 Unit-I

1. Different Steps to be performed to create a new worksheet?
2. What are the different data types a cell can hold?
3. Define MS Excel and it's features?
4. Define chart? Explain types of charts? and Parts of Charts?
5. Explain Various types of commands on ribbon?
6. Explain working with dialogue boxes in Excel?
7. Explain shortcuts to move around a worksheet?

Unit-II

1. Explain Different ways to selecting range of cell? And Explain Complete rows and columns?
2. Describe the adding, deleting, activating work sheet in a work book?
3. Explain selecting special types of sells?
4. Explain paste special dialogue box?
5. Explain Multi Sheet Range?
6. Explain Non contagious range?

Unit-III

1. Describe method of moving table to a new location?
2. Write the steps to change the colour of text and background?
3. Explain steps to create a table?
4. Explain Formatting tools available in Home table?
5. Explain sorting filtering data in Excel?
6. How to add borders and lines in Excel?
7. Explain converting table to a range?

Unit-IV

1. Different ways of saving a workbook?
2. How many types of templates supported by Excel?
3. Creating and saving custom template?
4. Explain Auto Recovery feature in Excel?
5. Password Protection features in Excel?
6. Explain the concept of modifying template?

Unit-V. 

1. Explain the process of inserting header and footer?
2. Explain Page Orientation& scaling feature in Excel?
3. Concept of Adjusting page margins?
4. Removing Manual page break?
5. Processing page layout view?
6. Process of crating PDFs?
7. Changing page orientation?