AccountingAssumptions and mixed references are very important The event Monster Bucks is in town and tickets are going on sale soon. You are creating a spreadsheet that will display the Type of ticket and Price of the ticket when the customer’s age is entered.You will have one input: AgeYou will have two outputs: Ticket Type and PriceThe options for the ticket type output are shown below (Child, Student, Adult)The options for the price outputs are also shown below ($15, $20, $25)Use the assumptions providedUse IF statements as your formulasFormat for a professional appearanceA starter file has been provided for you on the ‘LOGICAL’ tabYou will not need to drag your formulas down or across…you will just have one output cell for type and one for price Information for problem: Child (5 years and under): $15Student (6-17 years): $20Adult (over 17 years): $25 AEF34 Ticket Calculator5 Last NameFirst NameAgeTicket Type Ticket Price789101112 Assumptions13ChildAge cutoff14Price$ 1515Student Age cutoff17$ 20$ 2516Price17AdultPrice18192.

The spreadsheet is created using the given formula for Ticket type:…

Answered: Accounting Assumptions and mixed…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Accounting

Assumptions and mixed references are very important

The event Monster Bucks is in town and tickets are going on sale soon. You are creating a spreadsheet that will display the Type of ticket and Price of the ticket when the customer’s age is entered.

You will have one input: Age
You will have two outputs: Ticket Type and Price
The options for the ticket type output are shown below (Child, Student, Adult)
The options for the price outputs are also shown below ($15, $20, $25)
Use the assumptions provided
Use IF statements as your formulas
Format for a professional appearance
A starter file has been provided for you on the ‘LOGICAL’ tab
You will not need to drag your formulas down or across…you will just have one output cell for type and one for price

Information for problem:

Child (5 years and under): $15

Student (6-17 years): $20

Adult (over 17 years): $25