CANDL ter 3 Summarize data that meets specific conditions Open the CreateConditional Formulas workbook in Excel, and then following tasks: and then performs value in F3 is gee if not, display Not Use Open tasks: 1. In cell G3, create an IF formula that tests whether the value in F or equal to 35,000. If it is, display Request discount; if not, disp available. 2. Copy the formula from cell G3 to the range G4:614. 3. In cell 13, create a formula that finds the average cost of all expense F3:F14 where the Type column contains the value Box. 4. In cell 16, create a formula that finds the sum of all expenses in cells F3 where the Type column contains the value Envelope and the Destination column contains the value International. Set iterative calculation options and enable or disable automatic calculation Open the Setiterative Options workbook in Excel, and then perform the follow tasks: 1. On the Formulas tab, in the Calculation aroun click the Calculation button CANDL ter 3 Summarize data that meets specific conditions Open the CreateConditional Formulas workbook in Excel, and then following tasks: and then performs value in F3 is gee if not, display Not Use Open tasks: 1. In cell G3, create an IF formula that tests whether the value in F or equal to 35,000. If it is, display Request discount; if not, disp available. 2. Copy the formula from cell G3 to the range G4:614. 3. In cell 13, create a formula that finds the average cost of all expense F3:F14 where the Type column contains the value Box. 4. In cell 16, create a formula that finds the sum of all expenses in cells F3 where the Type column contains the value Envelope and the Destination column contains the value International. Set iterative calculation options and enable or disable automatic calculation Open the Setiterative Options workbook in Excel, and then perform the follow tasks: 1. On the Formulas tab, in the Calculation aroun click the Calculation button