12
Dr. William Gardner's Dental Office
Marketing Analysis
EXCEL WORKING CASE: BEGINNING LEVEL
Submission Instructions Complete Case 12 in Excel. Answer the questions at the end of this case and insert the answers on an Answer Sheet within the Case 12 Excel spreadsheet. Ask your instructor for submission instructions.
Preview You are the marketing manager for Dr. Gardner's Dental Office. You need a new marketing campaign for two of the dental services that the office provides. You decide to create a spreadsheet for the services the dental office provides with the hope of discovering which services you want to focus on in your next ad campaign.
Skill Set
| Format spreadsheet |
| Absolute reference |
| Sum, maximum, minimum functions |
| Date function |
| Goal seek (question at end of case) |
| If function |
| Vlookup table |
| AutoFilter |
| Center merge |
| Chart (question at end of case) |
Background Dr. William Gardner's Dental Office has three different office locations. Each location offers a variety of dental services, and you want to know which services are most popular in each of the offices. This is why you want to create a spreadsheet in Excel. You also want to know which service brings in the most revenue at each office, and from this information, you will focus your ad campaign on two services.
CASE ANALYSIS
Output Requirements
Create a spreadsheet that you can use to keep track of services ...
Get MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
