Record$$a$$macro$$and$$type$$the$$VBA$$code$$for$$the$$following$$ actions:$1.$ Select$$Column$$B$$and$$press$$delete$$ VBA$$Code:$2.$ Select$$Range$$A$1$to$$A$8$and$$change$$front$$to$18.$ VBA$$Code:$3.$ Select$$Cell$$A$1$and$$make$$text$$bold$$ VBA$$Code:$4.$ Select$$Cell$$A$2$and$$underline$$text$$ VBA$$Code:$5.$ Set$$value$$of$$A$9$to$$be$$equal$$to$$A$8$ VBA$$Code:$6.$ Select$$Cell$$A$1$and$$set$$color$$to$$blue$$ VBA$$Code:$7.$ Select$$Cell$$A$10$equal$$to$$the$$sum$$of$$all$$values$$above$$ VBA$$Code:$8.$ Select$$Range$$A$1$to$$A$10$and$$add$$border$$ VBA$$Code:$9.$ Select$$Range$$A$1$:A$10$and$$color$$background$$green$$ VBA$$Code:$10.$ Select$$Column$$A$,$copy$,$select$$Cell$$B$1,$paste$$ VBA$$Code:$$