# We Helped With This Excel Programming Homework: Have A Similar One?

SOLVED
Category Programming Excel College Solved Excel Help Online

## Assignment Description

Inventory

Project Description:

In the following project, you will edit a worksheet that summarizes the inventory of Condiments and Toppings at the Pasadena facility.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download and open the file named go_e02_grader_a3.xls. 0 2 Change the Theme to Ion. Rename Sheet1 as Condiments and Sheet2 as Toppings. Click the Condiments sheet tab to make it the active sheet. 3 3 To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. As necessary, type Item # as the column title in column C and Category as the column title in column D. 5 4 Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. 3 5 Display the Toppings worksheet, and then repeat Steps 3 and 4 on this worksheet. 8 6 Without grouping the sheets, make the following calculation in both worksheets: • In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result. • In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. 9 7 Without grouping the sheets, make the following calculation in both worksheets: • In cell B10, enter a COUNTIF function to determine how many different types of Relish are in stock on the Condiments sheet and how many different types of Salsa are in stock on the Toppings worksheet. 2 8 Without grouping the sheets, make the following calculation in both worksheets: • In cell G14 type Stock Level. In cell G15, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 75 the Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the formula down through all the rows. 4 9 Without grouping the sheets, apply the following formatting in both worksheets: • Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic with a Font Color of Dark Red, Accent 1. Apply Gradient Fill Red Data Bars to the Quantity in Stock column. 4 10 In the Condiments sheet, format the range A14:G42 as a table with headers and apply Table Style Light 20. Insert a Total Row, filter by Category for Relish, and then Sum the Quantity in Stock column. Record the result in cell B11. 6 11 Clear the filter from the table. Sort the table on the Item Name column from A to Z, remove the Total Row, and then convert the table to a range. On the PAGE LAYOUT tab, set Print Titles so that row 14 repeats at the top of each page. 6 12 In the Toppings sheet, format the range A14:G42 as a table with headers and apply Table Style Light 19. Insert a Total Row, filter by Category for Salsa, and then Sum the Quantity in Stock column. Record the result in cell B11. 6 13 Clear the filter from the table. Sort the table on the Item Name column from A to Z, remove the Total Row, and then convert the table to a range. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. 6 14 Group the two worksheets. Merge and center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge and center the subtitle in cell A2 across the range A2:G2 and apply the Heading 3 cell style. Center the worksheets Horizontally, change the Orientation to Landscape, display the Print Preview, and then change the Settings to Fit All Columns on One Page. 7 15 In Backstage view, on the left click Save, and then click the Condiments sheet tab to cancel the grouping. Click the Toppings sheet tab, and then insert a new worksheet. Change the sheet name to Summary and then widen columns A:D to 23.57 width [170 pixels]. Move the Summary sheet so that it is the first sheet in the workbook. 4 16 In cell A1, type Valley View Inventory Summary. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type As of June 30 and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. 3 17 On the Condiments sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. 2 18 In the Summary sheet, in cell B4, type Condiments. In cell C4 type Toppings. In cell D4 type Condiments/Toppings. Center the column titles, and then apply the Heading 3 cell style. 3 19 In cell B5, enter a formula that references cell B4 in the Condiments sheet so that the Condiments Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Condiments sheet into the Summary sheet in the range B6:B9. 5 20 Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Toppings worksheet. 5 21 In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Condiments and Toppings columns. Format the sparklines using the styles in the first row as follows: D5: Sparkline Style Accent 1, Darker 50% D6: Sparkline Style Accent 2, Darker 50% D7: Sparkline Style Accent 3, Darker 50% D8: Sparkline Style Accent 4, Darker 50% D9: Sparkline Style Accent 5, Darker 50% 5 22 To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. 4 23 Insert a custom footer in the left section with the file name.  Ensure that the worksheets are correctly named and placed in the following order in the workbook: Summary, Condiments, Toppings. Save and close the worksheet. Exit Excel. Submit the file as directed. 0 Total Points 100

## Assignment Description

GO! ECH03 A2 - Benefit Analysis 2.2

Project Description:

In the following project, you will edit a worksheet that will be used to prepare a five-year forecast of the costs associated with employee benefits.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download and open the file named go_e03_grader_a2.xlsx. 0.000 2 Change the Theme Colors to Blue II. In cell A1 type City of Orange Blossom Beach and then Merge & Center the title across columns A:F. Apply the Title cell style to the merged cell. 4.000 3 In cell A2 type City Employee Benefit Analysis 2012 to 2016 and then Merge & Center the subtitle across columns A:F. Apply the Heading 1 cell style to the merged cell. 4.000 4 In the range B4:F4, fill the year range with the values 2012 through 2016. Type Average Annual Cost Per Employee in cell A5, type Percent Increase in cell A6. 6.000 5 Change the width of column A to 31.00 (222 Pixels), and then change the width of columns B:F to 11.00 (82 Pixels). In cell B5, enter 21842; in cell C5, enter 24385; in cell D5, enter 25938; in cell E5, enter 26742; and in cell F5, enter 27560. 10.000 6 Apply the Currency [0] cell style to the values in B5:F5. Apply the Heading 1 cell style to the years and apply the Heading 4 cell style to the range A5:A6. 6.000 7 In cell C6, construct a formula to calculate the percent of increase in annual street maintenance costs from 2012 to 2013. Format the result with the Percent Style and then fill the formula through cell F6 to calculate the percent of increase in each year. 10.000 8 In cell A8, type Projected Employee Benefit Costs and then use the Format Painter to copy the formatting from cell A2 to cell A8. Type Projected Increase in cell A10, and then type Year in cell A12. 4.000 9 In cell A13, type Projected Costs and then in the range B12:F12, use the fill handle to enter the years 2016 through 2020. Apply Bold to the years. Copy the contents of cell F5 and paste to cell B13. Type 3% in cell B10. 6.000 10 To the range A10:B10, apply Bold and Italic. 4.000 11 In cell C13, construct a formula to calculate the annual projected employee benefit costs for the year 2017 after the projected increase of 3% is applied. Fill the formula through cell F13, and then use Format Painter to copy the formatting from cell B13 to the range C13:F13. 6.000 12 In cell A15, type Projected Estimates 2016 to 2020 and then use Format Painter to copy the format from cell A8 to cell A15. In cell A17, enter Year; in cell A18, enter 3% Increase; and in cell A19, enter 5% Increase. 6.000 13 Copy the range B12:F12, and then Paste the selection to B17:F17. Copy the range B13:F13 and then paste the Values & Number Formatting to the range B18:F18. Complete the Projected Estimates section of the worksheet by changing the Projected Increase in B10 to 5% and then copying the range B13:F13 and pasting the Values & Number Formatting to B19:F19. 10.000 14 Select rows 8:24, and then insert the same number of blank rows as you selected. Clear Formatting from the inserted rows. By using the data in A4:F5, insert a Line with Markers chart in the worksheet. Move the chart so that its upper left corner in positioned in cell A9. 10.000 15 Format the Bounds of the Vertical (Value) Axis so that the Minimum is 21000 and the Major unit is at 2000. 4.000 16 Format the Fill of the Chart Area with a Texture fill by applying the Blue Tissue Paper texture. Format the Border of the Chart Area by applying a Solid line using Turquoise, Accent 1, Darker 50%. Change the Width of the border to 2. Format the Plot Area with a Solid fill using White, Background 1. 6.000 17 Click cell A1 to deselect the chart. From the Page Setup dialog box, center the worksheet Horizontally. Insert a custom footer in the left section with the file name. Change the orientation to Landscape, and then in the Print Preview, under Settings, change the scaling to Fit All rows on One Page. 4.000 18 Save and close the workbook. Exit Excel. Submit the file as directed. 0.000 Total Points 100.000

## Assignment Description

Department Expenses

Project Description:

In the following project, you will edit a worksheet that will be used to summarize the departmental administration expenses for the City of Orange Blossom Beach.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download and open the file named go_e03_grader_a3.xlsx. 0 2 In the Expenses worksheet, calculate row totals for each Expense item in the range F5:F9. Format F6:F9 with Comma Style, zero decimal places. Calculate column totals for each quarter and for the Annual Total in the range B10:F10. 4 3 In cell G5, construct a formula to calculate the Percent of Total by dividing the Annual Total for City Manager by the Annual Total for Totals by Quarter. Use absolute cell references as necessary, format the result in Percent Style, and then Center. Fill the formula down through cell G9. 4 4 Create a 3-D Pie chart to chart the Annual Total for each item using the ranges A5:A9 and F5:F9. Move the chart to a new sheet and then name the sheet Administration Costs Chart. 6 5 For the chart title, type Summary of Administration Costs and format the chart title using WordArt Style Fill – Dark Red, Accent 1, Shadow—in the first row, the second style. Change the chart title font size to 28. 10 6 Remove the Legend from the chart and then add Data Labels formatted so that only the Category Name and Percentage display positioned in the Center. Change the data labels Font Size to 12, and apply Bold and Italic. 6 7 Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to Circle. Set the Top bevel Width and Height to 50 pt and then set the Bottom bevel Width and Height to 256 pt. Change the Material to the fourth Standard Effect—Metal. 10 8 Display the Series Options, and then set the Angle of first slice to 140 so that the City Manager slice is in the front of the pie. Select the City Manager slice, and then explode the slice 10%. Change the Fill Color of the City Manager slice to a Solid fill using Dark Red, Accent 1, Lighter 40%—in the fifth column, the fourth color. 4 9 Format the Chart Area by applying a Gradient fill using the Preset gradients Light Gradient – Accent 4. Format the Border of the Chart Area by adding a Solid line border using Brown, Accent 4 and a 5 pt Width. 6 10 Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name. 4 11 Display the Expenses worksheet, and then by using the Quarter names and the Totals by Quarter, insert a Line with Markers chart in the worksheet. Move the chart so that its upper left corner is positioned slightly inside the upper left corner of cell B12. As the Chart Title, type Annual Administration Expenses by Quarter. 6 12 Format the Bounds of the Vertical (Value) Axis so that the Minimum is 1085000 and the Major unit is at 10000. Format the Fill of the Chart Area with a Gradient fill by applying the Preset gradient Light gradient Accent 3—in the first row, the third gradient. Format the Plot Area with a Solid fill using White, Background 1—in the first column, the first color. 6 13 Copy the Annual Total in cell F10 and then use Paste Special to paste Values & Number Formatting in cell B35. In cell C35, construct a formula to calculate the Projected Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill the formula through cell F35, and then use Format Painter to copy the formatting from cell B35 to the range C35:F35. 10 14 Change the Orientation of this worksheet to Landscape, and then use the Scale to Fit options to fit the Height to 1 page. From the Page Setup dialog box, center the worksheet Horizontally, and insert a custom footer in the left section with the file name. 10 15 Display the Projected Decrease worksheet. In cell C5, calculate the Percent of Total for the first department, apply Percent Style, and then copy the formula down for the remaining expenses. 4 16 Copy cell B5, and then use Paste Special to paste the Values & Number Formatting to cell B13. Copy and Paste cell C5 to cell C13. With cell C13 selected, use Goal Seek to determine the goal amount of City Manager expenses in cell B13 if the value in C13 is set to 15%. 6 17 From the Page Setup dialog box, center this worksheet Horizontally, and insert a custom footer in the left section with the file name. 4 18 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Administration Costs Chart, Expenses, Projected Decrease. Save and close the workbook. Exit Excel. Submit the file as directed. 0 Total Points 100

## Assignment Description

GO! ECH04 A2 - Formula Auditing 1.1

Project Description:

In this project, you will add lookup functions to an order form. You will also use the Formula Auditing features and visual inspection to find and correct several types of errors.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook named GO_e04_Grader_a2_start.xlsx. 0.000 2 Display the Advertising Rate Information sheet, select the range A4:C11, and Sort in ascending order by Code. 10.000 3 Name the range A4:A11 using Create from Selection. 10.000 4 Display the Advertising Order Form sheet; in the range A9:A18 create a data validation list using the defined name Code. Click cell A9, click the list arrow, click D-TV. 10.000 5 With cell B9 as the active cell, insert a VLOOKUP function that will look up the Description from the Advertising Rate Information sheet using the Item number. Ensure that the Table_array is entered as an absolute reference. 12.000 6 With cell B9 as the active cell, fill the VLOOKUP formula through cell B18. The results will appear as #N/A until the item numbers are added to column A. 2.000 7 In cell C9, type 2 as the Quantity ordered; in cell D9, type Trade. 4.000 8 With cell E9 as the active cell, insert a VLOOKUP function to look up Unit Price. Ensure that the Table_array is entered as an absolute reference. 8.000 9 Copy the VLOOKUP formula in cell E9 through cell E18. The results will appear as #N/A until the item numbers are added to column A. 2.000 10 Add the following orders in rows 10, 11, and 12: Item Quantity Type D-R     4       Regional D-PH   5       National B-BB  12      Billboard 6.000 11 Delete the unused rows in the order form, sum the Order Amount, and apply the Total cell style to the total Order Amount. 5.000 12 On the Sales Data tab, click cell I5, which displays a green triangle indicating a potential error, and then on the FORMULAS tab, click Trace Precedents. Click Error Checking, and then click Edit in Formula Bar. Change \$B\$14 to \$B\$15 so that the formula is using the Growth Assumption for Vases, not for Bouquets. 8.000 13 On the FORMULAS tab, in the Formula Auditing group, click Error Checking to begin checking for errors from this point in the worksheet. In cell M6, the flagged error, notice the formula is trying to divide by cell L10, which is empty. Click Edit in Formula Bar, change 10 to 9 and then in the Error Checking dialog box, click Resume. 8.000 14 In cell F7, examine the error information, and then click Copy Formula from Above. 4.000 15 Examine the error in cell J8, and then click Copy Formula from Left. Click OK. 4.000 16 Use Format Painter to copy the format in cell M5 to cell M6. 4.000 17 Group the worksheets. Center the worksheets horizontally, set the Width to 1 page, and then set the Orientation to Landscape. Add the Tags advertising costs, Springfield revenue to the document properties. 3.000 18 Ensure that the worksheets are still grouped; and correctly named and placed in the following order in the workbook:  Advertising Order Form, Advertising Rate Information, Sales Data. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

 Regular homework \$20 - \$150 Advanced homework \$100 - \$300 Group project or a report \$200 - \$500 Mid-term or final project \$200 - \$800 Live exam help \$100 - \$300 Full thesis \$1000 - \$3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for \$100, we could tell that the price is \$200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On