Question: Using the substitute function, what is the formula for the below: You have been tasked to create a table for 2015 and 2016 cost data.

Using the substitute function, what is the formula for the below:

You have been tasked to create a table for 2015 and 2016 cost data. You have already created the same list for sales data in the previous two years. Using the data on the left and the substitute formula to replace 2013 with 2015 and 2014 with 2016, create a new list in the right-hand column.
Substitute
Sales Data
Quarter 1, 2013
Quarter 2, 2013
Quarter 3, 2013
Quarter 4, 2013
Quarter 1, 2014
Quarter 2, 2014
Quarter 3, 2014
Quarter 4, 2014

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Q:

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Q:

Overview You are a business analyst at E Corp, an e-commerce company headquartered in the United States with offices and operations in both the U.S. and Canada. To meet strategic growth objectives...

Q:

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Q:

Hello I have been having a problem with this excel assignment and I had posted it yesterday but I haven't get helped since please help me the excel details instruction is attacked SDSU Accounting...

Q:

Hello I have been having a problem with this excel assignment and I had posted it yesterday but I haven't get helped since please help me the excel details instruction is attacked SDSU Accounting...

Q:

Excel Project 1 MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title...

Q:

Excel Project 1 MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title...

Q:

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Q:

Warren Buffett?s Annual Shareholder Letter (page numbers for your convenience, but may not be comprehensive) 1. Describe the methods Warren Buffett uses to measure both his own firm?s performance and...

Q:

The Shamrock Vegetable Company has the following results. Net sales ............ $6,000,000 Net total assets ..........4,000,000 Depreciation ........... 160,000 Net income ............ 400,000...

Q:

PT boats plan a $2.25 a share dividend at the end of each of the next 2 years at the end of year 3, it will pay a final liquidating dividend of $15 a share after that, the company plans to close its...

Q:

Four statements about automatic repeat requests (ARQs) are given below, but they are not in the correct order. Put the statements into their correct sequence. i the sending computer waits for a...

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...