A B с D m F F G 1 1) Fill in the score with random grades between 60 and 100 2
3) Create a Formula Name called GradeChart 3
3) Using a lookup command fill in the grade value 4
4) the chart data has a bad value for this to work. Please correct
5 Grade Chart 6 Name Score Grade F 65 7 Fred1 D 65 8 Fred2 с 70 9 Fred 3 80 DO 90 A+ 100 10 Fred 4 11 Fred 5 12 Fred 6 13 Fred 7 14 Fred 8 15 Fred 9 16 Fred 10 17 Fred 11 18 Fred12 19 Fred 13 20 Fred 14 21 Fred 15 22 Fred 16 23 Fred 17 24 Fred 18 25 Fred 19 26 Fred 20 27

4. a1. vince owns a television repair shop that is insured undera commercial package policy. the policy includes thebuilding and personal property coverage form and thecauses-of-loss broad form. the declarations page indicatesthat coverage applies to both the building and the namedinsured's business property. explain whether or not thefollowing losses would be covered under his policy.a. a fire occurs on the premises, and the building isbadly damaged.b. a burglar steals some money and securities from anunlocked safe.c. a business computer is damaged by vandals whobreak into the shop after business hours.d. a tornado touches down near the store. several tel-evision sets of customers in the shop for repair aredamaged in the storm.til