Microsoft Excel Workbook
Workbook
In Mircosoft excel, a workbook is called a file in which you work and store your data, each workbook has three worksheets by default. You can store many types of information in a workbook.
Worksheet
Worksheet is also called spreadsheet. This is the initial document of Microsoft excel, in which we work with data, and store it. Worksheet is made up of cells which are organized in columns and rows. The worksheet is always stored in the workbook. You can type data in multiple worksheets simultaneously, modify them and calculate based on the data of different worksheets.
For example, you make a chart on another sheet and the data is or may be on another sheet.
A worksheet has three worksheets by default which can be expanded as needed.
create new workbook
There are many ways to create a workbook in Excel. We can make it in the following ways-
- Using Taskpane
- Using the Standard Toolbar
- Using Shortcut Key
save workbook
When you type something in the workbook, Excel keeps it safe by default or according to the options set by you Prevents damage in case of occurrence. Securing a workbook means protecting a file on a hard disk or other storage devices.
Save the workbook by name as follows -
- Click on the File menu and select Save As. After this the save as dialog box is displayed.
- Save in: Select the drive or folder in the list in which you want to save the workbook. If you want to save the workbook in a new folder, click on Create new folder.
- In the File name box, type the new name of the workbook.
- Click on Save button.
- After saving your workbook under a name, click the save button on the standard toolbar or press Ctrl+S to continue saving its contents.