You can download the spreadsheet with problem statement from bere: n statement. The screenshot above represents a completed simulation model. Complete the function in antity: credit, you need to sort your cell references first by letter then by number. Also, if there are more eed to select value zero from the dropdown. For example, if there are four dropdowns and my answer is A7. tA3,A7,B2, and 0 as my answer. ction requires a name, then assume option "TEXT" provide the appropriate name. You can dawnload the spreadiheet with problem seatement from bere: You can download the spreadsheet with problem statement from hece. Consider Mnt Supply inc problem statement. The screenshot ab Cell C10 representing "Order Quantity" ilation model. Complete the function in IMPORTANT NOTE: To set full credit, you need to sort your cell number. Also, if there are more dropdowns then needed, you need to select value zero from the are four dropdowns and my inswer is A7. drogdowns then needed, you need to select value zero from the dropdown. For example, if there are four dropdowns and my answer is A B2 and A3, then 1 need to select A3,A7,B2, and 0 as my answer. IMPORTANT NOTE 2: If the function requires a name, then assume option "TEXT" provide the appropriate name. You can download the spreadsheet with problem statement from bere: n statement. The screenshot above represents a completed simulation model. Complete the function in antity: credit, you need to sort your cell references first by letter then by number. Also, if there are more eed to select value zero from the dropdown. For example, if there are four dropdowns and my answer is A7. tA3,A7,B2, and 0 as my answer. ction requires a name, then assume option "TEXT" provide the appropriate name. You can dawnload the spreadiheet with problem seatement from bere: You can download the spreadsheet with problem statement from hece. Consider Mnt Supply inc problem statement. The screenshot ab Cell C10 representing "Order Quantity" ilation model. Complete the function in IMPORTANT NOTE: To set full credit, you need to sort your cell number. Also, if there are more dropdowns then needed, you need to select value zero from the are four dropdowns and my inswer is A7. drogdowns then needed, you need to select value zero from the dropdown. For example, if there are four dropdowns and my answer is A B2 and A3, then 1 need to select A3,A7,B2, and 0 as my answer. IMPORTANT NOTE 2: If the function requires a name, then assume option "TEXT" provide the appropriate name