Excel workbook test! help please

[Projfin]

Hey everyone,

So I was redirrected here by a friend for the ultimate excel information exchange. I've been a bit rough around the edges on some subjects lately, I've got this excel workbook test. Its very short, and believe it involves Vlookups, dropdown tabs etc.

I wanted to upload it and if people can complete it and send either a link back or email to Removed e-mail address - Moderator that would be great. I want to get different peoples perspectives and solving methods on this simple assignment. It shouldnt take more than 15-20 min for most people.

Thank you!

http://www.2shared.com/file/152bNSTj/Excel_Test.html

 

[VoG]

Look here http://www.contextures.com/xlFunctions02.html and here http://www.contextures.com/xlDataVal01.html

 

[Projfin]

Hi peter,

thanks for your reply, im looking over what you sent. were you able to take a look at the excel file which i linked? im not too sure if thats the exact method. do you think you can take a look? at least try to fill out information for one of the products?

thank you

 

[Smitty]

Welcome to the Board!

We don't really encourage asking folks to go off the board to file sharing sites. First off very few people will open a file from an untrusted source, second, of the remaining people who might, you limit yourself to the number of people who can see your situation at any given time.

Check out the link beneath my sig for how to post shots of your sheet. You'll get many more eyes on your question if the examples are here.

 

[Projfin]

hi chris thanks for your reply!

im not sure how to accomplish what you provided but ive taken screen shots of the questions and pages and inserted them in this post!

[/URL] [/IMG]

 

[sous2817]

How much are they paying you (us) to take the test?

Seriously if this is a test that you need to complete in order to get a job, you're doing yourself, your potential employer, and other applicants a huge disservice by having the people on this forum complete the test for you.

You may want to look at the sum, sumif, sumifs, and sumproduct formulas to get you started as all could be used in some way to help you get the answer you're looking for.

If I had to guess, the potential employer probably isn't looking for the "best" solution, just that you can come up with the correct solution.

Just my $.02 at least.

Good luck!

 

[Projfin]

hey sous,

no its not a test for a job, its a test for school actually, so you dont need to worry about anything like that but definitely thank you for your 0.02$ i appreciate it

 

[Smitty]

hi chris thanks for your reply!

im not sure how to accomplish what you provided but ive taken screen shots of the questions and pages and inserted them in this post!

Unfortunately, that's way too small for me to read. If you download the HTML Maker from the link, you'll find two files. The first is the HTML Maker add-in which converts your Excel selections into HTML code which the board will render. The second is a Word document with instructions on how it install and use it. The nice thing about it is that someone else can copy and paste your screen shot into Excel and work with it.

 

[sous2817]

If that's the case, then surely there is some kind of textbook, lecture notes, or something along those lines that should guide you in the right direction.

Give it a stab, and if you don't feel you're getting the correct answer, then post back what you tried and I'm sure people will be more than willing to help get your issue worked out.

 

[Projfin]

I tried downloading the html converter from Mrexcels link but i cant seem to get the html converter to work. i am using excel 2003 could that be wwhy? I am honestly very very stumped at this point and dont know what to do.... can anyone please help?

i mean i dont even see the mrexcel toolbar and nothing comes up when i right click. I would truly truly appreciate it so much if someone could help me with this...... I can send the file to your email..... Ive done vlookup for one product and month but my problem is i am not able to implement that for selecting either one of 3 products and any one of 12 months. such as the screenshot below.

[/URL][/IMG]