Sunday, December 10, 2017

Excel Anatomy- Part01 workbook,worksheet and cells

Work book, work sheet, cells

What is Workbook ?

A workbook is a file that contains one or more worksheets, to help you organize your data. You can create a workbook from a blank workbook or a template. Press CTRL+N to quickly create a new workbook.

In Microsoft Excel a workbook is a collection of one or more spreadsheets, also called worksheets in a single file. Below is an example of a spreadsheet called "Sheet 1" in an Excel workbook file called "Book 1." Our example also has the "Sheet 2" and "Sheet 3" sheet tabs that are also part of the same workbook.

What is Worksheet?

An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A. Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. In Excel 2010, the maximum size of a worksheet is 1,048,576 rows by 16,384 columns.

There can be many sheets in your Excel document and you can see the sheets listed as tabs along the bottom of your document. We can insert as many worksheets as you want to quickly insert a new worksheet, click the plus sign at the bottom of the document window.

If you want more worksheets select file tab click excel option to general and select to include many new sheets change.
File > options > general > include many new sheets

If you want to move the work sheet, to select right click move to sheet position.

Press ctrl + page down to move the worksheet. Move to the sheet1 from sheet5 to select sheet 1 tab right click on the mouse to select move and click OK.





What is cell?

A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. Below is an example of a highlighted cell ; the cell address, cell name, or cell pointer "D8" (column D, row 8) is the selected cell and the location of what is being modified.

Active cell is surround by bold layer

Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such as 1, 2, 3.A cell can only store 1 piece of data at a time. you can store data in a cell such as a formula, text value, numeric value, or date value.

Data base function

Database function Daverage function      Averages the values in a field (column) of records in a list or database that match conditio...