Category Archive New perspectives excel 2016 module 3 sam project 1a

ByFegor

New perspectives excel 2016 module 3 sam project 1a

AnalyZing and Charting Financial Data. If you do not see the. The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. Casey Byron is the owner of Inception Workspace, a collaborative office building where individuals, startups, or small businesses can reserve work spaces.

Casey wants a chart representing the distribution of average hours per week that members utilized Inception Workspace in Modify the chart as described below:. Inception Workspace offers a variety of membership packages to fit the needs and budgets of its customers.

In the 3-D pie chart, add data labelsto the chart using the following options:. Hint : You may need to uncheck the Valuedata label option. Update the line chart by adding Primary Major Horizontal gridlines and Primary Major Vertical gridlines to the chart area. Format the line chart as described below:. Casey created a stacked column chart to show how the income generated by each membership package contributed to the total annual income.

He now needs to modify the data and formatting used in the chart. Hint: Do not filter out or hide the data. In the stacked column chart, format the chart legend as described below:.

Hollywood adults movies download

Because of the large difference between the package income and total income values, Casey determines that a combo chart is most appropriate option. Finally, delete the horizontal axis title placeholder.

Casey wants to calculate the monthly payments for each loan option that he is considering. Copy the formula you created in cell B12into the range CD Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. Current Stock:.

NP_EX16_8a (completed solution)

Quantity: Decrease Quantity: Increase Quantity:. Quick view Add to Cart.Sign up with Facebook Sign up with Twitter. I don't have a Facebook or a Twitter account. The program will add the file extension for you automatically. In cell D6, type ML Select the range D5:D14, and then use Flash Fill to automatically enter codes into the remaining cells in the range. Select cell A15, and then enter the word Total.

Remove cell borders from the range AB15 using the No Border border format. Select the range A4:E4 and the nonadjacent cell G8, and then increase the font size of the cells to 12 pt. To better display the content, manually change the height of row 3 to Hint: Do not use AutoFit. Copy the formula you created in cell B7 to the range C7:D7.

After determining the total profits generated by each store, Katie is now interested in calculating the total sales, expenses, and profits for the company. Select the range E5:E7, and then apply AutoSum to calculate the totals for these categories across all three stores. Katie edited the worksheet after March 8,making the content in cell A11 unnecessary.

Click on cell A11 and clear its contents. After reviewing the Profit and Payroll worksheets, Katie typically generates some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting, and if necessary, move the new worksheet after the Profit worksheet.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.Sign up with Facebook Sign up with Twitter. I don't have a Facebook or a Twitter account.

Maureen Meek is doing an internship with Forge and Polish Jewelry. One of her assignments is to format the product sales records from to to make it easier to analyze. Sort the data in the BraceletSales table first in ascending order by the Material field and then in the ascending order by the Embellishment field. Insert a Total Row in the BraceletSales table, and then use the Total Row to calculate the total of the values in both the and fields.

Hint : The Total Row should automatically total the values in the field. Maureen decides to create a PivotTable to allow her to better manipulate and filter the BraceletSales table data. Sort the PivotTable manually by dragging or by using the Move command if necessary.

Add the, and fields in that order to the Values area. Go to the Necklace worksheet.

Module5SamProject1a

Use NecklaceSales as the name of the table. Maureen notices that the NecklaceSales table is missing a record. Add the following record as shown in bold in Table 1 below to the end of the NecklaceSales table VR Note: You can select all the data and then copy and paste special to match destination formatting. Forge and Polish Jewelry offerings a large selection of earrings. Maureen wants to summarize the Earring sales data using subtotals to show how the type of Material used influences earring sales.

Sort the table by the Material field in ascending order.

Office in salt lake sector 5

Convert the table to a normal range. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. The subtotals should use the SUM function and include subtotals for the, and fields. Hint : Make sure to check the summary below data check box if it is not checked automatically.If you do not see the. The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

Stephanie manages the employees at the Good Breeze Hotel.

Cancer horoscope 2020 in hindi

Change the theme of the workbook to Office. Switch to the Hourly Compensation worksheet. Apply the Title cell style to the merged range A1:G1, and then center the text in that merged range.

New Perspectives Excel 2016 | Module 4: SAM Project 1a Inception Workspace

Merge and center the range A2:G2, and then change the font size of the merged range to 14 pt. Italicize the contents of the range A3:B3, change the font to Times New Romanand then change the font color to Orange, Accent 2 6 th column, 1 st row of the Theme Colors palette.

Abo atash 113

Format cell B3 using the Short Date e. Her salary is calculated by multiplying the number of regular hours worked cell B7 by her hourly rate cell D7and then adding to that the number of overtime hours worked cell C7 multiplied by her hourly rate cell D7 times 1. To calculate the salary for all of the employees, copy the formula you created and the formatting in cell E7 into the range E8:E Copy the formula and the formatting in cell G7 into the range G8:G To quickly see which employees worked overtime, use the Highlight Cells Rules conditional formatting to format cells in the range C7:C10 with a value greater than 0 using Light Red Fill with Dark Red Text.

In cell A11, increase the indent of the cell contents twice. Stephanie would like to know the average number of regular hours worked by her employees. Copy the formula from cell B11 into the range CG11 to find the average of the overtime hours, hourly rates, salaries, work hour totals, and percentage of overtime hours for the team.

In the range G7:G11, apply the Percentage number format with one decimal place. For the merged range AA30, rotate the cell contents to 0 degrees. Hint: You should find and replace two instances. Stephanie plans to print the worksheet to review with her team. Change the page orientation to Landscapeand then set the margins to Wide. She wants the table and the chart to appear on separate pages when printed.

Select cell A13, and then insert a page break. Set rows as print titles. Hint: Rows should repeat at the top of each printed page of the worksheet. Create a custom footer for the worksheet.

1995 nissan pickup meter fuse blown full version

In the leftfooter section, display the current Page Number using a Header and Footer element. In the center footer section, display the Sheet Name using a Header and Footer element. Switch back to Normal View if necessary. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel.

Follow the directions on the SAM website to submit your completed project. We promise to never spam you, and just use your email address to identify you as a valid customer.If you do not see the.

The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. If this add-in is not available on the Data tab in the Analyze group or if the Analyze group is not availableinstall Solver as follows:.

Kylie and Derek Hurdy own Hurdy Headphones, a company that manufactures wireless and noise-cancelling headphones and personalized earphones in Pittsburgh, Pennsylvania. As an intern at the company, you are developing a workbook that includes the financial details of each product line. Kylie and Derek have asked you to use the data to analyze scenarios that involve cutting expenses and raising prices. They want you to find the most profitable mix of products using the most cost-effective means of production.

Switch to the Wireless worksheet. Perform a break-even analysis for wireless headphones as follows:. Create a one-variable data table to calculate sales, expenses, and profits based on the number of wireless headphones sold as follows:. In cell D5, enter a formula that references cell B4, which is the expected units sold for this product. In cell E5, enter a formula that references cell B19, which is the expected total sales for this product.

In cell F5, enter a formula that references cell B20, which is the expected total expenses for this product. In cell G5, enter a formula that references cell B21, which is the expected gross profit for this product.

Select the range D5:G10 and then complete the one-variable data table, using cell B4 as the Column input cell for your data table. Create a two-variable data table to calculate the gross profit based on the number of wireless headphones sold and the price per unit:.

For the range DK19, create a two-variable data table using the price per unit cell B5 as the Row input cell. Switch to the Noise-Cancelling worksheet. Add Sales and Expenses as the vertical axis title and Units Sold as the horizontal axis title. Change the Minimum Bounds of the horizontal axis to Hint: The Maximum Bounds should automatically change to 12, Create two scenarios to compare the costs for standard components and green components in the noise-cancelling headphones as follows:.

New Perspectives Excel 2016 | Module 2: SAM Project 1a (complete solution)

Switch to the Earphones worksheet. Change the colors of the chart to Color 5 1st row in the Monochromatic palette.

new perspectives excel 2016 module 3 sam project 1a

Hint: Depending on your version of Office, the name of the color may be different. For Series 1, set the series name to cell E5. Hurdy Headphones wants to determine whether subcontracting the manufacture of their personalized earphones to other electronics companies would reduce the costs of the earphones. Switch to the Earphone Suppliers worksheet, and then run Solver to solve this problem as follows:. Run Solver, keep the solution, and then return to the Solver Parameters dialog box.

Save the model to the range AA21, and then close the Solver Parameters dialog box. Switch to the All Products worksheet. Use cells BD17 as the result cells.Sign up with Facebook Sign up with Twitter. I don't have a Facebook or a Twitter account. Maureen Meek is doing an internship with Forge and Polish Jewelry.

new perspectives excel 2016 module 3 sam project 1a

One of her assignments is to format the product sales records from to to make it easier to analyze. Sort the data in the BraceletSales table first in ascending order by the Material field and then in the ascending order by the Embellishment field.

Insert a Total Row in the BraceletSales table, and then use the Total Row to calculate the total of the values in both the and fields. Hint: The Total Row should automatically total the values in the field. Maureen decides to create a PivotTable to allow her to better manipulate and filter the BraceletSales table data.

Sort the PivotTable manually by dragging or by using the Move command if necessary. Add the, and fields in that order to the Values area. Go to the Necklace worksheet. Use NecklaceSales as the name of the table.

Maureen notices that the NecklaceSales table is missing a record. Add the following record as shown in bold in Table 1 below to the end of the NecklaceSales table VR Note: You can select all the data and then copy and paste special to match destination formatting. Forge and Polish Jewelry offerings a large selection of earrings. Maureen wants to summarize the Earring sales data using subtotals to show how the type of Material used influences earring sales.

Sort the table by the Material field in ascending order. Convert the table to a normal range. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. The subtotals should use the SUM function and include subtotals for the, and fields. Hint: Make sure to check the summary below data check box if it is not checked automatically.

To do so, she must first update All Products table. Close the Find dialog box. Filter the table to show only records for products with a Gold Material type and a Pearl Embellishment type. VR Note: you can use the flter arrows. Switch to the All Products PivotTable worksheet. Refresh the PivotTable data. Filter the table so that only products with a Pearl embellishment are visible. Create a Slicer that will filter the PivotTable based on the Material field value.

Resize the slicer so that it has a height of 1. Move the slicer so that its upper-left corner appears within cell F3 and its lower-right corner appears within cell J Finally, use the slicer to filter the PivotTable so that only products made of Copperare visible.AnalyZing and Charting Financial Data.

If you do not see the. The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. Casey Byron is the owner of Inception Workspace, a collaborative office building where individuals, startups, or small businesses can reserve work spaces. Casey wants a chart representing the distribution of average hours per week that members utilized Inception Workspace in Switch to the Average Usage worksheet.

Select the range A4:B and create a Histogram chart. Hint: Use the Name box to select the range. Modify the chart as described below:. Resize and reposition the chart so that the upper-left corner is located within cell D4 and the lower-right corner is located within cell K Enter Average Weekly Usage in Hours in as the title of the chart.

Legambiente, tornano i pirati delle alpi: 12 bandiere nere. ecco

Modify the bins used in the chart by setting the Bin Width axis option to Inception Workspace offers a variety of membership packages to fit the needs and budgets of its customers.

Switch to the Annual Income worksheet. Select the range A5:B9, and then create a 2-D Pie chart. Resize and reposition the chart so that the upper-left corner is located within cell K1 and the lower-right corner is located within cell Q Enter Total Annual Income by Package as the chart title.

Apply the Style 6 chart style. In the 3-D pie chart, add data labelsto the chart using the following options:. The data labels should display using the Outside End position option. The data labels should only display the Percentage associated with each slice of the 3-D pie chart. Hint : You may need to uncheck the Valuedata label option.

new perspectives excel 2016 module 3 sam project 1a

The data label should use the Percentage number format with 1 decimal place. In the line chart, modify the Minimum boundsof the vertical axis to be Update the line chart by adding Primary Major Horizontal gridlines and Primary Major Vertical gridlines to the chart area. Format the line chart as described below:. Apply the Arial font and the Blue, Accent 5 font color to the chart title. Casey created a stacked column chart to show how the income generated by each membership package contributed to the total annual income.

He now needs to modify the data and formatting used in the chart. Hint: Do not filter out or hide the data.


About the author

Voodoojar administrator

Comments so far

Shazshura Posted on10:12 pm - Oct 2, 2012

Nach meiner Meinung lassen Sie den Fehler zu. Geben Sie wir werden besprechen.