Michael is a Professor of Biology at DeVry University and has collected "30" largemouth bass from "4" separate lakes to get weight distributions,...

Michael is a Professor of Biology at DeVry University and has collected "30" largemouth bass from "4" separate lakes to get weight distributions, measure of girth, and length. He currently has the data saved in a Microsoft Excel workbook with data from each lake on a separate worksheet. Given the Professor's needs, summarize how he can consolidate this data to output average, minimum, and maximum weight, measure of girth, and length of largemouth bass across all "4" lakes also including visual output and trends.