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.
500 Questions
How do you update a spreadsheet?
Asked by Wiki User
What you would do is:
On your computer when you get to your spreadsheet you press file: Open file and then it brings you to your documents and you press the document that has spreadsheet listed. When you got on to that you up date it how ever you want it to be!
How do you write formula in Excel to add 20 percent in cost price?
Asked by Wiki User
You could do it in a few ways. Assumung the cost price was in cell A2 and in another cell you wanted to show it having been increased by 20%, you could do any of these:
=A2*120%
=A2*1.2
=A2+A2*20%
Where is the bold button located on the home tab?
Asked by Wiki User
the bold button is the large button on the window between the Ff and the I
What helps analyze data by highlighting significant trends in data in Excel?
Asked by Wiki User
There are various ways, such as using gradients in Conditional Formatting or trendlines on charts and functions such as TREND and FORECAST.
The boxes at the top of a spreadsheet contain letters known as what?
Asked by Wiki User
The letters at the top of a spreadsheet are the column titles.
What action is used when Excel suggests the wrong range after clicking the SUM button?
Asked by Wiki User
Correct the range by dragging the appropriate cells in the worksheet. You could also type in the correct range.
How do you get Microsoft calculator?
Asked by Wiki User
first it is not illegal it is totaly legal.You can search Google how to get Microsoft calculator
and then click the first option.it will take about 40 seconds to download.IT WILL NOT APPEAR ON THE APPS ON YOUR COMPUTER.You have to go to the start button then write in Microsoft calculator.After you see it click and drag it over it will take 2 seconds to take in data.double click it then you will have a calculator pop out.Hope this was helpful
Example of a formula with a mixed cell reference?
Asked by Wiki User
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
A mixed reference is a cell reference that has either the column or row locked, but not both. So there are two forms, as follows:
$A2 or A$2
What Formula do you use for excel to see how many characters are in a cell?
Asked by Wiki User
The LEN function counts the amount of characters in a cell. For example:
=LEN(A3)
How do you centre worksheet titles across a range of cells?
Asked by Wiki User
Select the cell (or cells) where you want to centre (uk english) the title, right click and select format>alignment and select centre under horizontal (or you can use the menu at the top by selecting format>cells to access the same options). If you have a group of cells (eg with a number of columns below them) and you want a word centred above all of them, type the word you want in the first cell on the left, then repeat the above process and make sure you tick the checkbox where it says "merge cells"
What is the destination area or paste area in Excel?
Asked by Wiki User
It is called the Destination Area, and is where data is pasted after it has been copied or cut.
Is a bar that displays when the contents of an area may not be completely visible?
Asked by Wiki User
scroll bar
What is Lotus and Microsoft Excel?
Asked by Wiki User
Once upon a time Lotus 1-2-3 was far and away the best spreadsheet application available to PCs. A lack of development has left it a long way behind Excel in most respects, although as far as I know Excel still doesn't have 1-2-3's ability to base a chart on three dimensional data.
When can you format cells in Excel?
Asked by Wiki User
You format them whenever you need to. You can do it before putting data in, so that it is immediately formatted when it is put in, or you can put all your data in and do the formatting when you are finished, or you could format it as you are working. The options are always there, so you can use them at any time.
What does FV stand for in Excel?
Asked by Wiki User
It is a financial function. It returns the future value of an investment based on an interest rate and a constant payment schedule. So if you are paying in a set amount on a regular basis, like every month, and there is a fixed interest rate, it can work out how much your investment will be worth. See the link below for more details.
How do you get lines through your text when you type on word?
Asked by Wiki User
i believe that you can go onto shapes under insert and click on a line.
hope this helps :)
How are individual rows identified on a worksheet?
Asked by Wiki User
One answer to that is that you can have labels or headings at the top of columns or start of rows or beside particular figures as a way of identifying them. You could also mean the cell references that identify where the data is.
5 areas of learning where you can use spreadsheet?
Asked by Wiki User
any,you can even write and save text documents,save as .html,.txt insert pictures,links,connect to database
How do you make a cost table of the money you have to pay with Microsoft Excel?
Asked by Wiki User
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:
=SUM(B2:B20)
What are MS Excel advantages over MS Access?
Asked by Wiki User
If you work on a huge number of sets of data, which you have to sort, filter, group, and create subgroups on which to calculate or extract values such as averages, medians, or/and maximums, you are better off with Access. The process of creating groups within groups and then performing calculations on those is way more cumbersome in Excel. Excel on the other hand will be better for analyzing up to a few hundred records of data. The number of records, however, cannot exceed 65536 records (Excel 2003) or 1,048,576 (Excel 2007) . This is the maximum number of records Excel can handle. It also depends on the way you want to analyse the data. Databases are good for finding relationships in data. Spreadsheets are good for crunching numbers and doing "what if" analysis (e.g. scenario models). Because of a spreadsheets two dimensional design (rows and columns), the way users use spreadsheets as combined input/storage/output systems, and a spreadsheets inability to easily establish enforceable relationship rules between rows (or columns) on the same or different spreadsheets, the true multi dimensional nature of data can be hidden from the user and/or violated by incorrect data edits. This can make analysis of data difficult if the data is stored in a spreadsheet. It is easy to extract data from a database into a spreadsheet to take advantage of a spreadsheets unique data manipulation features (e.g. pivot tables, charts etc). The real questions should be "Where do I store the data I want to analyse?" The answer to that is definitely "In a database". You can make it safe there. Then choose the appropriate tool for the analysis you want to do.
What are two or more adjacent cells in a column or row or a rectangle group of cells called?
Asked by Wiki User
range
How do you title a spreadsheet excel?
Asked by Wiki User
Under File (upper left) drop down menu to Page Setup
Open Header/Footer Tab
Create header
Click OK
