IMPORTANT QUESTIONS FOR 5th SEMESTER EXAMINATION
Excel Foundation B.Com (Comp. & Comp.Appli.) III Year
Explain the various tabs present on the ribbon of MS Excel.( May 19 Nov 18)
Discuss steps involved in creating a new chart. May 19
What are different data types in Excel. (Nov 18)
Explain how numbers can be entered and formed in spread sheets.
Describe the process of adding, deleting and activating worksheet in Excel. (May 19 Nov 18)
Explain different ways of selecting rows and columns.
Discuss various paste options offered by Excel 2013. May 19
Define table ? Explain the steps involved in creation of table. (Nov 18)
What are the steps involved in changing the colour of text and background of a table.
Write about borders and lines in Excel.
Discuss the method for removing duplicate rows from a table.
Explain the process to create an open work book in Excel. (Nov 18)
Define Template ? How a work book can be created from a template. May 19
Discuss the process of modifying a template. (Nov 18)
Discuss in detail about creating and saving custom templates.
Discuss briefly about page lay out view of Excel. May 19
Explain in detail the process of adjusting page margins. (Nov 18)
Explain the process of inserting the page breaks. (Nov 18)
Discuss in detail the header and footer element codes in Excel. (May 19 Nov 18)
Features & Uses of MS Excel. (Nov 18)
Charts of MS Excel.
Different ways of closing windows.
Options present in special dialog box.
Navigation in Excel.
Steps involved in inserting slicers.
Sorting in Excel. (Nov 18)
Mini tool bar. (Nov 18)
Optinons of opening a file from open dialog box.
Views of Excel work sheet.
Steps involved in printing in Excel.
How to save Excel work sheet in Pdf.