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
When protecting a worksheet are all cells locked by default in Microsoft excel?
Yes, the default setting for protection on is all cells locked.
Where is the beusty bar located?
There is nothing called a "beusty bar" in MS Excel. Please ask this question again with more details and ensure it is in the correct category.
Can you sort files in ascending and descending orders?
no
only data can be sort from the excel sheet.. not in the file
How you plot a semi log graph on Excel?
To plot a semi log graph with gridlines in Excel, you will first need to input your data. Then, find the chart wizard tool and select XY scatter, and for chart type, select scatter with data points selected by lines.
What is alignment in Microsoft?
It is the positioning to something in relation to its surroundings. In Word, text can be aligned to the left, centre and right. In Excel things in cells can be aligned those ways, but also to the top of a cell and the bottom of a cell.
To move from sheet1 to sheet2, use the shortcut, CTRL+Page Down to move to the right page, or CTRL + PageUp to move to the left page.
What software is more powerful than Excel?
There is no straightforward answer to that. There are all kinds of different software, so it is hard to compare. Software can do all sorts of different things so they can be very good at one thing and useless at something else. So there would be software that can do much more sophisticated things than Excel, like help fly a plane, but cannot do spreadsheets. So in some ways it is more powerful than Excel and in other ways it isn't. So there is a huge range of powerful software out there that is more powerful that Excel, far too many to list.
What function in Microsoft Excel 2003 to write the amount in word?
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
Such a function does not exist for English. A function call BAHTTEXT will do it for the Thai language.
How do you write formula for 20 percent reduction of a retail price?
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
There are a few ways of doing it. You could get the price minus 20% of itself. If the price is in A2, you could use this formula in another cell:
=A2-A2*20%
If there is a 20% reduction the price will now be 80% of what it was. So another way would be to get 80% of the original price like this:
=A2*80%
What is the name of the temporary storage area in Excel?
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
It can be called the Clipboard.
Pie
Which Microsoft Excel version never existed?
There were no versions 1, 6 or 13. Office 2013 is classed as version 15.
Describe the division function in Excel?
If you want Excel to divide one number by another, use the "/" character. For example, if I want to divide 4 by 2 this is what I would enter in a cell:
=4/2
Excel will display the result of the division. In this case, 2. You can also divide using cell references. Lets say cell A1 contains the number 4 and A2 contains the number 2. Enter the following in the cell where you want the result:
=A1/A2
Again, Excel will display the result (2) in the cell where you entered the formula.
Three jobs that use spreadsheets could be:
1) Accountant- they use spreadsheets in their jobs to work out formulars quickly and easily!
2) Teacher- they use spreadsheets to keep track of how well progress childeren in their class are making.
3) Tax Payer- they use spreadsheets to calcutlate tax and create a chart for that information.
Hope that helps!
Can you create a chart without first using the chart wizard in excel?
If you select your range of cells and then press the F11 key, it will automatically create a chart using the default settings and put it into a separate sheet. You could then use the chart menu to adjust it. What format the chart takes will depend on what you have set as the default chart. As you are likely to need to adjust whatever chart is made, often it is better to just use the Chart Wizard anyway.
Enter the 7am as 7:00 and the 5pm as 17:00 and then subtract the 7:00 from the 17:00. If you put the 7:00 into cell B3 and the 17:00 in B4, then in another cell you could put the following formula:
=B4-B3
That will give you 10:00
If you then want to use the 10 in a calculation, say to work out pay based on the amount of hours worked, first you need to extract the 10 from the time. If the 10:00 was in cell B5 then your formula would be:
=HOUR(B5)
When first entering text in Excel its angle is degrees?
Text is typed in at zero degrees. Using the alignment settings, you can then slant it.
All angles are assumed to be in radians. There is no "degree mode" as in scientific calculators; instead, if you have an angle in degrees, you have to convert it to radians. For example, to get the sine of 30 degrees, calculate = sin(30 * pi() / 180). pi() / 180 is the conversion factor to convert from degrees to radians.
Check in the math functions - there is also a function that converts degrees to radians. Since I have Excel in Spanish here, I don't know the exact name in English, but I'll assume it is radians. If this is so, the formula can also be: =sin(radians(30)).
What is the formula to find a GPA in Microsoft Excel?
- Put total hours taken in cell A1.
- Put the total of all grade points in B1.
- Enter the following formula in C1: =B1/A1.
- Format C1 to display two decimal points.
- Observe your GPA in C1.
Why is iv 65536 the last cell in Excel?
It may seem random, but there is a basis for it. Computers work on the binary system, which is the mathematical number system that is base 2. If you start at 1 and keep doubling you will keep coming across numbers that are familiar in computing, including the amount of rows and columns in Excel 2003 and later versions:
1
2
4
8
16
32
64
128
256 (Column IV is the 256th column)
512
1024
2048
4096
8192
16384 (number of columns in Excel 2007 and onwards)
32768
65536 (number of rows in Excel 2003)
131072
262144
524288
1048576 (number of rows in Excel 2007 onwards)
How to calculate IC 50 value using Excel?
ED50V10 (Readme) is an Excel add-in for calculating IC50/EC50 values. Input your data in the left columns, and your results will be shown in the right half of the Excel table. To calculate IC50, input 50 in the "INTERPOLATE..." table (highlighted in blue), the result will be shown on the right (highlighted in green).
How can I convert an Excel Macro to work online as a webpage?
Just as some extra info, I tried doing a "save as webpage" and it just took the spreasdsheet and made it html. None of the data sources (which I did through the "data from web sources" tab) or the sorting feature of the "format table" tab.
