Paste V Av Merge & Centre v $ v % .00 0 Conditional Format Formatting as Table Cell Styles Format v Sort & Filter 12 A B C D E F G H - K M Quiz 2 Quiz 3 Test 1 Total In Decimal % Grade Quiz 1 20 Test 3 100 20 20 100 1 Name 2 Total Marks 3 Sioux 4. Abdi 5 Chin Test 2 100 59 68 15 15 20 81 99 98 19 14 20 92 16 16 19 55 95 87 99 15 18 20 19 81 79 96 99 16 20 96 6 Tyrone 7 SheliaDawn 8 Mo 9 Gigi 10 19 15 20 98 68 100 81 11 14 19 78 29 11 12 13 14 15 AutoSave OFFE ACC202_T2_2020_Excel_Practice_W3 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Ai = = = Wrap Text General Paste B I U V av Av Merge & Centre $ % ) Conditional Format Formatting as Table H9 X fx A B D E F G H J No 1 Quiz 1 Quiz 2 Quiz 3 Test 1 Test 2 20 20 20 100 100 99 15 20 81 Test 3 100 59 68 55 15 14 20 92 98 19 16 19 87 Name 2 Total Marks 3 Sioux 4. Abdi 5 Chin 6 Tyrone 7 Shelia Dawn 8 Mo 9 Gigi 10 Average 11 16 15 95 96 20 18 99 81 19 20 96 99 16 15 14 79 68 19 20 98 100 11 19 78 29 81 12 13 Calibri (Body) VA 11 = = = 2 aby Wrap Text Percentage PHY PPA Insert v I Delete Format Paste B n avAv = = = + E Merge & Centre $ %) Conditional Format Cell Formatting as Table Styles 15 - X fx A B D E F - J K L % of Sales 1 Unit Sales For 2019 2 Sales Target for January to June for the year 2019 was 2435 units 3 Sales Reps Jan Feb Mar Apr May Jun Total 4 Sioux 109 133 378 527 243 190 5 Jo 188 440 472 172 271 203 6 Mo 372 122 538 143 386 201 7 Phil 145 293 169 193 325 424 8 Pham 457 313 385 430 374 158 9 Shelia 367 494 146 429 540 10 Ty 211 197 274 252 318 521 11 12 13 14 15 458 Calibri (Body) V 11 Ai ab Wrap Text General V V Paste .00 V E v Av C $ v % 9 Merge & Centre v Conditional Format Formatting as Table S1 H2 A B C D E F G . K L 1 Store Total 2 Second Ave 3 Broadway 4 Coho Grocery 5 Third Ave January February March April May June $ 10,456 $ 15,478 $27,412 $15,124 $56,617 $24,307 $ 53,211 $ 46,825 $10,253 $41,640 $52,462 $52,341 $ 33,672 $ 17,356 $55,215 $23,829 $58,223 $52,146 $ 55,191 $ 25,016 $41,205 $11,333 $50,526 $50,356 $ 63,258 $ 62,148 $53,272 $52,485 $18,789 $58,216 $ 30,435 $ 44,094 $49,234 $45,223 $56,543 $52,230 $ 48,954 $ 47,099 $27,112 $48,048 $23,212 $52,852 6 Fifth Store 7 Fourth Street 8 Main 9 10 11 12 13 14 15