100%(10)10 out of 10 people found this document helpful
This preview shows page 3 out of 3 pages.
Range(“A7”).Select (added)End SubHere are some of the formulas in the worksheet:C3=MAX(A7:A10)+1F7=D7+F3F8=F7-D8+E8F9=F8-D9+E9F10=F9-D10+E10See the red text.Question 57 Here is a screen snapshot of a worksheet: I failed to copy the snapshot here.Here is a macro that goes with this worksheet:Sub virus_name()‘‘ virus_name Macro‘ Macro recorded 10/6/99 by CS 3rd Floor LabsRange("B6:D24").SelectSuppose we were to insert a new virus after row 24 having name"y73 sarcoma virus," size 0.30, andhost species Chicken. The above macro would no longer work. Why not? What is the best way to deal with the problem (i.e. how would you change the macro to avoid the need for further changes whenever data is added to the worksheet)?Question 58 Give three (3) frequently-relevant and important reasons why one names cell ranges in Excel.