Microsoft Excel

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

It will just put 2000 into a cell. It is technically a formula, as it starts with an equals sign, but there is no calculation of any kind involved.

If you know what the cells are, it doesn't really matter what kind of reference it is. You just need consistency in the cells you are referring to when you are working on corresponding cells in different sheets. The actual references can be relative, mixed or absolute.

yes, just add an hyperlink in your presentation to the excel spreadsheet on your PC, if you cannot find it, save a copy to the desktop, then link to it there. To insert a hyperlink in PP click on insert/hyperlink.

Yes. It is down to the computer's memory as to the amount of sheets that you can have added.

Text functions are the answer. I am not clear if you mean that you wish to trim some trailing spaces [See =TRIM()], or if you know how many 'last characters' you need to 'cut', in which case you would need to discover the length [See =LEN()] and then obtain the left most characters [=LEFT()] using the length - the number of characters you are looking to cut. If this is a one off, you could use Data / Text to columns. Regards, Stuart Tayler

First select the cell(s) you want to wrap text in. The go to the format menu and click Cells, or press Ctrl-1, and then Alignment and the tick the Wrap text box. Text can then stay in a cell and wrap around into it onto more than one line and staying within one cell.

If each pair refer to the same item, then you could multiply each quantity by its corresponding price to get totals for each item, and then add these together to get an overall total.

So if the quanity of product A was in B2 and its price in B3, then in B4 you would put the following formula:

=B2*B3

If you copied that along row 4, assuming the other quantities were in row 2 and prices in row 3, then you would get the total prices for each. If the totals went from B4 to X4, then in Y4, you would have the following formula to get the overall total:

=SUM(B4:X4)

You could also use the SUMPRODUCT function in Y4, without needing to get the individual totals. You would use it in this form:

=SUMPRODUCT(B2:X2,C2:X2)

The names of functions and cell references will be converted to uppercase. Regular text that may be used in a function will not be changed. So if you typed the first version below, Excel would convert it into the second version:

=find("a",b5)

=FIND("a",B5)

--

To change from lower to upper case - EXAMPLE If the text to be changed is in B2 then in a cell preferably next to it place =UPPER(B2) the text in cell A2 will now be all uppercase. do this with each cell by copying the formula down for instance and this will change the case in the "B" Column to uppercase in the "A" column. However, you now have 2 columns with the same text , one in upper case the other in lower (its duplicated) if you want to copy the uppercase to replace the lowercase simply select all those cells in the "A" Column and paste in to the "B" column as "value" - Value option is found in the paste menu by right clicking the target cell. This can replace a huge of cells in one go -

For lower case use =LOWER (cell reference) or for names all in one cell that need to be fist letter capitalised on each name use =PROPER(B2)

left, right, or center

Yes it is.

Using Excel you use the PMT function to calculate EMI calculations. The PMT function takes the following format, where the items enclosed in square brackets are optional:

=PMT(Rate, NumPer, Pv,[Fv],[Type])

Rate is the percentage rate for the loan paid for each period. If you are using an annual rate with monthly payments you need to divide the annual rate by 12.

NumPer is the number of periods of payments for the loan. A one year loan with monthly payments would have 12 periods of payment.

Pv is the present value of the loan.

Fv is the future value of the loan which will be 0 if left out.

Type is 1 or 0 determines whether payments are made at the start of each period or at the end of each period. 1 is for the start of the period and 0 for the end, which is what it will be if you don't put anything in.

As an example, if you had a loan for 1000, paying monthly instalments over a year at an annual rate of 8%, then the formula would be as follows:

=PMT(8%/12,12,1000,0,0)

The result will be -86.99. If you want to show the value as a positive, put a minus sign before the PMT and after the equals sign or put it before the 1000.

enter your costs in a column and sum it at the bottom (A1+B1+C1...)

enter your sales in a column and sum at the bottom (A2+B2+C2...)

take the revenue cell (sum of sales) and minus the sum of the costs

eg.

K1=J2-J1

this is you profit

Detail sheets

You could use the COUNTIF function. If you have a column with the words yes and no in them, say in the cells from C2 to C25 and wanted to know how many contained yes and how many contained word, then you would use the following formulas:

=COUNTIF(C2:C25,"Yes")

=COUNTIF(C2:C25,"No")

It is on the Formulas tab, in the Auditing section. To hide or show formulas you can also just press Ctrl and the `key, which is the key beside the 1 key on your keyboard.

Boaz and Jachin

You can do it both ways.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

No. You can learn either one of them first, or even just learn one of them. There are a lot of things that both can do, so when you do learn one, it can help in learning the other. As they are designed for different jobs, Excel for spreadsheets and Access for databases, it doesn't matter which you learn first.

Cell

Some formatting can be lost, yes. (Mostly because Microsoft programs do not follow their own standards!)

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

Microsoft Excel is used to create and modify spreadsheets.

1. metamorphic,igneous,sedimentary

2.igneous

3.pumice

4.geodes

5.marble and quartzite

6.forms sedimentary rocks

7.igneous

8.sediments

9.ripple marks

10.metamorphic rock

11.conglomerate,limestone,breccia,sandstone

12.foliated

13.sedimentary rocks

14.black/green

15.metamorphic and sedimentary

16.clastic

17.intrusive

18.gneiss,slate,quartzite,anthracite

19.sedimentary

20.pumice,basalt,obsidian,rhyolite

21.non-clastic

22.anthracite

23.extrusive(basalt)

24.lithification

25.cementation

26.conglomerate

27.breccia

28.shale

29.caves-stalactites

30.corals

YOUR WELCOME!!!! (The worksheet it right in front of me, i got a 100 percent so your all set!!) :D glad i could help

Excel is a 'spreadsheet' program and spreadsheets are used for mathematical equations.

Whether you just want to add up rows/columns of numbers or do advanced calculations.

eg: if column 1 total is subtracted from column 6 total, what is the answer? or

if this particular information is a percentage of that information, what percentage is the remaining information in relation to column X.

Many and varied calculations can be done in relation to any information.

The index between relations databases is the common thread which ties them together. So if you have a column in each database called 'idnum' and IDNUM:001 in the first database corresponds with data in IDNUM:001 in the second database, the two databases are relational and IDNUM is their index.

They are what they say.

A row is a line of cells horizontally and a column is a vertical row of cells.