Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quality Audit In Health Care To Avoid Disallowances Literature Review

Authors: Ana P. Alves De Asevedo

1st Edition

6206120406, 978-6206120407

More Books

Students also viewed these Accounting questions