The concept of Workbook and Worksheet.
When you open Excel, the Excel application window opens with a new Excel workbook. A Workbook is a multi-page Excel document. After saving the Excel file or workbook it takes the default extension. XLSX in its filename. Each page in the workbook is called a Worksheet. The active worksheet is displayed in the
document window. By default, a new workbook has one sheet in office 2013.
You can add or remove sheets from a workbook to suit your need. Sheet tabs and the navigation buttons
belong to the extreme left end of the horizontal scrollbar. Click a sheet tab to move to another worksheet or
use the navigation buttons to scroll through the sheet tabs.
Simple Mathematical Calculation
Mathematical operator, such as + (for addition), – (for subtraction), * (for multiplication) and /(for division)
makes a spreadsheet program so useful.
Working with Formulas and Functions.
After you enter a formula, the cell displays the calculated result of the formula. The formula itself appears in the
Formula bar when you select the cell, however.
Following are a few examples of formulas:
|=A1+A2+A3+A4||Adds the values in the cell A1, A2, A3 and A4|
|=B1-B2||Subtract the values in cell B1 and B2|
|=C1*C2||Multiplies C1 and C2|
|=D1/D2||Divide the value of cell D1 with cell D2|
To apply auto sum, just keep your cursor on the target cell and click ∑Autosum command under Home Tab ⇒ Editing Group.
Saving a Workbook
Whatever you type in a workbook is stored only in your computer’s temporary memory. If you exit Excel,
that data will get lost. Therefore, the important matter has to be saved within permanent memory using save command.
To Save a New Workbook:
- Click File button ⇒ Save as ⇒ Click Excel Workbook. This will launch the Save as dialog
- Type a new file name (e.g. – ABC.XLSX) and click Save Button.
The default extension name of an Excel workbook is.XLSX
To Save an Existing Workbook:
1.) Select File Button + Click Save. FILE
2.) Type a new name (e.g. — Day1.XISX) and click on save button
By default, Excel saves a copy of your work automatically every ten minutes. To adjust this setting (or turn it off), use the Save tab of the Excel Options dialog box. To display this dialog box, choose File Button
Options. However, you should never rely on Excel’s Auto Recover feature. Saving your work frequently is a
Opening an Existing Workbook.
To open an existing file of Excel from the Hard disk:
I) Select File Button ⇒ Open or press Ctrl + O.
2) The Open dialog box will appear, choose your file from a relevant path and click the open button.
Closing Workbook and Excel
To close the active workbook window:
- Click the window ‘s close button or choose office button⇒ Click close or Press Ctrl + W.
- OR To Close Excel, choose File Button to close.