Complete in excel

For example, a single person earning bet of 200 royals and 20% of the income above 3,000 royals. You may use as many cells as you like in the design. the base tax for each laws won't cha (b) Add a two-dimensional data table. The left column should be the annual income through 20,000 royals in increments of 10 royals. The second column should be the t from owed by single people earning each income. The third column should be the tax single people and then by married people for each income. Label the columns married people. Then add columns that calculate the percentage of income owed in t (c) Create a similar worksheet to (a) using Form Controls. h soi bs ( At the Royal Pizza Parlor, pizzas are priced as follows: t 000w 12-7. Large 10.95 Medium Small 8.95 $7.95 Triple Cheese Pepperoni Goat Cheese and Fig i11.95 m14.95 Sausage and Pepper 9.45 The Works o10.00an12.00 11.95 10.45 8.95 17.95 ba 10.95 id 12.45 14.00 051 00vo oim doss ol stunis g 59 o a ben (a) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use VLOOKUP. edt ut e s ataim is o how (b) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use INDEX and MATCH. 01o etuq s o FUNCTIONS RELATED TO IF 243 (c) Give an appropriate error message if the person enters a type or size that the Parlor does not carry. Use Data Validation. (d) Use drop-down menus for the inputs of type and size of pizza. (e) Create a worksheet that allows a customer to enter up to six different pizzas with quantities and then calculates the total bill for the customer. For example, the customer might order 2 Medium Sausage and Pepper and 4 Large The Works. The SoKo Cell Phone Company offers five anywhere/anytime plans. Plan A is $9.99 per month and each minute is $0.50. Plan B is $19.99 per month with the first 100 minutes free and each minute in excess of 100 costing $0.40. Plan C is $39.99 per month with the first 250 nh minute over 250 costing $0.30. Plan D is $79.99 per month with the Fin $159 99 ner month D1 For example, a single person earning bet of 200 royals and 20% of the income above 3,000 royals. You may use as many cells as you like in the design. the base tax for each laws won't cha (b) Add a two-dimensional data table. The left column should be the annual income through 20,000 royals in increments of 10 royals. The second column should be the t from owed by single people earning each income. The third column should be the tax single people and then by married people for each income. Label the columns married people. Then add columns that calculate the percentage of income owed in t (c) Create a similar worksheet to (a) using Form Controls. h soi bs ( At the Royal Pizza Parlor, pizzas are priced as follows: t 000w 12-7. Large 10.95 Medium Small 8.95 $7.95 Triple Cheese Pepperoni Goat Cheese and Fig i11.95 m14.95 Sausage and Pepper 9.45 The Works o10.00an12.00 11.95 10.45 8.95 17.95 ba 10.95 id 12.45 14.00 051 00vo oim doss ol stunis g 59 o a ben (a) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use VLOOKUP. edt ut e s ataim is o how (b) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use INDEX and MATCH. 01o etuq s o FUNCTIONS RELATED TO IF 243 (c) Give an appropriate error message if the person enters a type or size that the Parlor does not carry. Use Data Validation. (d) Use drop-down menus for the inputs of type and size of pizza. (e) Create a worksheet that allows a customer to enter up to six different pizzas with quantities and then calculates the total bill for the customer. For example, the customer might order 2 Medium Sausage and Pepper and 4 Large The Works. The SoKo Cell Phone Company offers five anywhere/anytime plans. Plan A is $9.99 per month and each minute is $0.50. Plan B is $19.99 per month with the first 100 minutes free and each minute in excess of 100 costing $0.40. Plan C is $39.99 per month with the first 250 nh minute over 250 costing $0.30. Plan D is $79.99 per month with the Fin $159 99 ner month D1