(Solved) : Paragraph Project Description New Accounting Assistant Kelly S Computer Services Asked Exp Q41408660 . . .

Help Solve in Excel i need the formulas
Paragraph Project Description: as the new accounting assistant at Kellys Computer Services you have been asked to expand upoParagraph Styles Complete the Monthly Snapshot table by creating the following named ranges Name cell range A25 A29 Monthly PEmphasis A-D-A- Heading 1 Heading 2 ab x x 1 Normal 1 Normal Font Paragraph Styles Created On: 07/05/2019 YO16_XL_BU0 GRADER> Wrap Tad Accounting Paste Colibri V11 VAA BIUSA. Font Conditional Formatting Format as Table Styles Colle Styles Fon Clipbo17 8GB RAM 18 16GB RAM > $ TU.UU 200.00 2 3 Monthly Snapshot Goal Actual 50 Outcome 24 Totals by Item 25 Hard Drives 26 FlashParagraph Project Description: as the new accounting assistant at Kelly’s Computer Services you have been asked to expand upon the content of an existing spreadsheet that tracks hardware sales over a three-month time period. The owner wants a monthly snapshot report as part of he spreadsheet, which will help track sales for future orders Steps to Perform: Instructions Points Possible Step Start Excel. Open the downloaded Excel file named e03 grader_a2_Kelly Computers.xlsx Save the file with the name e03_grader_a2_4Kelly Comp LastFirst replacing LastEkst with your last and first name. 10.8 A table has been set up with inventory information, but new functions need to be developed to create a monthly snapshot table. First, the table must be cleaned up and some cells recalculated to check the accuracy of the formulas used On the Sales Data worksheet, in cell F4, create a formula that will perform a calculation tha multiplies the Unit Price by the sum of products sold for January February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March Copy the formula and then paste it in cells F5, F7 F9, F11 F12, F14 F15, and F17F18 Resize the column as needed. In cells C6:E6, C10:E10, C13E13C16:E16, and C19 E 19. use a function to total the product sales for January through March Your supervisor has requested an area on the spreadsheet that quickly summarizes sales over the past few months. In cell C25, calculate the sum for the Hard Drive category that totals the three months results in C6 E6. Use a similar formula in cells C26 C29 substituting the correct formula cell references for each product. In cell D25, create an IF function that will determine if sales goals have been met for each product listed. Return Goal Met if true, otherwise return Not Met. Copy the formula, without formatting, to cells D26:D29 7.2 Complete the Monthly Snapshot table by creating the following named ranges: Name cell range A25 A29 Monthly ProdList Name cell range B25:B29 Goals Name cell range C25 C29 Actual. Goals. o te w Paragraph Styles Complete the Monthly Snapshot table by creating the following named ranges Name cell range A25 A29 Monthly ProdList Name cell range B25 B29 Goals Name cell range C25 C29 Actual. Goals Name cell range A25 C29 Product Items Your supervisor would also like you to call out a product item that has reached a company monthly goal. In cell 15, create an INDEX with a nested MATCH function that will index the data in the Monthly Snapshot table to return a product item in the cell that matches the displayed goal of the month in cell 14. Use named ranges in the formula Created On: 07/05/2019 YO16_XL_BU03_GRADER PS4 AS – Kelly Computers 1.3 Grader – Instructions Excel 2016 Project Step Instructions Points Possible 12 Your supervisor asks you to compare products for goals met versus the products for goals not met Click in cell A25. Create a Pivot Table on a new worksheet named PixotAnalysis that summarizes the items by the sales goals and actual sales of the items Add the Totals by Item field to the Rows area, and then add the Goals and Actual fields to the Values area (in that order) o Šte Emphasis A-D-A- Heading 1 Heading 2 ab x x 1 Normal 1 Normal Font Paragraph Styles Created On: 07/05/2019 YO16_XL_BU0 GRADER PS4 AS Kelly Computers 13 Excel 2016 Project Step instructions Points Possible Your supervisor asks you to compare products for goals met versus the products for goas not mel. Click in cel A25. Create a Pivot Table on a new worksheet named PivotAnalysis that summardes the items by the sales a nd a s of the items Adathe Totals by item field to the Rows area, and then add the Goats and Actual fields to the Valses area (in that Order Create a clustered column Pivot chart Note Mac users select the range A3 C9, on the Insert tab, click Recommended Charts, and then chek Chisted Column Move the chart some upper left comer is in cel A15 and the lower right comer is in the 63. Add the chart title Sales Goals vs Actual Goals Save your workbock, Ex Excel and then submit your fe as directed by your instructor Total Points > Wrap Tad Accounting Paste Colibri V11 VAA BIUSA. Font Conditional Formatting Format as Table Styles Colle Styles Fon Clipboard Alignment March Total Product 4 64GB Hard Drive 5 128 GB Hard Drive Unit Price $ 150.00 $ 249.00 Monthly Sales January February 12 11 7 6 12 Product of the Month Goal Product 8.00 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive $ $ 10.00 15.00 18 10 11 15″ Monitor 12 18″ Monitor 13 14 Keyboard 15 Ergo Keyboard 20.00 35.00 $ 17 8GB RAM 18 16GB RAM 150.00 200.00 $ Sales Data Type here to search о не в DELL 17 8GB RAM 18 16GB RAM > $ TU.UU 200.00 2 3 Monthly Snapshot Goal Actual 50 Outcome 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM Sales Data Ready Type here to search |o te Show transcribed image text Paragraph Project Description: as the new accounting assistant at Kelly’s Computer Services you have been asked to expand upon the content of an existing spreadsheet that tracks hardware sales over a three-month time period. The owner wants a monthly snapshot report as part of he spreadsheet, which will help track sales for future orders Steps to Perform: Instructions Points Possible Step Start Excel. Open the downloaded Excel file named e03 grader_a2_Kelly Computers.xlsx Save the file with the name e03_grader_a2_4Kelly Comp LastFirst replacing LastEkst with your last and first name. 10.8 A table has been set up with inventory information, but new functions need to be developed to create a monthly snapshot table. First, the table must be cleaned up and some cells recalculated to check the accuracy of the formulas used On the Sales Data worksheet, in cell F4, create a formula that will perform a calculation tha multiplies the Unit Price by the sum of products sold for January February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March Copy the formula and then paste it in cells F5, F7 F9, F11 F12, F14 F15, and F17F18 Resize the column as needed. In cells C6:E6, C10:E10, C13E13C16:E16, and C19 E 19. use a function to total the product sales for January through March Your supervisor has requested an area on the spreadsheet that quickly summarizes sales over the past few months. In cell C25, calculate the sum for the Hard Drive category that totals the three months results in C6 E6. Use a similar formula in cells C26 C29 substituting the correct formula cell references for each product. In cell D25, create an IF function that will determine if sales goals have been met for each product listed. Return Goal Met if true, otherwise return Not Met. Copy the formula, without formatting, to cells D26:D29 7.2 Complete the Monthly Snapshot table by creating the following named ranges: Name cell range A25 A29 Monthly ProdList Name cell range B25:B29 Goals Name cell range C25 C29 Actual. Goals. o te w
Paragraph Styles Complete the Monthly Snapshot table by creating the following named ranges Name cell range A25 A29 Monthly ProdList Name cell range B25 B29 Goals Name cell range C25 C29 Actual. Goals Name cell range A25 C29 Product Items Your supervisor would also like you to call out a product item that has reached a company monthly goal. In cell 15, create an INDEX with a nested MATCH function that will index the data in the Monthly Snapshot table to return a product item in the cell that matches the displayed goal of the month in cell 14. Use named ranges in the formula Created On: 07/05/2019 YO16_XL_BU03_GRADER PS4 AS – Kelly Computers 1.3 Grader – Instructions Excel 2016 Project Step Instructions Points Possible 12 Your supervisor asks you to compare products for goals met versus the products for goals not met Click in cell A25. Create a Pivot Table on a new worksheet named PixotAnalysis that summarizes the items by the sales goals and actual sales of the items Add the Totals by Item field to the Rows area, and then add the Goals and Actual fields to the Values area (in that order) o Šte
Emphasis A-D-A- Heading 1 Heading 2 ab x x 1 Normal 1 Normal Font Paragraph Styles Created On: 07/05/2019 YO16_XL_BU0 GRADER PS4 AS Kelly Computers 13 Excel 2016 Project Step instructions Points Possible Your supervisor asks you to compare products for goals met versus the products for goas not mel. Click in cel A25. Create a Pivot Table on a new worksheet named PivotAnalysis that summardes the items by the sales a nd a s of the items Adathe Totals by item field to the Rows area, and then add the Goats and Actual fields to the Valses area (in that Order Create a clustered column Pivot chart Note Mac users select the range A3 C9, on the Insert tab, click Recommended Charts, and then chek Chisted Column Move the chart some upper left comer is in cel A15 and the lower right comer is in the 63. Add the chart title Sales Goals vs Actual Goals Save your workbock, Ex Excel and then submit your fe as directed by your instructor Total Points
> Wrap Tad Accounting Paste Colibri V11 VAA BIUSA. Font Conditional Formatting Format as Table Styles Colle Styles Fon Clipboard Alignment March Total Product 4 64GB Hard Drive 5 128 GB Hard Drive Unit Price $ 150.00 $ 249.00 Monthly Sales January February 12 11 7 6 12 Product of the Month Goal Product 8.00 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive $ $ 10.00 15.00 18 10 11 15″ Monitor 12 18″ Monitor 13 14 Keyboard 15 Ergo Keyboard 20.00 35.00 $ 17 8GB RAM 18 16GB RAM 150.00 200.00 $ Sales Data Type here to search о не в DELL
17 8GB RAM 18 16GB RAM > $ TU.UU 200.00 2 3 Monthly Snapshot Goal Actual 50 Outcome 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM Sales Data Ready Type here to search |o te

Expert Answer


Answer to Paragraph Project Description: as the new accounting assistant at Kelly’s Computer Services you have been asked to expan…