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
How do you get Excel to return highest number of entries in a range?
You can use the MAX function. If your range was A1 to A15, then your formula would be:
=MAX(A1:A15)
You can also use the LARGE function, although it is more for when you want to find a position like the second largest or third largest. To use it to find the largest you would type:
=LARGE(A1:A15,1)
The 1 tells it to find the largest. 2 would mean the second largest and so on. To find the largest it is better and simpler to use MAX.
Click New Rule
What is the box under the tool bar displays the address of the active cell?
It is the name box, with will show the address of cells and also names given to cells or ranges.
What is a pry bar and what is the function of it?
It is used as a lever to either force apart two objects or to remove nails.
How do you calculate mean absolute percentage in Excel?
I assume you want to take the absolute value of a set of data, find the average and convert it to a percentage.
For example, my data set is -1 -5 -3. The absolute values sum to 9, the average is 3 and presented as a percentage, it is 300%.
I would put in my excel spreadsheet the numbers in a single column (let's call it a2, a3, a4) then in b2 cell, enter +abs(a2) and copy down. At the bottom of the absolute values, enter +average(b2:b4) or whatever your range is. You can use format cell option under edit to convert to %. If you use Excel 2007, you will find % icon under the home tab, on the number pane of the ribbon.
How do you split 2 Excel documents over 2 screens?
With the new Excel 2007 I don't think you can! All my worksheets open in the same window even if they have different items in the taskbar.
Use the built in Help (F1 key) ask about "side by side" there!
A y chart is drawn on a paper dividing the paper into three by drawing a y to divide it.
It is used by brainstorming.
In spreadsheets what is an assumption list?
Sometimes you won't always know the values that you are going to be using, as you are trying to forecast something, like if you are doing a business plan. You won't know what your costs will be next year, or how the economy will go, how much you can produce and so on. All you can do is make assumptions so that you can at least test your spreadsheet. They should be as realistic as possible and stable and along the lines of what most people and experts would think.
What Tells Excel to perform a mathematical operation and arrive at a calculated answer?
It is a computer program that has been designed to do that. The specifics of how you would program it are a bit complex to explain here, but when you put a formula in, it recognises the calculation you are trying to do or the functions you have used and it runs the appropriate calculations to get your result.
What is the key that selects the cell down one worksheet window from the active cell?
If you have multiple worksheets open, then Ctrl - PageDown will move to the one to the right. If you have a number of panes on a worksheet, the F6 and the Shift-F6 key combinations can be used to move between them.
The cell entry is positioned in the far left of a cell?
It is normally formatted to be text. This can be useful if you want to type a value in a cell that is a number that starts with zero. Normally if you type something like 0123 into a cell the 0 will disappear leaving you with 123. If it was a code number or a phone number with a leading zero and you wanted to keep the zero what you can do is type the apostrophe and follow it with the zero and then rest of the value like this:
'0123
That will automatically format the number as text and the 0 will remain.
left aligned
How do you repeat a same command in Microsoft Excel?
Pressing the F4 key will repeat the last command.
Steps: 1. Click Conditional Formatting and select Greater Than... from the Highlight Cells Rules menu 2. Type $65,000 in the Format cells that are GREATER THAN text box and click OK
Download word and exel and PowerPoint?
You can only download trial versions of those applications which only work for a short period of time. You can do this through the Microsoft Office website. What you could do is get another application suite that is free, like Open Office. It has applications equivalent to Word, Excel and Powerpoint. Their site is linked to below, as is the Microsoft site.
Can an external Excel spreadsheet or a webpage be linked into a word document?
Yes. To insert a link, type the text you want as the link and select it. Then either press Ctrl and K, or go to the Insert menu and pick Hyperlink. In the dialog box that opens you will be able to choose the file or page which you want your link to go to.
What formula do you use to get a percentage of 2 numbers?
If you have two numbers and want to find what percentage they are of each other, you can do some division. So for example, if you want to find out what percentage of 96 is 75, then you would divide 75 by 96 and format the result as a percentage. So if 75 is in cell A1 and 96 is in cell A2, then in another cell you would put the following formula:
=A1/A2
It will be 78%.
If you want to find what percentage of 75 is 96, then the formula would be:
=A2/A1
It will be 128%.
The numerical difference between 75 and 96 is 19. If you want to find what percentage of 75 or 96 19 is, then you divide the 19 by the 75 or by the 96. You could have a formula in a cell A3 which finds the difference between the two numbers first as follows:
=A2-A1
That will be 19.
Then to find what percentage of 75 19 is in another blank cell you would have the formula:
=A3/A1
To find what percentage of 96 19 is in another blank cell you would have the formula:
=A3/A2
Give you not less than five answer of the differences between Microsoft Word and Microsoft Excel?
MS Excel - is spreadsheet software. On the other hand,MS Word - Document publishing software. MS Excel can perform calcuation while MS Word cannot perform complex calculation MS Excel has file format xls while MS Word is saved in .doc format. MS Word has more formatting options like dropcap while MS Excel has more calcuation options. MS Excel has capacity to summarize data while MS Word is can only store as it is.
