Excel_3G_Expenses

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

I’m studying for my Powerpoint class and don’t understand how to answer this. Can you help me study?

Steps to Perform:

Step

Instructions

Points Possible

1

Open the Excel workbook Student_Excel_3G_Expenses.xlsx downloaded with this project.

0

2

In the Expenses worksheet, calculate row totals for each Expense item in the range F5:F9. Calculate column totals for each quarter and for the Annual Total in the range B10:F10. Be sure that F6:F9 are formatted with Comma Style and zero decimal places.

4

3

In cell G5, construct a formula to calculate the Percent of Total by dividing the Annual Total for Salaries and Benefits by the Annual Total for all quarters. Use absolute cell references as necessary, format the result in Percent Style, and then Center. Fill the formula down through cell G9.

9

4

Use a 3-D Pie chart to chart the Annual Total for each item. Move the chart to a new sheet and then name the sheet Annual Expenses Chart

7

5

As the text for the Chart Title element, type Summary of Annual Expenses and then change the Font Size to 28.

4

6

Remove the Legend from the chart and then add Data Labels formatted so that only the Category Name and Percentage display positioned in the Center. Format the data labels by applying a Font style of Bold and Italic and a Font Size of 12.

10

7

Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel–under Bevel, in the first row, apply the first bevel effect. Set the Top bevel Width and Height to 50 pt and then set the Bottom bevel Width and Height to 256 pt.

2

8

Display the Series Options, and then set the Angle of first slice to 125 so that the Salaries and Benefits slice is in the front of the pie. Select the Salaries and Benefits slice, and then explode the slice 10%.

4

9

Format the Chart Area by applying a Gradient fill using the Preset gradients—in the first column, apply the second gradient. Format the Border of the Chart Area by adding a Solid line border—in the fourth column, apply the first color. Change the Width to 3 pt.

6

10

Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name.

4

11

Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Do not include the Annual Total. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell A12. Change the Width of the chart to 7.5 and then as the Chart Title, type Recreation Department Expense Summary

10

12

Format the Bounds of the Vertical (Value) Axis so that the Minimum is 2100000 and the Major unit is 50000 and then apply Bold to the values on the Vertical (Value) Axis and to the labels on the Horizontal (Category) Axis. Close any open panes, click cell A1 to deselect the chart, and then Save your workbook.

8

13

Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increaseof 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35.

10

14

Change the Orientation of this worksheet to Landscape, and then use the Scale to Fit options to fit the Height to 1 page. From the Page Setup dialog box, center the worksheet Horizontally, and insert a custom footer in the left section with the file name. Save your workbook.

10

15

Display the Enrollment worksheet. Insert a Funnel chart that shows resident workshop participation for the year using the range A4:B6. Change the Height of the chart to 2.5 and the Width to 3 and then drag the chart so that the upper left corner aligns with the upper left corner of A9. Change the chart title to Enrollment Analysis and then click cell A1. Center the worksheet Horizontally and insert a Custom Footer in the left section with the file name.

4

16

Display the County Partnership worksheet. The City of Pacifica Bay is partnering with the County to offer workshops to residents. The Recreation Department staff will visit several cities with similar partnership agreements. Using the range A3:B9, insert a Filled Map chart. Change the chart title to Partnership Analysis and then drag the chart so that the upper left corner aligns with the upper left corner of D1. Change the chart Width to 4 and then deselect the chart. Change the Orientation of this worksheet to Landscape.

2

17

Center this worksheet Horizontally and insert a Custom Footer in the left section with the file name. Display the workbook Properties. As the Tags, type recreation workshops, expenses and as the Subject, type your course name and section number. Be sure your name displays as the Author.

6

18

Save and close the file, and then submit for grading.

0

Total Points

100Fears, Phobias, and Anxiety: assignment help online
I’m studying for my Social Science class and need an explanation.

Directions:

For this post, select a common child or adolescent phobia and consider the external factors that may contribute to its development and persistence.

With these thoughts in mind:

Post a brief description of a common child or adolescent fear or phobia other than fear of the dark. Then, explain at least three contemporary factors (environment, culture, society, family, or media) that may contribute to the development and persistence of the phobia, and explain how. Finally, explain one way you might help the parents/guardians support their child or adolescent to overcome the fear or phobia, and explain how. Be specific.

Be sure to support your postings and responses with specific references to the week’s resources.

Burnham, J. J. (2009). Contemporary fears of children and adolescents: Coping and resiliency in the 21st century. Journal of Counseling and Development, 87(1), 28–35.

Flatt, N., & King, N. (2008). Building the case for brief psychointerventions in the treatment of specific phobias in children and adolescents. Behaviour Change, 25(4), 191–200.Final Finance essay
I’m stuck on a Accounting question and need an explanation.

Discipline: – Finance

Type of service: Essay

Spacing: Double spacing

Paper format: APA

Number of pages: 4 pages

Number of sources: 5 sources

Paper detalis:

Part I: Investing Behavior: What are the various types of investors? Complete the interactive investor profile questionnaire at http://pfp.missouri.edu/research_IRTA.html. According to this instrument, what kinds of investments should you consider? Write an introduction to your essay that provides a profile for yourself as an investor. What else can you find out about investing behavior–for example, does your profile change over time as you age or does it remain the same? How would your profile assist you and your financial advisor or investment advisor in planning your portfolio? Part II: Recognizing Fraud What is a pyramid scheme exactly? Find out at http://www.investopedia.com/articles/04/042104.asp. Have you ever participated in or invested in such a scheme? Have you ever been a victim of one? Research and discuss this topic in this part of your project. According to the Investopedia article, why can it be difficult to detect a pyramid scheme? What are some possible tip-offs to this kind of fraud? Why are pyramid schemes unsustainable? Who are the victims? Provide a diagram illustrating the dynamics of pyramid schemes. Part III: Famous Scandals Survey the Web site of a 2009 60 Minutes CBS broadcast on the Madoff affair, which includes articles, video, and links at According to this site, who discovered the Madoff fraud and how? Who were Madoff’s victims? Visit the support group Web site created for the victims at http://berniemadoffponzisupportgroup.blogspot.com/. In the CBS video, how did Madoff defend himself? Read a Wall Street Journal article at http://online.wsj.com/article/SB123111743915052731.html, explaining how Madoff’s Ponzi scheme was able to succeed. How did investor biases contribute to this success? How did biases in regulatory oversight contribute to the fraud? Sample some of the videos of the congressional hearings on the Madoff scandal at Why did representatives and senators focus their criticism on the Securities and Exchange Commission? Use the template provided. Follow APA format, including a title page, introduction, conclusion, citations, and five scholarly references (not Wikipedia or Investopedia). See the attached PPT file. Turnitin report of no more than 20% similarity index is required. Your final project should be 4-5 pages in length.Respond to the following in a minimum of 100 words:
Help me study for my Management class. I’m stuck and don’t understand.

Deidra
Bush

An organization represents a collection of individuals who work together towards common goals. It is very important that each member of an organization is aware of these goals and agrees to uphold the overall mission. When determining the goals for an organization it is important that they are feasible, ethical, and practical. Strategic plans should be implemented to ensure that these goals will be successfully achieved. The plans should clearly define a role for each member of the organization, and set them up in such a way that these roles have a cooperative effect. This way the individuals within the organization will collectively move forward in one cohesive direction, rather than pulling in different directions without making any real progress.

I work in a small shop that dispenses cannabis products to customers. One of the most important goals of my organization is to always serve the needs of our customers. I could execute a plan to increase my engagement with each customer. I will make an effort to be friendly and talk to each customer that comes in the shop, and note down any particular needs they might have. This will allow me to address those needs and meet the main goal of my organization.

Adeshola
Fatuyi

What factors should you consider in determining an organization’s goals? How would you decide which strategic and operational plans to use to achieve your goals? Provide an example of a plan you could use to achieve a goal in your current organization.
What factors should you consider in determining an organization’s goals?
A. An organization’s goals is the big picture that spell out what the organizations will look like in the short-term and long-term. However there are several factors that is very essential and critical in determining organization’s goals. Internal and external factors: 1. Financial Resources, 2. Human Capitals, ” Operations of the business it components and functions Expected revenues and expenses Describes the industry you are entering. How your product will be different. How you qualify to run the business. How you finance the service as mentioned above financing.
How would you decide which strategic and operational plans to use to achieve your goals?

Strategic plan: is used to outline the organization’s objectives and to identify the methods in which those objective can be achieved. this focus on the mission and the vision of the organization for the next 1-5 years which is the long-term goals of the organization and how to measure the goals and what project will be carried out to achieve them. this is usually take on by the top managers.

Operational plan: is the effective way in which all the available resources can be used to accomplish organizations goals which usually a short-term goals kind of focus on a daily how the organization will get to the long term goals which is take on by the line manager for about 1-52 weeks
Provide an example of a plan you could use to achieve a goal in your current organization? I work in a social service setting and I personally working on setting up a nonprofit organization so will say Tactical plans which runs the execution of the strategic plan which is also a short-term goal of about 6-24 month which will help us to on making a different right now, making sure we always focus on solving the most important problems. we expect everyone on our team to focus on what the family we are working with need and what the biggest problems we need to work on with the families we will be serving.AOJ 200 90-91 Discussion: nursing homework help
I’m trying to learn for my English class and I’m stuck. Can you help?

I divided the discussion below according to which edition of the book you have.

4th Edition of the book:

Read Crime in the News on page 90-91 about the Penn State child abuse case.

Then answer the questions at the end. “Should the entire Penn State football program have been penalized for the failure of a small number of individuals to inform state governmental officials of Sandusky’s child abuse? Do you agree with rescinding the non-monetary punishments imposed on Penn State?”

5th Edition of the book:

For those of you with the newest edition of our book, you will be answering the questions at the end of “Crime in the News” on page 84-85 about Gilberto Valle, the “Cannibal Cop.”. Answer the following 2 questions: 1. Why did the appellate courts consider Valle to have engaged in fantasy? 2. Do you agree with the decision to acquit Valle? Why or why not?

In responding to another student, only respond to a student who read the same case as you.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services