Project Description:
You work in the Admissions Office for a small regional
university in Massachusetts Your assistant entered a list of
college applicants for the Fall 2021 semester. You determine if a
student qualifies for early admission or early rejection based on
SAT and GPA. After determining the immediate admissions and
rejections, you calculate a total score based on SAT and GPA to
determine regular admissions and rejections.
- Exp19 Excel Ch07 Ml1 Admissions Project Description You Work In The Admissions Office For A Small Regional University I 1 (119.16 KiB) Viewed 196 times
You want to insert a map that depicts admissions by state.
Display the Map worksheet. Create a map chart from the range A1:B5.
Change the chart title to Admissions by
State. Display the Format Data Series task pane and select
Only regions with data as the map area.
21
You want to place the top-left corner of the map in cell C1 and
change the map size.
Cut the map and paste it in cell C1.
Set 3.12" height
and 3.26" width for the map.
22
Create a footer with your name on the left side, the sheet name
code in the center, and the file name code on the right side on all
sheets.
C15 fx B с D E F G 1 State 2 Massachusetts 3 Vermont 4 New Hampshire 5 Connecticut 6 Admitted 30 17 12 6 7 8 9 10 Admissions by State Admi 11 12 13 14 15 16 30 17 6 18 19 20 21 Powered by Bing GeoName Me TomTom 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44