1. An Excel feature used create multiple scenarios, save them, and then switch between them to display the results of several what-if analyses within the worksheet.

		A. Data Table
		B. Scenario Manager
		C. Scenario
		D. Data Analysis
		E. Column Input Cell

2.

Refer to the table below. Determine the net income. Write the solution in the box below: No. of Leased Mobile Phones 80 Average Monthly Expense per Mobile Phone Monthly Cost $500.00 Mobile Phone Service Cost $70.00 $10.00 Other Fixed Costs $100.00 Price Charged per Visit Variable Cost per Visit Margin per Visit $2.00 Fixed Expense per Mobile Phone $8.00 Rental Rate $300.00 Monthly Monthly Maintenance Per Phone 30,000 Revenue Cost of Goods Sold Contribution Margin General & Admin. Costs Net Income