MS Excel 2016 best fit or auto fit

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+A4Adds the values in the cell A1, A2, A3 and A4
=B1-B2Subtract the values in cell B1 and B2
=C1*C2Multiplies C1 and C2
=D1/D2Divide 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:

  1. Click File button ⇒ Save as ⇒ Click Excel Workbook. This will launch the Save as dialog
  2. 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
good idea.

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.

How to customize data format alignment,number grouping

Previous article

How to use flash fill in excel 2016 and most used features

Next article

You may also like

Comments

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

More in Excel