How to Create Save Open Preview Print and Close Worksheet

Creating a worksheet

To create a worksheet using MS-Excel we can perform following steps:

• Click Office button 
• Click New 
  
• Now from available templates, double click on Blank Workbook also we can use Ctrl + N shortcut key from the keyboard to quickly create a new blank workbook.
  

Saving MS-Excel file

Using following steps we can save MS Excel file:

• Click Office button
• Click on Save button, then Save as dialog box will appear 
• Now we can locate the folder in which we want to save the file 
• Now we can type the name of the file in the File Name box 
• Now we can click Save button

Opening MS-Excel file

Using following steps we can open MS Excel file:

• Click Office button
• Click on Open button, then Open dialog box will appear 
• Now we can locate the file which we want to open
• Now we can click Open button
• Also we can use Ctrl + O shortcut key from the keyboard to open MS-Excel file 

Closing MS-Excel file

Using following steps we can close MS Excel file:

• Click Office button
• Click on Close button or we can press Alt + F4
• Now save confirmation dialog will appear, in this dialog we can click Save button or we can choose Don't save or Cancel options according to our specification

Print preview and print MS-Excel file

Using following steps we can print preview and print MS Excel file:

• Click Office button
• Now click Print - Print preview 
• Now we can see print preview of the document 
• Here we can click Print button or we can press Ctrl + P 
• Now print dialog box will appear 
• In this dialog box we can add page number on page range 
• Now we can specify a number of copies on copies option 
• And then we can click Ok button to print MS Excel document

UNIT-104

Digital Data Tabulation-Spreadsheet

1. Introduction and Concepts of Spreadsheet and Workbook
2. How to Create, Save, Open, Preview, Print and Close Worksheet
3. How to Enter Numbers, Text, Date and Time, Series using Auto Fill
4. Editing and Formatting of Worksheet
5. Changing Color, Size, Font, Alignment of Text
6. Inserting/Deleting cells, Rows and Columns
7. Entering Formula in cell using operator (+, -, x, /) etc
8. Cell Referencing(Relative, Absolute and Mixed)
9. Functions(SUM, AVERAGE, MAX, MIN, IF)
10. Inserting tables in Worksheet
11. Charts(Lines, Pie, Bar, Column, Area)
12. Macros in Worksheet