NO.1 CORRECT TEXTFormula Find the average score of all student ids without a zero homework score. Cell L2Use Function AVERAGEIFRange F7:F29Criteria: "0"Average_range: "Homework"Answer:Use the following steps to complete this task inExplana…

NO.1 What should be in a managed bean, rather than a backing bean? (Choose the best answer.)A. data that is used to decide if a field is shown as mandatory or notB. data that is used on another page in the task flowC. code that manipulates…