Homework $1$

Be sure to complete all the requirements in the Excel Requirements document. Ask me if you have questions.

Part l:

Complete all of the Part $1$ requirements in a single worksheet:

Create user input cells so that the user can input the following information:

a$.$ The number of computers that the company owns.

b$.$ The number of printers that the company owns.

c$.$ The number of warehouses that the company owns.

d$.$ The number of products that the company sells.

Use relative referencing to create a formula that calculates the following:

a$.$ The total number of computers and printers that the company owns.

b$.$ Calculate the average of the four user inputs.

c$.$ Multiply the number of warehouses by the sum of the number of products plus the number of printers.

d$.$ Add the number of printers and number of products together, then divide the result by the sum of the number of printers and number of warehouses.

Use absolute referencing to create a formula that calculates the following:

a$.$ Multiply the number of warehouses times the number of printers.

b$.$ Divide the number of products by the number of warehouses and format the result as a percentage.

Change the name of user input cell for the number of computers to $C$ and change name for the user input cell for the number of products to $P.$

a$.$ Using the names that you just created, write a formula that subtracts the number of computers from the number of products.

Create a range name for all four of the user input cells. This range name must be User.

a$.$ Calculate the sum of the four user inputs using the range name User.

Create a formula named Easy that adds the number of computers and the number of warehouses together.

a$.$ Multiple the formula Easy times vour answer to reauirement $3$ b