2. You know that the profit depends very much on the number of attendees. Create a one variable data table based on the number of attendees between 300 and 600. Start in cell Ds and complete the series of substitution values ranging from 300 to 600 at increments (or steps) of 23 attendees/3 vertically down column D (Series of numbers will not stop at 600 exactly, but that is okay) Enter the references to the "Total Income". "Total Expenses" and "Profit/Loss" in the one-variable data table in their appropriate cells within the one-variable data table. /3 Complete the one-variable data table and then format the results with Accounting Number Format with two decimal places (If losses show up in brackets or a negative number, that's okay). In cell D4, Type # of Attendees and make sure the reference cells display as following: In E4, Income; in F4, Expenses, in G4, Profit/Loss, Bold & center all the column headings. 4. 73 Copy the number of attendees from the one-variable data table (.e. the variable), and paste them in the two-variable data table starting in cell J5. You have decided to create a two-variable data table as well and you will use the Ticket Price as your second variable. You have been told that the maximum amount that can be charged for the tickets is S65. Complete the series of substitution values for ticket price from $50 to $65 at $3 increments and enter the reference to Profit/Loss for the two-variable data table 5. Complete the two-variable data table and format the results with Accounting Number Format with two decimal places. Apply a custom number format to make the formula reference appear as a descriptive column heading "Attendees/Price", bold and center the heading. 12 2. You know that the profit depends very much on the number of attendees. Create a one variable data table based on the number of attendees between 300 and 600. Start in cell Ds and complete the series of substitution values ranging from 300 to 600 at increments (or steps) of 23 attendees/3 vertically down column D (Series of numbers will not stop at 600 exactly, but that is okay) Enter the references to the "Total Income". "Total Expenses" and "Profit/Loss" in the one-variable data table in their appropriate cells within the one-variable data table. /3 Complete the one-variable data table and then format the results with Accounting Number Format with two decimal places (If losses show up in brackets or a negative number, that's okay). In cell D4, Type # of Attendees and make sure the reference cells display as following: In E4, Income; in F4, Expenses, in G4, Profit/Loss, Bold & center all the column headings. 4. 73 Copy the number of attendees from the one-variable data table (.e. the variable), and paste them in the two-variable data table starting in cell J5. You have decided to create a two-variable data table as well and you will use the Ticket Price as your second variable. You have been told that the maximum amount that can be charged for the tickets is S65. Complete the series of substitution values for ticket price from $50 to $65 at $3 increments and enter the reference to Profit/Loss for the two-variable data table 5. Complete the two-variable data table and format the results with Accounting Number Format with two decimal places. Apply a custom number format to make the formula reference appear as a descriptive column heading "Attendees/Price", bold and center the heading. 12