Which one of the statements below is true? A. The AND function can manipulate large amounts of data into smaller amounts that you can then review, manually, line by line, for whatever it is you are looking for. B. The AND function helps connect to third-party applications to import data. C. The AND function allows you to identify if all of a large number of terms are true or false, saving the time of reviewing each line and checking manually. D. The AND function helps troubleshoot equations and formulas already in Excel.

1. alwaysrain irrigation, inc. would like to determine capacity requirements for the next four years. currently, two production lines are in place for making bronze and plastic sprinklers. three types of sprinklers are available in both bronze and plastic: 90-degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. management has forecast demand for the next four years as follows: both production lines can produce all the different types of nozzles. the bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. the plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. three bronze machines and only one injection molding machine are available. what are the capacity requirements for the next four years? (assume that there is no learning.)