Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Solving an assessment using excel formulas

0

Hi,

I came accross an assessment to derive volume for the trasaction sales attached here is the excel sheet where there are 6 sheets, the instruction sheet has description of raw data, question sheet contains the actual assessment questions and the next following sheets are the raw data like transaction, production info, supplier info and FX data.

Can you help me derive the volumes and %volume? If possible the following questions.

I am curious to understand the metrics of sales in detail.

Thanks in advance

excel
MS Office Version: 2016
posted by: Dr Liss (rep: 26) on Tue Jul 18, 2023 at 10:35 am
Answer
Discuss

Discussion

Hi again Dr Liss.

Sorry but I'm not sure what you're asking...

The sheet Questions has lines which sound like a school exam or homework (which we generally don't do here). You say "Can you help me derive the volumes and %volume? If possible the following questions" and presumably pasted an image (but they cannot be uploaded on this Forum- look again at your Question).

Kindly edit your original question to explain better what you're trying to do and hopefully soemone can reply (maybe tomorrow in my case).
John_Ru (rep: 6142) Jul 18, '23 at 10:46 am
Did you solve this? 
John_Ru (rep: 6142) Jul 24, '23 at 1:04 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login