Jennienarwin
Badges: 0
Rep:
?
#1
Report Thread starter 7 years ago
#1
Okay so tbh I really hate ICT and I have to do ICT as part of my law course.I just need help on these questions please.It's only a pass and a fail and i have been stuck on this for ages!You know those subjects you don't understand the point of? Yeah that-.-. I have 2 other assignments due and I dont have time for this.My teacher is no help either.-.- Thank you so much! I've done most of them. http://m.flickr.com/#/photos/[email protected]/11277406094/
TASK 9
In the column Fuel Economy column, write a VLOOK Formula to look up using the codes from the Rating table.
This task provides evidence for (LO2.3)TASK 10
In the column Fuel Economy tax column, write a VLOOK Formula to look up the fuel rating using the Fuel table TASK 16
In the column for cost of fuel economy tax, calculate the Cost of the fuel economy tax based in
the list price of the car. Enter your calculations in the Fuel Economy Tax Column
In the column for Total payable, calculate the total payable by adding the List Price to the Cost of fuel economy tax
Attached files
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#2
Report 7 years ago
#2
(Original post by Jennienarwin)
Okay so tbh I really hate ICT and I have to do ICT as part of my law course.I just need help on these questions please.It's only a pass and a fail and i have been stuck on this for ages!You know those subjects you don't understand the point of? Yeah that-.-. I have 2 other assignments due and I dont have time for this.My teacher is no help either.-.- Thank you so much! I've done most of them. http://m.flickr.com/#/photos/[email protected]/11277406094/
TASK 9
In the column Fuel Economy column, write a VLOOK Formula to look up using the codes from the Rating table.
This task provides evidence for (LO2.3)TASK 10
In the column Fuel Economy tax column, write a VLOOK Formula to look up the fuel rating using the Fuel table TASK 16
In the column for cost of fuel economy tax, calculate the Cost of the fuel economy tax based in
the list price of the car. Enter your calculations in the Fuel Economy Tax Column
In the column for Total payable, calculate the total payable by adding the List Price to the Cost of fuel economy tax
Hi I might be able to help you but when I clicked on your link it just took me to the flickr sign in screen - I could not see the layout of your spreadsheet!

Are you able to upload your example spreadsheet to a post here (as an xls or xlsx attachment)?

Have you used VLOOKUP formulas before?
0
reply
Jennienarwin
Badges: 0
Rep:
?
#3
Report Thread starter 7 years ago
#3
(Original post by davros)
Hi I might be able to help you but when I clicked on your link it just took me to the flickr sign in screen - I could not see the layout of your spreadsheet!

Are you able to upload your example spreadsheet to a post here (as an xls or xlsx attachment)?

Have you used VLOOKUP formulas before?
Ohh sorry about that..I'll upload a picture instead if that's okay. And no we haven't learnt that, my teacher is absolutely useless.-.- Thank you so so much for your help x
Attached files
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#4
Report 7 years ago
#4
(Original post by Jennienarwin)
Ohh sorry about that..I'll upload a picture instead if that's okay. And no we haven't learnt that, my teacher is absolutely useless.-.- Thank you so so much for your help x
Hi, it looks from the picture that you're using Microsoft Works rather than Excel - is that correct?

I haven't actually used Works before although it looks like I have a copy installed on my laptop from ages ago - I'm hoping it works very similar to Excel!!

Does your file contain a Ratings table in it already?
0
reply
Jennienarwin
Badges: 0
Rep:
?
#5
Report Thread starter 7 years ago
#5
(Original post by davros)
Hi, it looks from the picture that you're using Microsoft Works rather than Excel - is that correct?

I haven't actually used Works before although it looks like I have a copy installed on my laptop from ages ago - I'm hoping it works very similar to Excel!!

Does your file contain a Ratings table in it already?
Lol yes that's right but I just download excel cause it'll be much easier.Sorry about that,hope it's much more clearer now.
Attached files
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#6
Report 7 years ago
#6
(Original post by Jennienarwin)
Lol yes that's right but I just download excel cause it'll be much easier.Sorry about that,hope it's much more clearer now.:)
OK, so let's start with the 1st question - you need a VLOOKUP formula to bring back the Fuel Economy in column D for each rating code in column C of the first sheet.

In Excel you need to put a formula like this in cell D5:
=VLOOKUP(C5,Sheet2!$A$3:$B$6,2,F ALSE)
You can then copy this formula into the cells below in the same column.

I suggest you have a look at the VLOOKUP function in the Excel help to see what it's doing - if you use the Insert Function facility it will actually insert a template for you and let you select the cells that go into the function.

Basically VLOOKUP takes 4 inputs: the thing you're looking up (e.g. the value "A" or the cell reference of that value like C5); the table where you get the values from (in this case range A3:B6 on the Sheet2 worksheet); the column containing the value you want (in this case column 2); and a value of FALSE (for an exact match) or TRUE (if you're trying to find a closest match in a range of sorted numbers).

Give this a go to start with in Excel and see if you can get it to work, then you can experiment a bit
0
reply
Jennienarwin
Badges: 0
Rep:
?
#7
Report Thread starter 7 years ago
#7
(Original post by davros)
OK, so let's start with the 1st question - you need a VLOOKUP formula to bring back the Fuel Economy in column D for each rating code in column C of the first sheet.

In Excel you need to put a formula like this in cell D5:
=VLOOKUP(C5,Sheet2!$A$3B$6,2,FALSE)
You can then copy this formula into the cells below in the same column.

I suggest you have a look at the VLOOKUP function in the Excel help to see what it's doing - if you use the Insert Function facility it will actually insert a template for you and let you select the cells that go into the function.

Basically VLOOKUP takes 4 inputs: the thing you're looking up (e.g. the value "A" or the cell reference of that value like C5); the table where you get the values from (in this case range A3:B6 on the Sheet2 worksheet); the column containing the value you want (in this case column 2); and a value of FALSE (for an exact match) or TRUE (if you're trying to find a closest match in a range of sorted numbers).

Give this a go to start with in Excel and see if you can get it to work, then you can experiment a bit
Thank you,you're actually amazing!But the first formula says 'Error'?
Attached files
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#8
Report 7 years ago
#8
(Original post by Jennienarwin)
Thank you,you're actually amazing!But the first formula says 'Error'?
My version of Excel (Excel 2007) doesn't seem to like your file very much - it keeps forcing me
to repair the file whenever I open it!! I don't know if this is removing anything that you have typed in, but the value showing in cell D5 is coming up as #VALUE! If this is what you meant, you can just type a formula over the top of it.

If you had some other error, can you save your file as a standard Excel file (xls or xlsx) - you should have a Save As option in Excel that will let you do this - before uploading it here?

Thanks
0
reply
Jennienarwin
Badges: 0
Rep:
?
#9
Report Thread starter 7 years ago
#9
(Original post by davros)
My version of Excel (Excel 2007) doesn't seem to like your file very much - it keeps forcing me
to repair the file whenever I open it!! I don't know if this is removing anything that you have typed in, but the value showing in cell D5 is coming up as #VALUE! If this is what you meant, you can just type a formula over the top of it.

If you had some other error, can you save your file as a standard Excel file (xls or xlsx) - you should have a Save As option in Excel that will let you do this - before uploading it here?

Thanks
Yep I've got it! Thank you soo much for your help x
0
reply
davros
  • Study Helper
Badges: 16
Rep:
?
#10
Report 7 years ago
#10
(Original post by Jennienarwin)
Yep I've got it! Thank you soo much for your help x
No problem - glad you've got it sorted now
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Do you have the space and resources you need to succeed in home learning?

Yes I have everything I need (253)
57.11%
I don't have everything I need (190)
42.89%

Watched Threads

View All