-->
Home LAB ASSIGNMENT FREE SKILL DEVELOPMENT TRAINING'S

Microsoft-Excel 2007 Study Material Day- Two

Office Button

New (Ctrl + N ) :  This option used to create  a New Workbook.
Steps :

  • Click on Office Button then Click on New 
  • Select Blank Workbook
  • Click on Create
Open (Ctrl + O ) :  It can used open a pre-existing document.
Steps :
  • Click on Office Button and Click on Open 
Save ( Ctrl + S) :  Place the information on disk.
  • Click on Office button and click on  save
  • Select the Save-in Location (Example : Desktop or C Drive )
  • Type file name and choose the File Format Type (.XLSX )
  • Click on Save Button
Save As ( F12) : Save the workbook under a different name.
Steps :
  • Click on Office Button and Click On Save As .
  • Select the Save-In Location (Example : Desktop or C Drive ).
  • Type file name and choose the File Format Type (.XLSX ).
  • Click on Save Button.
Print ( Ctrl +P ) :  Send the workbook to the printer.
Steps :
  • Click on Office Button
  • Click On Print 
  • Again click on Print
Print Preview ( Ctrl + F2) : Look at the workbook on screen before printing.
Steps :
  • Click on Office Button 
  • Click on Print
  • Click on Print Preview
  • Click on Close button
Prepare : 
Encrypt Document : Increase the security of the workbook by adding encryption.
Steps :
  • Open the Workbook to which file do you want to set a password.
  • Click on Office button choose prepare.
  • Click on Encrypt Document.
  • Enter a Password in the text-box
  • Click on OK
  • Re-enter the password for con-formation 
  • click on OK button
  • Click on Office button and Click on Save Button.
To Remove the Password :
Steps :
  • Open the file which is having password.
  • click on office button and choose on prepare.
  • Click on encrypt document.
  • Remove the password in the Text-box.
  • Click on OK Button
  • Click on Office button and Click on Save Button.
Close ( Ctrl + W) : Close the Current Workbook.
Steps :
  • Click on Office button 
  • Click on Close Button
Close Window ( Alt + F4) : Exit from Excel.