Question: please help me figure out the exact formulas I should be typing in to reciecve correct answer for each. all must be answered in order

please help me figure out the exact formulas I should be typing in to reciecve correct answer for each. all must be answered in order to be correct. first picture is the list of directions when it say "requirements"the second picture is the actual excel sheet

Requirements Please respond to these inquiries on the Financial Highlights worksheet by creating the appropriate formula. 1. Are net revenues AND operating profit higher in 2016 than they were in 2012? Write a formula using the IF and AND functions that displays "Both" in the blue cell (616) if both increased. If both measures did not increase, then the formula should display "Not Both" in the cell. 2. Are both gross profit AND operating profit higher in 2016 than they were in 2012? Write a formula using the IF and AND functions that displays "Both" in the red cell (G18) if both increased. If both measures did not increase, then the formula should display "Not Both" in the cell. 3. Did net revenues OR gross profit decrease between 2013 and 2014? Write a formula using the IF and OR functions that displays "Decrease" in the green cell (G20) if at least one of the measures decreased. If neither measure decreased, then the formula should display "No decrease in the cell. 4. Did net revenues OR gross profit decrease between 2015 and 2016? Write a formula using the IF and OR functions that displays "Decrease in the yellow cell (G22) if at least one of the measures decreased. If neither measure decreased, then the formula should display "No decrease in the cell. $ 969 Tables Sys F H M th Copy BLU- EEZE Dobou A 1616 Roth, "Not both, Financial ins) A Flogical test value of true false 1

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 Accounting Questions!

Hi please help with questions 3 and 4 in the first picture, the answers to 1 and 2 are in the second picture. Please include excel formulas, I will thumbs up if answer is correct thank you...

Please help with questions 1 - 5 utilizing the attached tables. If the tables are not correct please assist. Please see project 4 answers attached below Thank You. Yes. questions 1-5 at the top....

Please help to figure out data analysis (like calculation questions) at the bottom of the screenshot based on the statistics that showed in this case, and it is not necessary to write the whole...

Hi, Can someone please help with these questions? I'm so confused. Please label the number of the question next to the answer and I need the answers to these questions in less than an hour please...

I need assistance in figuring out what is wrong with my C++code. I have written a function to update the values in my array but when I run the program the values do not increment. They stay the same....

Please help me figure out what the incorrect ones are, thank you, thumbs up for corrections. Problem 13-01A a-c DeLong Corporation was organized on January 1 the first year. 2020 It is authorized to...

I need help to the excel IMPLEMENTATION Use Table 10.1 and Figure 10.1 to help you understand the parameter values and to enter the employees' input data correctly. Make sure you format the numeric...

Please read the question Question: On pages 5 and 6 the authors write, "Narrative provides not only meaning but also a mental framework for imbuing future experiences and information with meaning, in...

Please, note that, the problem itself does not have a very long solution, and the task condition is short, I just left a detailed description of how I see the solution to this problem. I ask you,...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

For the following circuit, a) Find the Complex Power delivered by the source Find the Average Power absorbed by the 8 2 resistor Find the Reactive Power absorbed by the capacitor 822 my b) c) 4/0...

A nylon thread is to be subjected to a 10-N tension. Knowing that E=3.2 GPa, that the maximum allowable normal stress is 40 MPA, and that the length of the thread must not increase by more than 1%,...

What other investment information would you need to evaluate Coca - Cola common stock? Where would you obtain this information?

Reyes Corp., an event management firm, permits its employees to dress up for work in shorts, T - shirts, and flip - flops. In the context of the 7 S model of organizational alignment, which of the...

3.58 What is the conditional probability of regular, given high income? Table 3.10 Probabilities for Television Viewing and Income VIEWING FREQUENCY Regular Occasional Never Totals HIGH INCOME MIDDLE...

3.57 What is the conditional probability of low income, given occasional? Table 3.10 Probabilities for Television Viewing and Income VIEWING FREQUENCY Regular Occasional Never Totals HIGH INCOME...

3.56 What is the conditional probability of high income, given never? Table 3.10 Probabilities for Television Viewing and Income VIEWING FREQUENCY Regular Occasional Never Totals HIGH INCOME MIDDLE...