Exp19_excel_ch01_ml2_sales | Computer Science homework help

Uncategorized

Exp19_Excel_Ch01_ML2_Sales

Exp19 Excel Ch01 ML2 Sales

Excel Chapter 1 Mid-Level 2 – Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price

Start Excel. Download and open the file named Exp19_Excel_Ch01_ML2_Sales.xlsx. Grader has automatically added your last name to the beginning of the filename.

The owners of the house on 386 East Elm Street took their house off the market. You want to delete that row since it did not sell.

Delete row 8, which has incomplete sales data.

You want to assign a property ID to each listing. The code will have the year 2021 with a sequential number.

Type 2021-001 in cell A5 and use Auto Fill to complete the series to assign a property ID to each property in the range A6:A12.

Real estate agents study the number of days houses are on the market. In some cases, the longer a house is on the market, it might indicate the asking price is too high.

Enter a formula in cell C5 that calculates the number of days the first house was on the market by subtracting the date listed from the date sold. Copy the formula to the range C6:C12.

Monetary values look better when they are formatted to display the dollar signs. Because all monetary values are whole numbers, you will decrease the decimal points to avoid columns where all the data ends in .00.

Format the list prices and sold prices in the range F5:G12 with Accounting Number Format with zero decimal places.

To analyze the real estate market, it is helpful to calculate the selling prices as a percentage of the list price. For example, the second house was listed for $500,250, but it sold for only $400,125. Therefore, the sale percentage of the list price is .7999 or 79.99%.

Enter a formula in cell H5 that calculates the sales price percentage of the list price for the first house by dividing the sold price by the list price. Copy the formula to the range H6:H12.

The calculated percentages need to be formatted with the percent symbol rather than displaying the values as raw numbers.

Format the values in the range H5:H12 with Percent Style with two decimal places.

Currently, the labels on row 4 are hard to read. You will wrap the headings within each cell to improve readability.

Wrap the headings in the range A4:H4.

For better sequencing of columns, you want to display the Days on Market column after the two columns containing the dates.

Insert a new column between the Date Sold and List Price columns. Move the Days on Market data to the new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

You notice the list contains a wrong date and wrong list price that need to be corrected.

Edit the list date of the 41 Chestnut Circle house to be 4/22/2021. Edit the list price of the house on Amsterdam Drive to be $355,000.

Increasing the height of the rows of data and centering the data vertically between the top and bottom cell margins will make it easier for the other agents to review the data.

Select the property rows (rows 5:12), set a 25 row height, and apply Middle Align.

Displaying borders helps separate the property listings.

Apply the All Borders border style to the range A4:H12.

You want to improve the alignment of number of days on market below the column label.

Apply Align Right and increase the indent two times on the days on market formula results in the range E5:E12.

The widths of the columns containing the Days on Market, List Price, and Sold Price data need to be adjusted for better appearance.

Set the Days on Market column width to 9. Set the List Price and Sold Price column widths to 11.86.

The property listings dataset is small. To improve readability on the printed copy for the other real estate agents, you will increase the scaling.

Apply 120% scaling.

You don’t need the data on the Properties sheet but you do want to insert another sheet for formulas.

Delete the Properties sheet and insert a new sheet named Formulas.

You want to copy the original data to the new sheet so that you can modify the duplicated data.

Use the Select All feature to select all data on the Houses Sold worksheet and copy it to the Formulas worksheet.

You do not want to display the columns containing dates on the new worksheet.

Hide the Date Listed and Date Sold columns in the Formulas worksheet.

You want to review the formulas within the worksheet and prepare the Formulas sheet to be printed.

Display cell formulas. Set options to print row and column headings. Set 6.86 column width for column E and 6 for column H.

You want to apply page setup options to both sheets, so you need to group the sheets first.

Group the two worksheets. Select Landscape orientation. Center the page horizontally and vertically between the margins.

With both worksheets still grouped, 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.

Save and close Exp19_Excel_Ch01_ML2_Sales.xlsx. Exit Excel. Submit the file as directed.

Continue to order Get a quote

July 1, 2023

41) The above figure shows the production possibility frontier for an economy. The point or points that are attainable and production efficient are

A) points B and C.

B) points A, B, and C.

C) point E.

D) points A, B, C, and D.

E) points A and D.

42) The above figure shows the production possibility frontier for an economy. The point or points that are attainable are

A) points B and C.

B) points A, B, and C.

C) point E.

D) points A, B, C, and D.

E) points A and D.

43) The above figure shows the production possibility frontier for an economy. The point or points that are NOT attainable are

A) points B and C.

B) points A, B, and C.

C) point E.

D) points A, B, C, and D.

E) points A and D.

44) In order for Ireland to grow more potatoes, wool production must decrease. This situation is an example of

A) producing at a point that lies beyond the PPF.

B) zero opportunity cost.

C) opportunity benefit.

D) a free lunch.

E) a tradeoff.

45) As we move along the production possibilities frontier,

A) the production of one good increases as the production of the other good decreases.

B) the possibilities of tradeoffs diminish.

C) a tradeoff is not possible because nations need all goods.

D) more of both goods can be produced.

E) less of both goods can be produced.

46) Which of the following statements is correct?

A) If capital is idle, the economy is producing at its full potential.

B) The production possibilities frontier shows that there are no limits to production.

C) A tradeoff is a limit that forces an exchange or a substitution of one thing for something else.

D) Any point on or within the PPF is production efficient.

E) None of the above answers is correct.

47) When a nation is producing on its production possibilities frontier, if more resources are used to produce one good, then the production of other goods

A) must increase.

B) must decrease.

C) must remain the same.

D) must change, but they might increase or decrease.

E) might increase if the nation can produce more efficiently.

48) The negative slope of the production possibilities frontier represents the idea

A) that free lunches are possible.

B) of tradeoffs, that in order to produce more of one good, the nation must produce less of another.

C) of unemployment.

D) of inefficient production.

E) that prices rise as less is produced.

49) A movement from one point on a production possibilities frontier to another represents

A) a tradeoff.

B) a free lunch.

C) full employment of labor but not capital.

D) unemployment.

E) an advance in technology.

50) The saying "There's no such thing as a free lunch," applies

A) when there is some unemployment.

B) on the production possibilities frontier.

C) to unattainable combinations of goods and services.

D) when more of one good can be produced without decreasing production of another.

E) at all points inside the PPF.

July 1, 2023

31) Steve, an HR supervisor at APEX construction, has recently noticed a shortage of skilled workers due to a building boom in the area. He must find new workers quickly because it is uncertain how long the boom will last. He decides to hire nontraditional laborers. The most likely disadvantage of using nontraditional laborers is the:

A) high costs of making reasonable accommodations.

B) additional training that will be necessary.

C) extensive involvement of the EEOC.

D) high advertising costs.

32) Which of the following is primarily associated with hiring external candidates?

A) Lowers training costs

B) Provides new ideas and perspectives

C) Decreases recruitment time and expense

D) Motivates other workers to strive for advancement

33) One of the advantages of promoting internal candidates is:

A) rejuvenating work units.

B) reducing training costs.

C) fostering innovative ideas.

D) reducing employee turnover.

34) Tatiana needs to hire a line manager and has a very small recruiting budget. The firm's current employees don't feel they have many advancement opportunities. It would be best for Tatiana to recruit:

A) internally.

B) externally.

C) former military members.

D) nontraditional workers.

35) Which of the following is most likely a true statement about recruiting?

A) Internal recruiting enhances organizational communication.

B) External recruiting fills positions quickly and inexpensively.

C) External recruiting promotes innovation and new perspectives.

D) Internal recruiting requires developing new organizational policies.

36) Which of the following is most likely a true statement about recruiting employees in a protected class?

A) The recruiting message should be targeted to specific minority groups.

B) All private sector firms are legally required to have an affirmative action policy.

C) Using media that focuses on minorities is an effective way to recruit protected group members.

D) Intense minority competition for jobs ensures a large pool of qualified and motivated applicants.

37) Which of the following must have written affirmative action plans?

A) Non-profit groups

B) Government contractors

C) Privately-held corporations

D) Publicly-held corporations

38) In human resource planning the answer to the question, "How many candidates should we recruit?":

A) is based on the firm's affirmative action plan.

B) comes from the yield ratio calculated in the forecast.

C) is directed by EEO consideration and the size of the labor pool.

D) depends on the state of the labor pool and the current economy.

39) The offer-to-acceptance ratio at Central Manufacturing is 6:1. How many offers will the firm need to make in order to fill 80 positions?

A) 120

B) 240

C) 480

D) 540

40) After an extensive recruiting effort, your company has contacted 225 interested individuals. At the application deadline, you have received 75 applications. What is your contact-to-applicant ratio?