User Account

All Pages

Calculate the number of days for the first workshop

Assignment Help Basic Computer Science
Reference no: EM131534283

Assignment: Training Workshops

Project Description:

You manage a company that provides corporate training workshops. Your two types of clients are business people and college professors. You want to complete a spreadsheet that calculates gross revenue for upcoming training workshops. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

Instructions

1 Start Excel. Download and open the file named e01_grader_a1.xlsx.

2 Copy the range A5:G5 and paste the data below the Big Data Analytics row. For the pasted data, change the start date to 6/25/2018 and the end date to 6/29/2018. Change the # of Corporate Attendees to 10 and the # of Education Attendees to 10.

3 Merge and center the cells F3 and G3. Merge and center the range H3:J3.

4 Apply Bold and Green font color to the range F3:J3.

5 For the range A4:J4, apply the Good cell style, wrap text, and center horizontally.

6 Insert a column to the right of the End Date column. Type # of Days in cell D4.

7 In cell D5, enter a formula to calculate the number of days for the first workshop. Add 1 to the results to include the total number of days, including the start and end dates. Copy the formula to the range D6:D9.

8 Apply Number format with zero decimal places to the range D5:D9.

9 Increase indent three times for the range D5:D9.

10 Delete the row containing the Adv. Project Management workshop. You canceled this workshop because only one person registered for it.

11 In cell I5, enter a formula to calculate the gross corporate revenue for the first workshop by multiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range I6:I8.

12 In cell J5, enter a formula to calculate the gross education revenue by subtracting the education discount rate from 1, multiplying the result by the cost per attendee and multiplying by the number of education attendees. Copy the formula to the range J6:J8.

13 In cell K5, enter a formula to add the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula to the range K6:K8.

14 Format the range F5:F8 with Percent Style.

15 Format the ranges E5:E8, I5:K8 with Accounting Number Format with zero decimal places.

16 Change the width of columns F, G, and H to 9.

17 Apply Outside Borders to the range G5:H8. Apply Outside Borders to the range I5:K8.

18 Select Landscape orientation.

19 Set a 1.5-inch top margin and center the worksheet horizontally on the page.

20 Change the scaling to 90%.

21 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.

22 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

Attachment:- e01_grader_a1_0.rar

Verified Expert

This is a assignment based on working of excel formatting it primarily depends of solving the question based on purely basic knowledge of MS Office

Reference no: EM131534283

Questions Cloud

Which company appear stronger in its ability to pay interest : Key figures for Research In Motion and Apple follow. (Interest expense figures for Apple are assumed as it has no interest expense for these years.)
Analyze the elements of media choices : HRM 533 - Analyze the elements of media choices for conducting an internal total rewards campaign
Violation of title vii of the civil rights act of 1964 : Which of the following would NOT be a violation of Title VII of the Civil Rights Act of 1964? An employer refuses to hire an applicant for a job.
Does warranty accrual decision create any ethical dilemma : Connor Bly is a sales manager for an automobile dealership. He earns a bonus each year based on revenue from the number of autos sold in the year less related.
Calculate the number of days for the first workshop : In cell D5, enter a formula to calculate the number of days for the first workshop. Apply Number format with zero decimal places to the range D5:D9.
Diagnosed as manic-depressive : Mr. Smalley, who had been diagnosed as manic-depressive and had been in and out of mental hospitals, contracted to sell an invention
What do you notice about how people view conflict : Assignment: "What Is Conflict?" What do you notice about how people view conflict? What do you think this means
Cause and effect essay about teen pregnanacy : Cause and effect essay about teen pregnanacy. Please write intro with strong thesis statement, and I need 5 paragraphs
Issues that challenges the organization : Provide an overview of the organization AT&T and the problem/issues that challenges the organization.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Propose a solution that maintains existing software

Propose a solution that maintains existing software in each department and is supported by the HL7 initiatives.

  Determine the effective miss rate

For the following repeating sequence of 1w address (given in hex) and cache configurations... Assuming least recently used (LRU) replacement for associative caches,

  What should the standard deviation of the proportion be

If we plot a histogram showing the proportions of green candies in the various bags, what shape would you expect it to have?

  Opportunity cost of going to disneyland

You visit the Disneyland from time to time. What is the opportunity cost of going to Disneyland? How about the benefit? Think about ways to measure your benefit of going to Disneyland.

  Evaluate the equality of the scrutinized laws

Evaluate the equality of the scrutinized laws discussed in this assignment compared to other more globally accepted laws across countries. Provide an example to support your response.

  Great success in solar energy technologies

The SolarGroup (TSG) has experienced great success in solar energy technologies, but it has reached a point where the information technology (IT) infrastructure, especially with a network infrastructure, is critical to the future of the enterprise..

  Create supply chain management system

What are some of the reasons that RMO decided to build supply chain management system previous to customer support system?

  Define a class extpersontype

Define a class extPersonType using the class personType (as defined in Example 1-12, Chapter 1), the class dateType (as designed in Programming Exercise 2 of Chapter 2), and the class addressType.

  Differentiate centralised and distributed data processing

Explain the differences between centralised and distributed data processing. Describe the pros and cons of each approach.

  Why you chose the three points of view that you did

Modify one of the three worlds from Exercise 4, using the three camera points of view that you described. Save the finished world as an Alice world and as a movie file.

  Develop a conceptual framework

How important is it that standard setters agree on objectives, concepts and definitions before they develop a conceptual framework of accounting?

  Write a single statement that assigns the values

Write a single statement that assigns the values 99, 100 and 88 to an integer array named TestScores. Use the C++ notation used for the "lotterynumbers" array.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd