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.

Follow @Sarvavasi.com