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 find decile on Excel?
You can use the percentile function with values that are multiples of .10 in the function. Say your values were in the cells A2 to A50, you could use these functions for some of the different deciles:
=PERCENTILE(A2:A50,0.1)
=PERCENTILE(A2:A50,0.2)
=PERCENTILE(A2:A50,0.3)
=PERCENTILE(A2:A50,0.4)
What types of charts can you create from data in a spreadsheet?
Spreadsheet packages may chart one set of data in the form of a pie chart, or two or more sets of data in bar charts (with vertical bars, horizontal bars, or stacked bars), line charts, area charts, or mixed charts, which combine bars and lines
Which IT functions are being outsourced?
A significant trend in the new millennium is the outsourcing of programming, help desk, software support, and related services.
Is it possible to modify a part of a cell content without deleting everything in Microsoft Excel?
Yes you can. Once you are in Edit mode, you can change part of the cell content. You can select part of the content and move the cursor around it to the parts you need to change.
Yes, that is true. So for example, if it is at the bottom of a column of numbers, it will usually select those cells when the AutoSum is started. A user can still change the selection if they want different cells to be summed.
Why do you use Sort Data function in Microsoft Excel?
The sort feature allows you to look at the same data in different orders depending upon what information you seek. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, like listing values from highest to lowest or names in alphabetical order.
Help my Excel formula bar missing how do I get it to re-appear?
You can turn it on and off through the View menu.
What are the order of evaluation in excel?
1. Anything in parentheses, regardless of where they are in the formula. If you have nested () then the innermost set is first
2. Anything that has exponents (^)
3. Multiplication (*) and division (/); performed in the order they are in the formula (left to right)
4. Addition (+) and subtraction (-); following the same rules as multiplication and division (left to right)
Also, if you have a formula that has both percent and exponentiation operators, the percent operators are done first and then the exponentiation operators
Examples:
3+4*5 = 23
Comment: (4*5 = 20 +3)
(3+4)*5) = 35
Comment parentheses is done first (3+4 = 7) 7*5 is 35
3^2+4*5 = 29
Comment: 1. 3 squared is first (9); 2. then the multiplication (20) then; 3. 9+20 = 29
(3^2+4)*5 = 65
Comment: 1. Exponent first 3 squared (9); 2. Parentheses next (9+ 4 = 12); and then the rest (12 * 5 = 65)
(4^2+3/10*30)-10 = 96
Comment: 1. The contents of the () are first: a. 4 squared (16); b. 3/1 is next (remember multiplication and division are done in the order from left to right); c. 3*30 (90) is next; d. so a recap we now have (16+90)-10 so the last step in the () is 2. 106 - 10 which is 96 (WHEW)
Last one: (4^2+3)/10*(30-10) =
Comment: 1. First group is: a. 16; and b. 16+3 is 19; 2. Second () is 20; 3. 19/10 is 1.9; 1.9*20 = 38
The number of payments in future cash flow has what relationship to interest rate?
The number of payments is directly related to the interest rate.
What is the best method for entering cell references in to a formula in Microsoft Excel?
That really is your choice. You can type them if you know them, but for more complex formulas it is often better to use point mode, where you select them by using the mouse.
What does Excel do if you enter text that is longer than the width of the cell?
If the cell beside it is empty, then the text will spill over it, although it is still contained in the original cell. If the cell next to it has anything in it, the text will appear truncated, so you will only see as much text as will fit in the cell, although it is still all stored in it.
How do you undo Excel save file?
I had one day when I came across a very compound issue connected to excel file. To my good fortune I could work out such problem and perhaps it might be useful for this trouble.
What row numbers indicate some rows within a table are hidden from view?
If the row numbers are not consecutive then there are hidden rows.
How do you write to the 12th power in excel?
Let's say you want to take the value of what's in cell A1 and take to the 12th power, then you would type =A1^12 in the formula bar for the cell you want this calculated value to be in.
What are the parts of ms exel windows 2007?
none sens !! ang utak ng mga sumasagot ng walang kwenta !!
It cannot be used in a filename. It can be used in formulas as it stands for multiplication:
=A10*5
A parameter is a value that is used to carry out of task. It can be interpreted in a few ways. Parameters can be the values used to define filters if querying data in Excel. So if you have a list of data and want to show only some of it based on some criteria, that criteria can be referred to as parameters.
If data is being read from an external source, it may require a parameter to define what data to show. Microsoft Access has something called a parameter query where a value is fed in at the time the query is run. That value is called a parameter. So if Excel is reading a parameter query from Access, it will need to provide a parameter to do it with.
A parameter can be a value that is used in a function, though that is more commonly called an argument. In order for many functions to work they need values to work on. These are called arguments or occasionally parameters.
