computer

1. Using the file from Step 1, create a paragraph style named Title_Page_1 with the following formats:

0. 22-point font size

0. shadow font effect (Offset Diagonal Top Right)

0. character spacing expanded by 2 points

0. horizontally centered

0. font color: dark blue, text 2, darker 50%

0. Apply this style to the first line of the document, Understanding the Personal Interview.

1. Create a paragraph style named Title_Page_2 based on the first style that you created, with the following changes:

1. 20-point font size

1. Custom color 66, 4, 66

1. Apply this style to the subtitle, A Study for Managers Involved in the Hiring Process.

1. Place your cursor to the left of Understanding the Personal Interview (below the titles), and insert a page break to move all content to page 2.

1. Select the remainder of the text in the document, starting with Understanding the Personal Interview, and apply the following formatting:

3. Justify alignment

3. 1.5 line spacing

1. Apply the Heading 1 style to all main headings. Apply the Heading 2 style to the paragraph headings, such as Introduction and Pre-Interview Impressions.

1. Modify the Heading 2 style to use Dark Red font color.

Formatting the Paragraphs (remember to save!)

1. Apply bullet-point formatting to the five-item list under Introduction, beginning with Pre-interview Impressions. Change the bullet point symbol to a four-sided star: ✧

2. Select the second paragraph under Introduction, and apply the following formats:

· 6” left and right indent and 6 point “after” spacing

· box border of 1 ½-point width, using the color Blue, Accent 1, Darker 25%

· shading color of Blue, Accent 1, Lighter 80%

3. Apply numbered-list formatting to the three phases under Pre-Interview Impressions.

4. Select the second and third paragraphs under The Unfavorable Information Effect, and then convert them to 2-column formatting with a line between the columns.

Inserting Graphics and Page Numbers (remember to save)

1. Select the [Image Placeholder] text under Introduction, and search for clip art using the phrase “interview” (be sure to include all media file types, including office.com content).

· Choose the first image result: two orange figures at a table.

· Select the image, and change the dimensions to 3” x 3.” Center the image on the page. Apply the Simple Frame, White picture formatting.

2. Double click into the footer (the bottom margin) and a page number at the bottom of the page using the Accent Bar 4 format. Check the box that says Different First Page, and then format the page numbers to start at 0 – in the Page Number > Format Page Number menu.

3. Review the entire document to ensure that headings and paragraphs are not separated across pages. Fix any other formatting issues that you notice.

4. Save and submit your completed Lab Report (part-1) for grading.

Problem 1:

1. You would like to open a daycare facility, and need to know how much it will cost to operate the business and how many children need to attend to break even, and how many it will take to make a profit . You will use Excel for this lab and create formulas to solve this problem. The following is the information that you need to solve the problem.

1. You employ four teachers at $15/hr.

2. You employ one manager at $20/hr.

3. We will assume that they will work 2,000 hours.

4. Food/snacks will cost $3,000 per year.

5. Supplies will cost $1,000 per year.

2. Create a spreadsheet to solve the following problems:

1. How much will it cost to run the daycare facility for a year?

2. If you charge tuition of $8,000 per year, how many students do you need to break even?

3. Assuming that tuition is still $8,000 per year, how many students do you need to make a $25,000 profit?

4. Create a pie chart showing the percentage of expenses for each category.

Problem 2:

1. You own a game company and would like to develop a new game. Your goal is to determine how much it costs to create a game , how many games you need to sell to break even, and how many it will take to make a profit . You will use Excel for this lab and create formulas to solve this problem. The following is the information that you need to solve the problem.

1. You employ 60 programmers at $40/hr.

2. You employ 10 managers at $55/hr.

3. Marketing has requested $1,000,000 to market the game.

4. Each employee will work 1 year (2,000 hours) to develop this game.

2. Create a spreadsheet to solve the following problems.

1. How much will it cost to develop the game?

2. If you sell the game for $55, how many games do you need to sell to break even?

3. Optional:

1. Assuming the $55 price, how many games do you need to sell to make a $1,000,000 profit?

2. Create a pie chart showing the percentage of expenses for each category.

Procedure:

1. Open Microsoft Excel application.

2. Watch the video explaining how to complete Problem 1.

3. Create formulas to calculate the total costs for teachers and managers and calculate the total cost of the daycare. Your formulas should be similar to the screenshot below.

4. Next, do the analysis to determine the breakeven point and the number of students needed for a desired profit. These formulas are below. You need the ceiling function to round up to the nearest integer.

5. A pie chart is needed to illustrate the percentage of expenses for the daycare. Select A4:A7. Press and hold ctrl and select E4:E7. Then, choose Insert -> Pie to create a pie chart based on the expenses. Add a title to the pie chart.

6. Your final spreadsheet should look like the following.

7. Save your worksheet from Problem 1 as CEIS100_W7_LabReport(part-2)

8. Open a new worksheet for Problem 2 in the CEIS100_W7_LabReport(part-2) that you created. Enter all of the data into your spreadsheet as shown below. You can format the spreadsheet as you wish. Replace "Your Name" in the title with your first and last name.

9. Using the knowledge from the previous exercise, solve the problems in this spreadsheet. Save your final spreadsheet, and submit CEIS100_W7_LabReport(part-2) document for grading. Be sure that both Problem 1 and Problem 2 are saved in the submitted document.