Question
HELP PLEASE!!! You run a small daycare out of your home. Many of the parents, who love your interactions with their children, have begun talking
HELP PLEASE!!!
You run a small daycare out of your home. Many of the parents, who love your interactions with their children, have begun talking to you about expanding your operations. Never having thought about opening a daycare business, you have begun to research the cost involved in opening your own center. After gathering some data, you believe you can open a business. But you need to analyze the data and make the data look more presentable to your investors. The workbook contains worksheets with estimated revenues and expenses over a two-year period.
On the revenue worksheet:
* Convert the revenue data set to a table
*Calculate revenue based on the # Children and Income per columns
*Create an advanced filter of your choice to explore the data
On the expenses worksheet:
*Convert the expenses data to a table
*Add two slicers of your choosing to help explore the data
*Filter the data using slicers, copy the filtered data, and then paste a copy to a new worksheet with an appropriate sheet name.
*Insert some blank rows above the table and use SUBTOTAL functions to create three different calculations on the data that is filtered.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started