B D C H E G Instructions: Use the Round function in cell G8 to round the part price to the nearest dollar. Afterwards, use the fill handle to fill in the remaining cells in the column. E 3 3 Part ID # Part Name Part Price Part Price (Rounded Stock Amount 170073 Battery $ 20.46 39 170112 LCD $ 7.79 35 170172 Front Panel Glass $ 14.51 18 171288 Camera Bezel $ 10.16 38 171904 Speaker Mesh $ 9.80 6 171969 Home Button $ 9.68 10 172964 SIM Card Eject Too $ 3.33 3 173135 Rear Panel Glass $14.94 22 173168 Power Button $ 4.78 41 173300 Screw Set $ 7.49 28 173541 Dock Connector $ 17.65 3 174479 Sensor Cable $ 19.70 25 175533 Speaker Enclosure $ 15.36 3 175885 Rear Camera $ 17.84 29 175904 Volume Button $ 5.18 5 176159 Earpiece Speakers 9.91 176415 SIM Card Tray $ 5.21 39 176521 Volume Control Ca $ 14.83 12 177282 Front Camera $ 14.88 14 177367 Wi-Fi Antenna S 15.23 9 177614 Vibrator $ 10.35 45 178684 Contract Clip $ 5.55 8 179020 Cellular Antenna $ 10.08 179130 Vibrate/Ring Switc $ 5.15 5 40 34 5