Questions about my Excel homework

Mawwe

New Member
Joined
Nov 4, 2017
Messages
1
Hi! I study use of Excel in my university, but I've encountered insurmountable challenge in my latest homework. No previous teaching material or guidelines provide any kind of help in this task, and I wonder if someone with more brain than me can give a little hint where to start at least. I understand that I can't upload worksheet, but pictures should be be okay, right? If someone can give help, I would be so grateful! :)

https://imgur.com/a/zBkkE

To add - I got task 1 right, but task 2-4 are beyond my intelligence.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
instead of just posting a pic, which many of us are unable or unwilling to get, try explaining what you need to do, along with what you tried, and what didn't work.
Many members here are against doing homework for students that have shown no effort to solve the question themselves
 
Upvote 0
I understand that I can't upload worksheet


You can upload the workbook to a hosting site like Drop Box and paste a link here.

 
Last edited:
Upvote 0
@ Worf, not all members are willing - or able - to access file hosting sites, that's why I asked for the OP to share their info here :)
 
Upvote 0
@ Worf, not all members are willing - or able - to access file hosting sites, that's why I asked for the OP to share their info here :)

I can't see any reason why the OP can't do both :biggrin:
 
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,262
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top