1INSTRUCTIONS: Insert Data Validation - Dropdown list, in cell B3-B9 Create a "List of items" referencing the Bid Amount from Worksheet 2. 2INSTRUCTIONS: Create a VLOOKUP formula to display Potential Revenue in cell C3 Using data from "Worksheet 2", create a formula in cell C3 that will display the Potential Revenue according to the Bid Amount in cell B3. 3INSTRUCTIONS: Create a VLOOKUP formula to display Status in cell D3 Using data from "Worksheet 2", create a formula in cell D3 that will display the Won/Lost Status according to the Bid Amount in cell B3. 4INSTRUCTIONS: Conditional Formatting Use conditional formatting to fill the row with "Lost" status, in gray. Formula = Apply to range columns B3 to D9