Question about Microsoft Business & Productivity Software

Sreeki

The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:

http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx

(**Important:** Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)

http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(**Important:** Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)

http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1

GuruAid.com

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:

http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx

(

http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(

http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1

GuruAid.com

Jul 30, 2014 | Microsoft Excel 2010

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Use this link to download all excel Dicttionary function

http://www.xlfdic.com/

Thanks for choosing Fixya.........

Sandeep

http://www.xlfdic.com/

Thanks for choosing Fixya.........

Sandeep

Mar 18, 2011 | Excel Function Dictionary

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

In order to use Microsoft Excel you have to buy a license. You can always download a limited time trial. Trial programs contain the same functionality that you get when you buy the perpetual versions.

If you don’t want to pay for a license, you can use OpenOffice, the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers.

Great software, same functionalities as Microsoft Excel, easy to use, and it’s free:

http://www.openoffice.org/

If you don’t want to pay for a license, you can use OpenOffice, the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers.

Great software, same functionalities as Microsoft Excel, easy to use, and it’s free:

http://www.openoffice.org/

Mar 02, 2010 | Microsoft Excel for PC

There are lots of ways of doing this - But it depends on how complex your fomula needs to be, or it may be a case of changing the format of the cell..

IF function will work well for a small range

LOOKUP will work well for a larger range assuming there will be duplications

IF function will work well for a small range

LOOKUP will work well for a larger range assuming there will be duplications

Feb 28, 2009 | Microsoft Excel for PC

www.google.com

Jan 14, 2009 | Microsoft Office Excel 2003 for PC

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

Try clicking the down arrow beside the autosum button in your Excel Standard toolbar. Then click More FUNCTIONS. An Insert Function dialog box appears. There use can explore all MS Excel functions.

Oct 10, 2007 | Microsoft Office Standard for PC

what software are you using? If no then try to use excel. You can list down the # and perform a column check to the #

Aug 30, 2007 | Microsoft Office Standard for PC

89 people viewed this question

Usually answered in minutes!

×