The undergraduate division of arts and sciences in a local university has an enrollment of 43 seniors in business, 30 in education, 15 in liberal arts and 250 in theatre. There are 75 juniors in business, 39 in education, 39 in liberal arts and 275 in theatre. The sophomore class has 125 in business, 72 in education, 101 in Liberal arts and 289 in theatre. The freshman class consists of 324 business majors, 123 education majors, 124 liberal arts majors and 300 theatre majors. Create a spreadsheet with the above information.
Using a function calculate the total number of freshmen, sophomores, juniors and seniors
Using a function, calculate the total number of students in each major