BUS308: Week 2 Excel Assignment

Excel File Edit View Insert Format Tools Data Window Help 76% Wed Feb 8 9:25 PM AutoSave OFF A A F Y C... 3BUS308 Wk 2 Assignment ~ Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share X 12 A ag Calibri (Body) General Conditional Formatting v Insert v Format as Table x Delete BIU BV $ ~ % 9 08 -00 Editing Analyze Paste Cell Styles v Format Data J15 X V fx A B C D E F G H K M N O P Q R 1 ID First Name Last Name Year Subject Final Grade 1 John Smith 1 IS 90 2 Joana Adams 3 AG BUS 37 3 Alice Green 4 Marketing 86 4 Bob Sutton 2 IS 92 5 Jesus Hernandez 1 Inerntaional 79 6 Maria Khamos 3 IS 95 7 Joseph Tan 1 Marketing 84 8 Steve Robinson 1 AG BUS 80 10 9 Tom Aber 4 Hospitality 78 11 12 13 14 15 Data Queries + Ready Accessibility: Good to go + 100% ASSiomaI VISY FEB 8 20 0 m 4 4. Excel File Edit View Insert Format ols AutoSave {F} 9 v BU8308 Wk 2 ASSIgnment v Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me x b r . . END v X 'Calibri (Body) A A E] 3 V General v H "d"'"a'F""a\"'\"9 V [a v ' v I U v [5C2 Format as Table v Editing Analyze 6 B [ V' (I) V Av $V 0/0 , I 0 1- CeIIStylesv l Data 1. What Is the avergae grade for all students 2. What is the number of students with grade 85 or less 3. What is the average grade for IS students 4. What is the maximum grade of marekting students 5. What is the grade percentrank of a student in year 2 and last name is "Sutton" 6' What is the average grade of students with first name starting with an "S" Queries Ready Accessibility: Good to go 100% v. \\