Match Formula in Excel:

MATCH(lookup_value, lookup_array, [match_type])

lookup_value : Required. The value that you want to match in lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

lookup_array: Required. The range of cells being searched. match_type: Optional. The number -1, 0, or 1. The match_type argument specifies how Excel matches lookup_value with values in lookup_array. The default value for this argument is 1.

Wednesday, 30 July 2014

Top five best free antivirus and internet security:

Antivirus is very important software for PC/Laptop/Mobile/Tablets including both personnel and business purpose.Generally people have brought free antivirus best alternative for those who don’t want to pay for Antivirus but still wants good and effective solution.Here are the list of free best antivirus which is widely used now a days.Choose as per your interest.

Free Avast Antivirus:- Avast is most widely used antivirus. It's audio detection feature is very good that is "Caution! virus has been detected ". Boot time scan is very attractive feature.Best free antivirus protection against dangerous viruses, worms, Trojans and spyware.Free Avg Anitvirus:-

AVG is also very effective antivirus available free of cost.Free Avira 2014 Antivirus:-

Avira is also counted as trusted brand in the list of antivirus. It's interface and size is very simple and easy to use. Avira removes malware and protects your system against the latest strains of viruses, worms, Trojans and more and keeps your PC clean. It provide regular update of definition.Free Microsoft Security Essentials :-

Its also preferred by many users due to its simplicity and effectiveness.It protect your computer devices against viruses, spyware, and other malicious software.Panda Cloud Antivirus Free Edition :-

8 MP Primary Camera and 2 MP Secondary Camera

Friday, 25 July 2014

Jolla will sell its Sailfish OS smartphone in India within the next month:

Smart phone market in India is growing rapidly.“India is the rising smartphone market of the world". Jolla deals with Snapdeals to sell their smartphone with Sailfish OS in India from next month.This smart phone has following features:

Display-4.5-inch IPS qHD(540x960p) .

1.4GHz Qualcomm Snapdragon dual-core processor .

1GB of RAM

16GB storage expandable via microSD card.

2100mAh battery.

8MP rear camera alongside an LED flash.

2MP front-facing camera as well.

One of the USPs of the phone is changeable 'The Other Half' smart covers that also change the phone's user interface theme.

It runs Sailfish OS, which is based on MeeGo, the same OS that was last seen on Nokia's N9 smartphone. In fact, Jolla was founded by a group of ex-Nokia employees who were involved with the development of MeeGo based devices at the company. Lets see what happened.More..

Working of Vlookup?

Introduction to vlookup?

As the name implies, V-Lookup, stands for Vertical Lookup, which is used to find specific information column wise vertically that has been stored in excel sheet.

Let’s study the Formula/Syntax of V-lookup function. It consists of four parts.

Lookup_value - This is the index which we have to search in the table.

Table_array, col_index_num - This is table array in which we search the look up value . This argument is a named range or a reference to a range of cells. Here, in above our table range is cell H2 to J7.

Col_index_num- Enter the column number of the table_array from which you want data returned from means which data you want to print as result. In above example, column index is 2 since value of name is 2nd position.Range_lookup: A logical value (TRUE 1 or FALSE 0 only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value.

If TRUE(1) or if this argument is omitted, VLOOKUP will use an approximate match if it cannot find an exact match to the lookup_value. If an exact match is not found, VLOOKUP uses the next largest lookup_value. If FALSE(0), VLOOKUP will only use an exact match to the lookup_value. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, an #N/A error is returned.

Program 2:

var i; for (i = 1; i <= 10; i++)

{

c = i * a; alert(c);

}

BUY MI3 (METALLIC GREY) :Rs. 13999

Flip kart site is down due to technical issue after selling is started from 22 July 2014. Mi3 is stock out on flipkart after 39 minutes, may be available soon on flip-kart. Click on buy now button to check availability of Mi3. Mi3 smartphone has many attractive features. some of them as follows take a look.

Tuesday, 22 July 2014

Java script has very simple code for browser. Generally java script is used to restrict user. But you can learn java script by playing with coding.

Program:

var num =prompt("Enter a number");parseInt(num);var i;var b=0; if(num==1){alert("A prime number is a number which has only two factors, 1, and itself. But in the case of 1, there is only one factor: 1. So, 1 is not a prime number");}else{for(i=1;i<=num;i++){var result = num%i;if(result==0){b++;} }if(b<=2){alert("Prime no.");}else{alert("Not Prime");}}