Monday, August 12, 2013

Working with AVERAGE function in Excel

Returns the average (arithmetic mean) of the arguments. For example, if the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

The syntax of the average function is: 
AVERAGE(number1, [number2], ......[number255])

[Number 1] Required. The first number, cell reference or a range for which you want the average.
Other numbers, cell references or ranges for which you want the average, up to a maximum of 255.


Example:
Type the data into cell A1 to A10 (3,5,12,15,3,5,8,9,5,2)
Goto cell A11 (where you want to display the result)

Figure: 1.1 

Goto upper side the Excel file you will see the tabs. Click the Formulas Tab (as shown in Figure 1.1)

                                                                     Figure: 1.2 

After the clicking Formulas Tab the new tab appear on Tab bar.
Step1: Click the More Functions
(when you click the More functions the menu will be appear)
Step2: Click the Statistical (and the sub menu appear)
Step3: Clcik the AVERAGE
(See the figure 1.2 for example)

Figure 1.3
Now you will see the new popup window on your screen (see the figure 1.3 for example)

select the range A1:A10 and then click OK.

                                                                     Figure 1.4
or direct type the cell A11 =AVERAGE() and select the range (A1:A10) (see the figure 1.4)

The answer of 6.7, which corresponds to the average value of data in cells A1 to A10, should appear in cell A11.

Friday, June 28, 2013

Value


A value can be virtually any type of data of a given type of data, such as a string, a digit, a single letter.
The numerical values ​​represent an amount of some kind: amounts of sales, number of employees, atomic weights, test results, and so on. Values ​​may also be date (as in February-26-2013) or the time (eg, 3:24 a.m.).
To Boolean or logical data, the value refers to the state of the data - whether true or false
For text data, the value refers to a word or string of entry into the spreadsheet
The value can also be used to mean a condition or parameter that must be fulfilled for certain results in a worksheet occur.

For example, to filter data, the value is the condition that the data must meet in order to remain in the data table and not filtered.

Worksheet

A spreadsheet is an object in a spreadsheet program that is mainly composed of a grid of cells arranged in rows and columns, which are held spreadsheets and information.
There are three default file sheets in 2010 or earlier versions, but in 2013 only one sheet by default, but you can create many sheet if necessary.
A file stored in a spreadsheet program may consist of many worksheets.

To make a new spreadsheet (see picture below) Go to the Home tab, in the Cell group click the icon to insert and click on the tab.



Excel Sheet view 2003

Excel Sheet view 2007 and 2010


Excel Sheet view 2013


Thursday, June 27, 2013

Range

A group of cells is called a range. To designate an address range specifying the address of the top left cell and address of the bottom right cell, separated by colons.

For example see the pictures below:










Cell




A cell is a single item in a spreadsheet can contain a value, a text or formula. A cell is identified by its address, which is its column letter and row number. For example (see the picture below), cell E12 is the cell in the fifth column and the twelfth row. Cell name is appear in Name Box. Cell can be thought of as a box for storing data. Generally rows, representing the dependent variables, referred to in decimal notation from 1 whereas the columns represent the independent variables used 26-adic target numbering using the letters AZ as numbers.
In most implementations, many worksheets can be located within a single spreadsheet. A spreadsheet is simply a subset of the spreadsheet divided for the sake of clarity.




Using of format numbers shortcut keys



Another way to apply number format is the use of hotkeys. Below picture summarizes the shortcut key combinations you can use to apply common number format selected cell or range. Note that these characters Ctrl + Shift are located together, in the upper left of the keyboard.


Wednesday, June 26, 2013

Understanding Workbooks and Worksheets


The work you do in Excel is done in a workbook file. You can have as many open books as needed, and each appears in its own window. By default, Excel workbooks use a file extension. xlsx.
Each book contains one or more worksheets, and each worksheet is composed of individual cells. Each cell can contain a value, a formula, or text. A worksheet also has an invisible drainage layer, which has charts, pictures and diagrams. Each worksheet in a workbook can be accessed by clicking on the tab at the bottom of the workbook window. In addition, a book can store chart sheets, a sheet of graph shows a single card and can also be accessed by clicking on a tab.

Newcomers to Excel often feel intimidated by the different elements that appear within the Excel window. After you become familiar with the various parts, it all starts to make sense, and you will feel at home.
Related Posts Plugin for WordPress, Blogger...

Add this