Part 1:

Two brothers, Brother One, age 11, and Brother Two, age 14, earn $265.45 and $433, respectively. They agree to pool earnings and equally share their boot with a younger sister.

Requirements: Develop two (2) unique methods to determine how much each sibling receives(distribution). Format: currency/2 decimals.

Part 2:

Requirement1: Formatting: O16 - O18, P16 - P18, number, 2 decimals; Q16 - Q18, R16 - R18, percent, 4 decimals.

Requirement2: Cells N15 - R18: Format: Border: style: bold lines with inside and outline markings.

Requirement3: Calculations: Using Excel functions, where applicable, develop operations to complete the following calculations. In cells P16 - P18, summarize each sibling's distribution (Part 1) and Aug 1 Balance. In cells Q16 - Q18, for each sibling, create an algorithm to determine the percent each distribution is of Sept 1 balance. Remember: Calculations must not contain absolute values.

no programming needed, only excel formuals