question archive Margie’s Pots and Pans 1 | Page Due in Canvas Drop Box Instructions: Follow the instruction to build the worksheet

Margie’s Pots and Pans 1 | Page Due in Canvas Drop Box Instructions: Follow the instruction to build the worksheet

Subject:MS ExcelPrice:22.99 Bought3

Margie’s Pots and Pans 1 | Page Due in Canvas Drop Box Instructions: Follow the instruction to build the worksheet. Once the initial worksheet has been completed follow the instructions for each Deliverable. Each deliverable should be on a separate tab of 1 Excel worksheet. You have been hired as an intern at Margie’s Pots and Pans. Margie’s Pots and Pans is a small business that is in the downtown Pensacola area. It was founded on 1 April 1983 and currently has 9 employees. Margie has been using a custom programmed POS (Point of Sale) system that was written in dBase III. The system is hopelessly outdated and there is no support available for it. Margie is looking at updating her systems and wants to split the POS activities from the analytic activities. As part of her Microsoft Office 365 she has Excel and wants to use that software for the initial analytics. For her initial pass she has limited the data to her transactions on the 4th February 2020. The data is contained in two files, MargiesPotsPansInvoices.txt (244 records) and MargiesCustomerData.txt (233 records). The MargiesPotsPansInvoices file is made up of 5 fields: The Invoice #, the customer’s phone number, the date and time of the sale, the type of pot, and the size of the pot. The MargiesCustomerData.txt is composed of 8 fields: the phone number, the customer’s first name, the customer’s last name, their house number, the street name, the city, the state, and their zip code. The Invoice # in MargiesPotsPansInvoices file and the phone # in the MargiesCustomerData file are unique. Because of the age of her current system it does not interface with anything directly, but she was able to dump the data files into a comma delimited format. The date/time field in the MargiesPotsPansInvoices is in a true Julian format so it will interface with Microsoft Office 365 applications. Margie has provided the following table containing the different pots, their size, their retail price and the date that the pots were received. Small Medium Large Received non-stick skillet $9.00 $11.00 $14.00 17 Dec 2019 cast iron skillet $13.00 $17.00 $21.00 9 Jan 2020 stainless steel skillet $10.00 $12.00 $15.00 24 Jan 2020 saucepan $8.00 $10.00 $13.00 31 Jan 2020 roasting pan $15.00 $19.00 13 Jan 2020 double boiler $13.00 $17.00 $22.00 4 Dec 2019 cast iron Dutch oven $20.00 $27.00 9 Jan 2020 Dutch oven $18.00 $23.00 15 Nov 2019 Margie would like you to do some analysis on the data. Specifically, she wants several items, all of which should all be in a single spreadsheet. Margie has identified the following items for analysis. 1) Read the data into an Excel spreadsheet. 2) Margie would like to know how many people bought more than 1 pot. 3) Margie would like you to add the customer’s name to the invoice file. 4) Margie would like to know the total amount of sales. 5) Margie would like to know the descriptive statistics of sales. Margie’s Pots and Pans 2 | Page 6) Margie would like to know how many of each pot was sold, organized by size and type of pot. 7) Margie would like to know how many of each pot was sold and the percentage of total sales for each type of pot. 8) Margie would like to know how long the pots and pans that sold on 4 Feb 2020 were in stock. She would also like a graph of the duration that the pots and pans were in stock. 9) Margie would like to see how a percent change in price will impact the retail price of each pot. Margie’s Pots and Pans 3 | Page 1) Import data from MargiesPotsPansInvoices.txt and CustomerData.txt into an Excel spreadsheet 1.1) Open Excel and name the worksheet Invoices: 1.1.1) Right click on the Sheet1 title on the sheet tab. 1.1.2) Select Rename and type Invoices over the Sheet1 label 1.2) Import the data from MargiesPotsPansInvoices: 1.2.1) Select Data on the tool bar, then select From Text/CSV In this section you will be importing data from two text files that are in a comma delimited format. This means that the files are in ASCII format with a comma between each field. This is a common format used to import/export data. Excel refers to this type file as a .csv file. This is what the MargiesPotsPansInvoices file looks like in Notepad: You will also be formatting the file and adding titles. Note that the date in the file (3rd field starting at the left) is in a true Julian format. The first part of the value, 43865, is the number of days since 1 Jan 1900. The second part which is after the decimal point, .3550, is the percentage of a day and that is used to show the time of day. These values have been truncated at 4 decimal places. Margie’s Pots and Pans 4 | Page 1.2.2) This will open a Windows Explorer window – navigate to the data file and select it. 1.2.3) Select Import. You will see the following window: 1.2.4) Select Load, the data will load into a table in Excel 1.2.5) Select Design under Table Tools 1.2.5.1) Click the bottom slider in the Table Styles area Margie’s Pots and Pans 5 | Page 1.2.5.2) You will get the following options: 1.2.5.3) Select the option in the upper left corner. 1.2.5.4) Uncheck the Header Row, Filter Button, and the Banded Rows buttons. 1.2.6) Insert the following titles: Invoice # in cell A1 Phone # in cell B1 Date/Time in cell C1 Type in cell D1 Size in cell E1 1.2.7) Center the titles: 1.2.7.1) Highlight the titles in Row 1 1.2.7.2) Right click on the highlighted area, select the centering button 1.2.8) Save your work if you haven’t already done so. Keep in mind: Save early, save often. 1.2.8.1) Be sure to save your work as an Excel spreadsheet as sometimes it may try to save as a comma delimited worksheet. 1.3) Insert a column to the left of the data set. 1.3.1) Highlight the A column heading 1.3.2) Right click then select Insert 1.3.3) Insert the title ID# in cell A1 1.4) Insert an ID number for each record. 1.4.1) Enter the number 1 in cell A2, 2 in A3 and 3 in A4 C C Margie’s Pots and Pans 6 | Page 1.4.2) Move your cursor to the box at the bottom right corner of the active cell. This is the Fill Handle. Drag it to the bottom of the data set to complete the series. 1.4.3) Repeat actions from step 1.2.7 to center the values in column A 1.5) Insert a row above the titles that exist in the current titles. Follow the same procedure as in 1.3 except place the cursor over the 1st row indicator. 1.6) Insert the title Margie’s Pots and Pans Data in the new row 1 1.6.1) Merge the cell from column A to column F 1.6.1.1) Highlight the cells from A1 to F1 1.6.1.2) Right click the Merge and Center icon in the menu 1.6.2) Format the title in Times New Roman font size 14 1.6.2.1) Adjust the height of row 1 to accommodate the new font size 1.6.3) Format the color of the title to dark blue 1.6.3.1) Highlight the title and right click 1.6.3.2) Select font color and select blue 1.6.4) Format the date column to 3/14/12 13:30: 1.6.4.1) Select the D column by clicking on the column label 1.6.4.2) Right Click Format Cells… 1.6.4.3) Select Date on Number Tab 1.6.4.4) Use the slider to move to the bottom of the options. Then select the 3/14/12 13:30 option by clicking on it. It will highlight. Select OK to format the column. C C C C Margie’s Pots and Pans 7 | Page The final format of the Invoice worksheet: 1.7) Using the steps 1.2.1 – 1.2.5.4 to import the file MargiesCustomerData.txt into a worksheet named Customer 1.7.1) Insert the following titles: Phone # in cell A1 FirstName in cell B1 LastName in cell C1 StreetNum in cell D1 Street in cell E1 City in cell F1 State in cell G1 Zip in cell H1 1.7.2) Center the titles 1.7.2.1) Highlight the titles in Row 1 1.7.2.2) Right click on the highlighted area, select the centering button 1.7.3) Insert and center the title Customer in the first row using the steps in 1.6.1 – 1.6.3.2 The final form of the Customer worksheet: Margie’s Pots and Pans 8 | Page 2) Margie would like to know how many people bought more than 1 pot. 2.1) Copy the data from the data worksheet (with the tab titled Invoices) into a new worksheet 2.1.1) Open a new worksheet 2.1.2) Name the worksheet MultipleSales 2.1.3) Highlight the cells from A1 to F246 in the Invoices worksheet 2.1.4) Paste the data into cell A1 of the new worksheet 2.1.4.1) You can right click and select paste or press ctrl and v keys simultaneously 2.1.5) Adjust column widths so all data is visible: 2.1.5.1) Double click on the separator between columns and they will adjust to fit the data 2.2) The data must be sorted so that like values will appear next to each other. 2.2.1) Highlight all the data from cells A2 to F246 2.2.2) From the Data menu on tool bar, then select Sort 2.2.3) This will give you the sort window C C C C C There are 2 main activities in this section. First the data must be sorted so like values appear next to each other. Then you need to test to see if two sequential values are the same. Data can be sorted in ascending order (smallest to largest) or descending order (largest to smallest). In general, character data is sorted in ascending order and money and time are in descending order. The second step is to see if two sequential values are the same. This is done with an IF statement. The format of an IF statement is =IF(condition, true, false). You ae going to test if two sequential values are the same, C4=C3. If they are true, print the work “Multiple” (must be in quotes). If they are not the same, print a blank “ “. Complete formula =IF(C4=C3, “Multiple”, “ “) C Margie’s Pots and Pans 9 | Page 2.2.4) Check the box “My data has headers” 2.2.5) Press the arrow in the sort by box, select Phone #, then click the OK. This will sort your data in ascending order (A to Z) 2.3) Insert an IF function in cell G4: 2.3.1) =if(C4=C3,”multiple”,” ”) then press enter 2.3.2) copy the formula down to row 246 (same method as steps 1.4 – 1.4.3) if the formula does not do so automatically. 2.4) Insert the title Multiple Sales in cell E248: 2.4.1) insert the function =countif(G3:G246,”multiple”) in cell G248 Worksheet View Formula View Margie’s Pots and Pans 10 | Page 3) Margie would like you to add the customer’s name to the invoice file. 3.1.1) Open a new worksheet 3.1.2) Name the worksheet WithNames 3.1.3) Highlight the cells from A1 to F246 in the Invoices worksheet 3.1.4) Paste the data into cell A1 of the new worksheet 3.1.4.1) You can right click and select paste or press ctrl and v keys simultaneously 3.1.5) Adjust column widths so all data is visible: 3.1.5.1) Double click on the separator between columns and they will adjust to fit the data 3.2.1) Insert two columns between the C column (Phone #) and D column (Date/Time): 3.2.1.1) Highlight the D column heading 3.2.1.2) Right click then select Insert 3.2.1.3) Repeat steps 3.2.1 - 3.2.1.2 to insert a second column 3.2.2) Insert a vlookup to read the names from the Customer worksheet 3.2.2.1) Highlight the Customer worksheet from A1 to H235 3.2.2.2) Enter Customer in the name box 3.2.2.3) Enter the labels in row 2 of the WithNames worksheet 3.2.2.3.1) FirstName in cell D2 3.2.2.3.2) LastName in cell E2 C C C To accomplish this task, you are going to have to match data from one file then copy it into a second file. The function that you will use is vlookup. The basic format is (what you want to look up, where do you want to look it up, which column do you want returned, do you want an exact match or next higher value). The lookup value is usually a single cell. The where is usually a range. This can be specified by giving the coordinates of the range or the name of the range. The value you are trying to match must be in the first column of the look up range. The offset, the number of the column that you want returned, is an integer where the first column is 1, the second is 2 and so on. Since you are matching phone #s you want an exact match so you will put False as the last element of the vlookup. The final format of the vlookup in this task is: =vlookup(C3,Customer,2,False) and will be in cell D3. It will be repeated in cell E3 with the column returned value changing from 2 to 3. Margie’s Pots and Pans 11 | Page 3.2.3) Enter vlookup formulas to read the data: 3.2.3.1) Enter the formula =vlookup(C3,Customer,2,False) in cell D3 3.2.3.2) Enter the formula =vlookup(C3,Customer,3,False) in cell E3 3.2.3.3) The data should fill the rest of the column. If not, copy the formulas down to row 246 3.2.3.4) Adjust column widths so all data is visible 3.2.3.4.1) Double click on the separator between D & E columns and they will adjust to fit the data Formula View Worksheet View Margie’s Pots and Pans 12 | Page 4) Margie would like to know the total amount of sales. 4.1) Copy the data from the WithNames worksheet into a new worksheet: 4.1.1) Open a new worksheet 4.1.2) Name the worksheet Sales 4.1.3) Highlight the cells A1 to F246 from the WithNames worksheet 4.1.4) Paste the data into cell A1 of the new worksheet 4.1.5) Adjust column widths so all data is visible 4.1.6) Add the title Cost to cell I2 4.2) Create the following data table on the new worksheet named Costs 4.2.1) Format the cells B3 to D10 as currency with 2 decimal places. 4.3) Highlight the cells from A2 to D10 4.3.1 name the range Costs by entering Costs in the name box In this task the vlookup statement is expanded to include an IF statement. Placing one function inside of another function is known as an imbedded function. The first activity is to create a new worksheet and input the cost data for each size and type of pot. When building a complex function like this one it is often done in steps. Get the basic vlookup working, add the first IF, then add the second IF. The IF statements will be used to identify which column to return. Margie’s Pots and Pans 13 | Page 4.4) Building the combined vlookup and IF statements 4.4.1) enter the function=VLOOKUP(G3,costs,3,FALSE) in cell I3 of the Sales worksheet 4.4.1.1) copy it down to row 16, note that only the values for small are correct 4.4.2) edit the function in cell G3 adding the first IF function 4.4.2.1) the new function=VLOOKUP(G3,costs, IF(H3="small",2,3),FALSE) 4.4.2.2) copy it down to row 16, note that the values for small and medium are correct 4.4.3) edit the function in cell I3 adding the second IF function 4.4.3.1) the new is function =VLOOKUP(G3,costs,IF(H3="small",2,IF(H3="medium",3,4)),FALSE) 4.4.3.2) copy it down to row 16, note that the values for all pots are correct NOTE: if you get a #NA# as a result in column I it means that there is not a match in the costs table for the value you are looking up. The best way to correct this is to copy the value from one table and paste it in the other. In this case since you have multiple values in the data table and only 1 in the costs table your best bet is to copy the value in Column G from the value in the Sales worksheet and paste it over the value in the Costs table. They may look the same but often there are extra spaces at the end of the label or some other Margie’s Pots and Pans 14 | Page 4.4.4) copy the formula down to row 246 4.4.5) format the I Column as currency with 2 decimal places 4.4.5.1 click on the I Column header 4.4.5.2) Right click and select Format Cell 4.4.5.3) under number currency with 2 decimal places Formula View Worksheet View Note that there are several options when formatting currency. A commonly used one in spreadsheets is the bottom one where a negative number is in red and in parenthesis. This makes it very visible when it is mixed in with a bunch of numbers in a column. Margie’s Pots and Pans 15 | Page 5) Margie would like to know the descriptive statistics of sales. 5.1) Copy the data from the Sales worksheet into a new worksheet: 5.1.1) Open a new worksheet 5.1.2) Name the worksheet Statistics 5.1.3) Highlight the cells from A1 to I246 on the Sales worksheet 5.1.4) Paste the data into cell A1 of the new worksheet 5.1.5) Adjust column widths so all data is visible 5.2) Insert titles in Column K: 5.2.1) Insert the title Mean in cell K3 5.2.2) Insert the title Median in cell K4 5.2.3) Insert the title Minimum in cell K5 5.2.4) Insert the title Maximum in cell K6 5.2.5) Insert the title Standard Deviation in cell K7 5.2.6) Insert the title Count in cell K8 5.2.7) Adjust the width of the K column so all the titles fit One of the first levels of analytics, understanding your data, is descriptive statistics. They provide a quick overview of what is happening in your data set. Excel has an extensive library of statistical functions that can be viewed by entering statistical functions in the help window. Margie will get the basic statistics of Average (sum of the values/number of items), Median (the middle value of the data set), Minimum (the smallest value in the data set), Maximum (the largest value in the data set), Standard Deviation (a measure of how spread out is the data) and the Count (how many items are in the data set). Margie’s Pots and Pans 16 | Page 5.3) Insert statistical functions in Column L and format all results as a number with 2 decimal points. 5.3.1) Insert the function =average(I3:I246) in cell L3 5.3.1.1) format the result as a number with 2 decimal points 5.3.2) Insert the function =median(I3:I246) in cell L4 5.3.3) Insert the function =min(I3:I246) in cell L5 5.3.4) Insert the function =max(I3:I246) in cell L6 5.3.5) Insert the function =stdev(I3:I246) in cell L7 5.3.5.1) format the result as a number with 2 decimal points 5.3.6) Insert the function =count(I3:I246) in cell L8 Formula View Worksheet View Margie’s Pots and Pans 17 | Page 6) Margie would like to know how many of each pot was sold, organized by size and type of pot: 6.1) Highlight the data from the Sales worksheet between cells B2 and I246 6.2) On the tool bar select Insert, then Pivot Table 6.3) You will get a dialog window to create a pivot table: 6.3.1) Since you highlighted the data prior to opening the pivot table dialog the date range is already loaded into the dialog box. 6.3.2) Choose the location for the pivot table. Usually this will be a New Worksheet. Select OK to continue. 6.4) You will get a new worksheet with the following structure: The easiest way to accomplish this task is with a pivot table. A pivot table is basically a cross tabulation where you put one value on the horizontal axis and another value on the vertical axis. At the intersection of each row and column there will be the value that meets those criteria. There are multiple options on what will be displayed at the intersection. Margie’s Pots and Pans 18 | Page 6.5) Populating the Pivot Table: 6.5.1) Drag/drop Type from the PivotTable Fields area into the Rows area 6.5.2) Drag/drop Size from the PivotTable Fields area into the Columns area 6.5.3) Drag/drop Type from the PivotTable Fields area into the ∑ Values area 6.5.3.1) note the operation in front of the variable name. This can be changed by pressing the down arrow. 6.6) Rename the tab TotalsbyTypeSize Margie’s Pots and Pans 19 | Page 7) Margie would like to know how many of each pot was sold and the percentage of total sales for each type of pot: 7.1) Follow steps 6.1 to 6.4 to create a blank pivot table. 7.2) Populating the Pivot Table: 7.5.1) Drag/drop Type from the PivotTable Fields area into the Rows area 7.5.2) Drag/drop Type from the PivotTable Fields area in the ∑ Values area 7.5.2.1) note the operation in front of the variable name. This can be changed by pressing the down arrow. 7.5.3) Drag/drop Type again in the ∑ Values area 7.5.3.1) The layout area will look like 7.5.3.2) Left click on the arrow to display the option menu 7.5.3.3) Select Value Field Settings 7.5.3.4) This will display the Value Field Settings dialog box 7.5.3.5) Select the Show Values As tab 7.5.3.6) Click on the down arrow at the end of the No Calculation box 7.5.3.7) Select % of Column Total, then click OK 7.6) Name the tab TypePercentage Step: 7.5.3.5 Step: 7.5.3.6 Step: 7.5.3.7 Final Pivot Table In this task you are going to look at some of the optional features for configuring your pivot table. You will be reusing a variable and will configure it different ways. Margie’s Pots and Pans 20 | Page 8) Margie would like to know how long the pots and pans that sold on 4 Feb 2020 were in stock. She would also like a graph of the duration that the pots and pans were in stock: 8.1) Open a new worksheet 8.2) Name the worksheet Duration 8.3) Enter the following labels: 8.3.1) In cell A4, non-stick skillet, in B4, 17 Dec 2019 8.3.2) In cell A5, cast iron skillet, in B5, 9 Jan 2020 8.3.3) In cell A6, stainless steel skillet, in B6, 24 Jan 2020 8.3.4) In cell A7, sauce pan, in B7, 31 Jan 2020 8.3.5) In cell A8, roasting pan, in B8, 13 Jan 2020 8.3.6) In cell A9, double boiler, in B9, 4 Dec 2019 8.3.7) In cell A10, cast iron dutch oven, in B10, 9 Jan 2020 8.3.8) In cell A11, dutch oven, in B11, 15 Nov 2019 8.3.9) in cell B3, Received 8.3.10) in cell C3, Sold 8.3.11) in cell D4, InStock 8.4) Enter the sold date (Feb 4, 2020 for all products) in cell C4 8.4.1) Copy this date down to cell C11 8.5) Calculate the time in stock 8.5.1) Enter the formula =C4-B4 in cell D4 8.5.2) Copy the formula down to cell D11 In this task the first part is focused on date arithmetic. You will create a table with the names of the pans, the date they arrived in stock, and the date that they were sold. In this case the sold date for all pots and pans is 4 Feb 2020. Since Excel treats all dates as a true Julian date this is possible. Dates are stored as the number of days since 1 Jan 1900. You use formatting to display the date in a more recognizable form. You treat date arithmetic just like any other formula. In this case you simply subtract one date from the other then format the result as a number. The second task is to create a graph of the results. A vertical bar chart was selected because it allows for a quick visual comparison of the time in stock. Since only one variable is being displayed in this chart a pie chart could have been used, but the vertical bar chart is easier to read. The chart is then formatted to increase ease of reading. Margie’s Pots and Pans 21 | Page 8.5.3) Format the results as a number with 0 decimals places using the steps in 4.4.5 8.6) Create a bar graph of how long each pot/pan was in stock: 8.6.1) To select the data, to be used in the bar graph, press and hold the ctrl key and highlight Col A from row 4 to row 11, keeping the ctrl key depressed highlight Col D from row 4 to row 11. 8.6.2) Select Insert from the toolbar, then the Bar Chart icon in the Charts area. A menu of chart types will appear. Select the 2D clustered chart. The Chart will appear on the spreadsheet. C C Worksheet View Formula View C Margie’s Pots and Pans 22 | Page 8.6.3) Configuring the chart: 8.6.3.1) Click on the + to the right of the chart This will open the Chart Elements menu 8.6.3.2) Select Axis Titles and Data Labels - the Chart Title (checked by default) allows you to title the graph to explain what it is. Replace the default Chart Title with Graph of Number of Pots Sold. - the Axis Titles allow you to enter a description of what is displayed on each axis. Enter Number of Days on the vertical axis and Type of Pot on the horizontal axis. - the Data Labels places the numeric value above each column Initial Graph Completed Graph Margie’s Pots and Pans 23 | Page 9) Margie would like to see how a percent change in price will impact the retail price of each pot: 9.1) Open a new worksheet and name the worksheet PercentAdjustment 9.2) Copy the following labels from the Costs worksheet: 9.2.1) Go to cell A3 of the PercentAdjustment worksheet and type = 9.2.2) Navigate to cell A3 on the Costs worksheet, click on the cell to select it, and press Enter 9.2.2.1) the formula in cell A3 of the PercentAdjustment worksheet will be: =Costs!A3 9.2.3) Copy the formula in cell A3 down to cell A10 9.2.3.1) Adjust the width of the A column so all the labels fit 9.3) Copy the following labels from the Costs worksheet: 9.3.1) Go to cell B2 of the PercentAdjustment worksheet and type = This task is all about addressing. In the first part you will copy a cell from one worksheet to another. The way you copy a cell is by placing its address in the target cell. As an example, if you wanted to copy the contents of cell C20 to cell E30 you would enter =C20 in cell E30. To copy a cell from another worksheet you would enter the worksheet name followed by an exclamation point then the cell address. As an example, if you wanted to copy cell B25 from a worksheet named Totals into cell A5 of the current worksheet you would enter =Totals!B25. Instead of typing the address the pointer method is often easier. Simply type = in the target cell, navigate to the cell you want to copy, and press enter. In the second part you will copy the cell you referenced above to its neighboring cells. Simply grab the handle in the bottom right corner of the active cell and drag it where you want to copy it. The cell address will change with the direction of movement. If you are dragging it, one cell horizontally the formula =A5+A6 will change to =A6+A7. If you drag vertically the column designator will change. This is known as relative addressing. If you want to copy a cell but you do not want the address to change place a $ in front of the column/row designator. In Windows this can be accomplished by pressing the F4 key. Repeated pressing will move the $ from column to row, to both, and then remove it. This is referred to as absolute addressing. In the final part you will want to grow the targeted amount by a percentage. The formula to do this is =original value * (1 + growth rate). Given the order of operations in Excel the parenthesis is required so the addition will take place before the multiplication. Since the growth rate is in a single cell and will be copied to multiple cells you will want to use absolute addressing to refer to it. Since you want the address of the original value to change as you copy it you will use relative addressing for it. Margie’s Pots and Pans 24 | Page 9.3.2) Navigate to cell B2 on the Costs worksheet, click on the cell to select it, and press Enter 9.3.2.1) the formula in cell B2 of the PercentageAdjustment worksheet will be: =Costs!B2 9.3.3) Copy the formula in cell B2 across to cell D2 9.3.3.1) Adjust the width of the B, C, & D columns so all the labels fit 9.4) Enter the label Enter % Change: in cell A1 9.4.1) Format cell B1 so it is a percentage with 2 decimal places using the steps in 4.4.5 9.4.2) Enter .1 in cell B1, it should display as 10.00% 9.5) In cell B3 type = then navigate to cell B3 on the Costs worksheet, click on the cell to select it, and press Enter 9.5.1) the formula in the cell will be: =Costs!B3 9.5.2) Edit the formula so it is: =Costs!B3*(1+$B$1) 9.5.2.1) The cell should display 9.9 (a 10% increase over the original 9.00 price) 9.6) Fill in the rest of the table 9.6.1) Copy cell B3 across to cell D3 9.6.2) While the cells B3 to D3 are active, copy them down to row 10

Option 1

Low Cost Option
Download this past answer in few clicks

22.99 USD

PURCHASE SOLUTION

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 3 times

Completion Status 100%