You are Here: Home

# Edexcel GCE Applied ICT Unit 3- June 2011 Exam watch

1. I have a strong feeling they will f*** this paper up, just like May 2010.
2. (Original post by simba2011)
hey, has this post by squadredfox been removed, coz i cant seem to find it?!
Yeah it has been removed
3. (Original post by simba2011)
yeah im supoosing thats right coz thats wat most of use. what max profit did u get using that formula and the spreadsheet?
I am getting \$536,149.01.
4. Hey everyone .. Can anyone what formula we have to use in Advertising Sheet?? =\
5. (Original post by Gorgeous devil)
Hey everyone .. Can anyone what formula we have to use in Advertising Sheet?? =\
6. (Original post by Gorgeous devil)
Yeah it has been removed
oh crap. why was it removed? was it wrong or smthing?
7. (Original post by Gorgeous devil)
Yeah it has been removed
oh crap. why was it removed? was it wrong or smthing?
8. (Original post by simba2011)
oh crap. why was it removed? was it wrong or smthing?
I am having it. I can mail them to you
9. Heyy how come you guys are getting the profit in 190,000 and I am getting 536,000 =\

What formulas have you used for Total Costs, Total Revenue and Total Profits??

I am using =SUM(Totals!E39:P39) for Total Costs.
=SUM(Totals!E40:P40) for Total Revenue
=SUM(Totals!E41:P41) for Total Profits

Is this wrong??? =\
10. (Original post by simba2011)
hey, i just saw the questions you have posted. they've been a great help. if you could mail the answers to me it would be better. ive worked on the model and come up with various profits and different ways of getting them. maybe we could brainstorm on the same
Hey hope it helps...
Edexcel Unit 3 activity 3.docx

Anyone else need ideas on activity 3 showing profits & how to get there with formula.. feel free to save it! .. :]
Hey hope it helps...
Edexcel Unit 3 activity 3.docx

Anyone else need ideas on activity 3 showing profits & how to get there with formula.. feel free to save it! .. :]
What formulas have you used for Total Costs, Total Revenue and Total Profits??

I am using =SUM(Totals!E39:P39) for Total Costs.
=SUM(Totals!E40:P40) for Total Revenue
=SUM(Totals!E41:P41) for Total Profits

Is this wrong??? =\
12. (Original post by Gorgeous devil)
What formulas have you used for Total Costs, Total Revenue and Total Profits??

I am using =SUM(Totals!E39:P39) for Total Costs.
=SUM(Totals!E40:P40) for Total Revenue
=SUM(Totals!E41:P41) for Total Profits

Is this wrong??? =\
When u see my work.. just look at the formulas at the top.. hmm yeah yeah i think your formulas look fine!

Except .. when you work out PROFIT : its TOTAL REVENUE - TOTAL COST .. So will be =SUM(G7-G6)

x
13. (Original post by Gorgeous devil)
What formulas have you used for Total Costs, Total Revenue and Total Profits??

I am using =SUM(Totals!E39:P39) for Total Costs.
=SUM(Totals!E40:P40) for Total Revenue
=SUM(Totals!E41:P41) for Total Profits

Is this wrong??? =\
seems to be ok. my e-mail went all haywire, as did my messenger. ill talk to the class and let u know bout the feedback. pls ask ur teacher as well and lemme know
14. Hi can you also email the answers to me please if it is not too much of a problem?
I'm really struggling with this exam and not sure how to prepare properly. Considering its only a couple of weeks away I'm worried. In particular, this is the if function. The importing and basic printing is fine but I'm not sure about the advertising bit. Advice needed please!

Sure mate. Look at the PDF's that I posted. They take you through it, step by step.
When u see my work.. just look at the formulas at the top.. hmm yeah yeah i think your formulas look fine!

Except .. when you work out PROFIT : its TOTAL REVENUE - TOTAL COST .. So will be =SUM(G7-G6)

x
Thanx alot =)
Yeahh I got it now
17. (Original post by simba2011)
seems to be ok. my e-mail went all haywire, as did my messenger. ill talk to the class and let u know bout the feedback. pls ask ur teacher as well and lemme know
Hey whatever I have done is right except the Profits formula it should be =SUM(G7-G6).

Suree .. Let me know
Hey... It sounds similar to what we have .. And probably get the same answers but we've been given =IF(And(Values!\$B7="Yes",IF(Valu es!B \$21="Yes",Advertising!B7,0),0) ... Which works!

I'm also opening 4 shops with the highest ratings for profit - and three advertisement methods!..
I opened around 3 shops (along with Falmouth) and only two advertising methods. so yeah, I guess we're on the right track there
19. (Original post by Gorgeous devil)
Heyy how come you guys are getting the profit in 190,000 and I am getting 536,000 =\

What formulas have you used for Total Costs, Total Revenue and Total Profits??

I am using =SUM(Totals!E39:P39) for Total Costs.
=SUM(Totals!E40:P40) for Total Revenue
=SUM(Totals!E41:P41) for Total Profits

Is this wrong??? =\
oh, you got the total profits from the Totals sheet? I got mine off the Monthly Figures. my formulas are:

=('Monthly Figures'!N14) for Total Costs
=('Monthly Figures'!N15) for Total Revenue
=('Monthly Figures'!N16) for Total Profit

I think you need to get them off the Monthly Figures; if not, then why would they bother putting that information in the spreadsheet? You need a monthly figure to calculate total profit. each month has their own profit, that's why we need to total it.
20. (Original post by deusmaster)
oh, you got the total profits from the Totals sheet? I got mine off the Monthly Figures. my formulas are:

=('Monthly Figures'!N14) for Total Costs
=('Monthly Figures'!N15) for Total Revenue
=('Monthly Figures'!N16) for Total Profit

I think you need to get them off the Monthly Figures; if not, then why would they bother putting that information in the spreadsheet? You need a monthly figure to calculate total profit. each month has their own profit, that's why we need to total it.
I agree with you here. I think a few people on here are (probably not purposefully) making this a lot harder than it should be.

### Related university courses

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 2, 2012
The home of Results and Clearing

### 4,002

people online now

### 1,567,000

students helped last year
Today on TSR

### IT'S TODAY!

A-level results chat here

### University open days

1. Bournemouth University
Fri, 17 Aug '18
2. University of Bolton
Fri, 17 Aug '18
3. Bishop Grosseteste University
Fri, 17 Aug '18
Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE