Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell relation ships.
What are cell relationships and how do i use them.
|
#2
|
|||
|
|||
Hi
not a specific enough question, could be interpreted in many ways ... if this is a homework question, was there any more to the question than this? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Slukes" wrote in message ... What are cell relationships and how do i use them. |
#3
|
|||
|
|||
This is for my GNVQ ICT coursework.
We are creating spreadsheets for a customer of our choice. The mark scheme reads: M1 Ective use of software to: Make use of Cell relationships and Produce good quality printed copy showing both Data content, formats and formulae. Full version may be viewed @ http://www.edexcel.org.uk/VirtualCon..._unit2_B_I.rtf I dont really understand any of M1 it's all related to a spreadsheet except the first bit about multiple fields. If any one could help then it would be appriciated Thanks in advance Samuel Lukes "JulieD" wrote: Hi not a specific enough question, could be interpreted in many ways ... if this is a homework question, was there any more to the question than this? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Slukes" wrote in message ... What are cell relationships and how do i use them. |
#4
|
|||
|
|||
Hi
mmm, not a huge amount of detail ... it could be as basic as formulas (e.g. in C1, the formula =A1*B1) or in Sheet1 cell A1 the formula =Sheet2!A1 (or =SUM(Sheet2:Sheet5!A1) or as complex as data / validation - Debra Dalgleish has notes on her website at www.contextures.com/tiptech.html good luck! -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Slukes" wrote in message ... This is for my GNVQ ICT coursework. We are creating spreadsheets for a customer of our choice. The mark scheme reads: M1 Ective use of software to: Make use of Cell relationships and Produce good quality printed copy showing both Data content, formats and formulae. Full version may be viewed @ http://www.edexcel.org.uk/VirtualCon..._unit2_B_I.rtf I dont really understand any of M1 it's all related to a spreadsheet except the first bit about multiple fields. If any one could help then it would be appriciated Thanks in advance Samuel Lukes "JulieD" wrote: Hi not a specific enough question, could be interpreted in many ways ... if this is a homework question, was there any more to the question than this? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Slukes" wrote in message ... What are cell relationships and how do i use them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |