Question: 1 . Create a macro that uses relative references and types the numbers 3 , 4 and 5 in the active cell and the two

1. Create a macro that uses relative references and types the numbers 3,4 and 5 in the active cell and the two cells below it.
2. Create a new macro like that created in question 1, the macro needs to ask for the values to put in each of the three cells, that is, use an inputbox to request values. Also create a button to run the macro.
3. Write a three variable function that calculates profit given the following profit equation, where p is price, i is input, and y is production, and c is cost per squared unit of production. Place these functions and information in A1 through B6 as given in the spreadsheet.1. Create a macro that uses relative references and types the numbers 3,4 and 5 in the active cell and the two cells below it.
2. Create a new macro like that created in question 1, the macro needs to ask for the values to put in each of the three cells, that is, use an inputbox to request values. Also create a button to run the macro.
3. Write a three variable function that calculates profit given the following profit equation, where p is price, i is input, and y is production, and c is cost per squared unit of production. Place these functions and information in A1 through B6 as given in the spreadsheet.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!