5. PRICE_CATEGORY in column AA, defined as:

a. Basic if Extended Price in column O is less than $75

b. Premium if Extended Price is at least $75 but less than $200

c. Luxury if Extended Price is at least $200 or more

6. PROMOTION_CODE in column AB, a text field with the format X99, where X is the first letter of the code in column L (Offer_ID), and 99 is the last 2 digits of the ship date year. Hints: LEFT(text, n) function extracts the first n characters from a text. The RIGHT (text, n) extracts the last n characters from a text. & uses to connect two parts of texts together.

7. SEASON in Column AC, defined as:

a. Spring if the Order Date is between Mar 1 and May 31.

b. Summer if the Order Date is between June 1 and Aug 31.

c. Fall if the Order Date is between Sept 1 and Nov 30.

d. Winter if the Order Date is between Dec 1 and Feb 28.

8. FISCAL_YEAR of the Order Date in Column AD, corresponding to the Fiscal Year dates of July 1 to June 20, written as FYXXXX where XXXX is the date. For example, the current fiscal year, which began on July 1, 2022, and will end on June 30, 2023, would be written as "FY2023". An Order Date of April 1, 2019, would be FY2019. An Order Date of Dec 12, 2019, would be FY2020. Hints: You may use the IF() function for that. In general, if the month of order date is less than 7 (until June), the fiscal year is the calendar year. Otherwise (Jul to Dec), the fiscal year is the Page 3 | 4 calendar year plus one. Translate the above statement into an excel formula, you will get the fiscal year. Once you get the fiscal year, add FY in the front.