0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
What is the name of the formula that you can select to multiply when your using Excel?
There is no specific name for a multiplication formula. To do multiplication in Excel you use the star character. You can click on the cell you want the formula in, and then you can type it like:
=F3*C5
This will multiply the amount in F3 by the amount in C5.
You can use a cell and a value, like this:
=A2*4
or
=16*J33
There is also a function called PRODUCT. In it you list the cells or values you want to multiply. Using the above examples you could use it like this:
=PRODUCT(F3,C5)
=PRODUCT(A2,4)
=PRODUCT(16,J33)
How do you Copy a range of data from an Excel worksheet to a word document?
Select the data in Excel and then use one of the copy methods, like Ctrl-C or using the copy command from the shortcut menu or the Edit menu or the Main ribbon. then go to the Word document and do a Paste. The data will appear in a Word table. You will lose the formulas and just get the data values and the results of the formulas.
Presuming that is:
=MIN(D3:D12)
That will give you the lowest value in the range of cells from D3 to D12.
What characteristics are not applicable to the accounting number format?
zero values displayed as hyphens
In excel 2007 what are the processes of adjusting the row and column portion of cell references?
If you have a cell address H12 and want to change the column, change the H to the letter of the column you want. If you want to change the row, change the 12 to the number of the row you want.
Is Excel a true database system like Access and Oracle?
No. Microsoft Excel is an accounting worksheet application, not a database. Microsoft Access is a small, simple, but capable, individual-user database application, and Oracle is among the largest of Enterprise-class database applications, and can accommodate the needs of gigantic corporations.
You double-click, causing an Auto-fit to happen.
What does the acronym wsywig mean in excel?
What You See Is What You Get.
It basically means that when you print something, the way you see it on your screen is how it will appear on the page.
If you are referring to MS Excel, A1 represents the cell in the top left corner of a worksheet.
If you are typing something in, you can press the Enter key or press the Tab key or you could click on the green tick beside the formula bar.
What does arranging mean in Excel?
It means putting things in their place. It means moving things around. It is like the meaning of arranging in other circumstances. As you build a worksheet, you don't always get things the way you want at first. You may have put things in the wrong place, or in the wrong order or you may need to move things so that you can add things you had not realised you needed. So you often need to arrange things into the way you want. So you may need to cut and past things or drag things or insert new rows or columns or sort things.
How do you convert numbers in to max 2 decimal in Excel after using formula?
You could use the ROUND function to round the results to 2 decimal places. You could also just format the cells to 2 decimal places. If you were using the ROUND function you would include the formula you had inside it, and specify two. So say you were doing a AVERAGE function and wanted the result rounded to two decimal places:
=ROUND(AVERAGE(A2:A40),2)
You could also use TRUNC which truncates the value to a certain amount of decimal places, but does not round the value:
=TRUNC(AVERAGE(A2:A40),2)
The two above functions may show slightly different values, because ROUND rounds a value, but TRUNC doesn't.
Where can one purchase Mira Excel BIV?
There are a number of places where one can purchase a Mira Excel Built-In Valve. Andrews Zone, Mira Showers, QS Supplies are all sources for this product.
How do you calculate mid value in statistics using Excel?
You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:
=MEDIAN(A2:D50)
When Microsoft Excel invented?
Microsoft Excel doesn't have an invention date per-say. It was sold to them by another company under a different name Microsoft released it under a different name and with major improvement in 1987.
Where in the worksheet area will you find the name box in Excel?
The Name Box is at the left end of the Formula Bar.
How is a formula related to what-if analysis?
A formula is statement written by the user to be calculated, and a what-if-analysis allows you to change the outcome by altering the input amount. The What-If analysis is based on a formula that was already programmed into the software.
How do you paste a resume to a company site that has no browse button?
Do they have any Contact link? If so, send the resume to the given address.
You can use a number of functions, depending on what you are doing. The main ones would be:
Find
Left
Right
Mid
Len
Find will do a search for the text you are looking for and give you the number of the position of the character in the text. So say you had the word ANKLE in A1. If you put a formula like the following one in it will give you the value 3:
=find("K",A1)
You can use FIND to find the start point of the word you are looking to extract and then use MID to extract it. As MID requires a starting point in the text, FIND will get it for you.
So say you were looking for the word fast out of the sentence Motor cycles are very fast vehicles which was in cell A1, the formula would be:
=MID(A1,FIND("fast",A1),4)
You can use Left and Right to extract letters from the beginning of a sentence or from the end of it. So using the above sentence again:
=Left(A1,5) will give you Motor
=Right(A1,5) will give you icles
Len gives you the length of a piece of text, which can be useful too.
You could use Mid more than once, but you will find better ways of doing things sometimes. It depends on what exactly you are trying to do. You can also bring bits of text together using the & to do so.
=LEFT(A1,17) & RIGHT(A1,8) will give you Motor cycles are vehicles
Say you have the following in A7:
Today is the first day of the rest of your life
=MID(A7,14,5)&" "&MID(A7,31,4) will give you first rest
Note here that I have used a space between double quotes in the &" "& part to put between the two words for proper punctuation . That can be useful to do too, because sometimes you'll find you will extract several words and there won't be spaces between them. You can use it to add spaces or other punctuations like commas or colons, whatever you need, especially if they are not in the original text. You can also put words inside those quotes to construct new sentences.
There is a lot there that I have shown you and that you can start experimenting with to try to do what you want. With practice and experience, you'll find lots of uses for these functions and some others. Set yourself a few simple tasks and see if you can do them. You will learn that way. You obviously know a bit already about the Mid function. With imagination, there is lots of things you can do.
When creating a chart in Excel the plot area is what?
contains graphical representation of values in data series
