Question: a . Enter the formulas = MIN ( B 4 - B 5 , 0 ) and MIN ( B 5 - B 4 ,

a. Enter the formulas =MIN(B4-B5,0) and MIN(B5-B4,0) in cells B7 and B8 and copy them across. b. Enter the formulas =MAX(B4,-B5,0) and MAX(B5,-B4,0) in cells B7 and B8 and copy them across. c. Enter the formulas =MAX(B4-B5,0) and MAX(B5-B4,0) in cells B7 and B8 and copy them across. d. none of these choices work. You need to use IF functions.

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:

Volllmer Manufacturing makes 3 components for sale to refrigeration companies. The components are processed on two machines; a shaper and a grinder. The times (in minutes) required on each machine...

Q:

Which step in the bottleneck? A. Surface mounting B. All three steps C. Baking D. Final assembly What is the capacity utilization of the surface mounting step ? A. 3% B. 60% C. 80% D. 100% . What is...

Q:

What is the average idle time for the final assembly step during the production of a batch of PCBs? A. 2 min B. 4 min C. 0 min D. 190 min To increase the production capacity of circuit boards, in...

Q:

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Q:

All calculations must be shown to the side of your cell where calculations are required for the Current and Debt Ratios. Parta) Adjusting enteries are completed correctly Adusting entries are posted...

Q:

PART 2: - OPTIMAL PORTFOLIO CONSTRUCTION: (9 marks) In its simplest form, portfolio theory is about finding the balance between maximizing your return and minimizing your risk. The objective is to...

Q:

Can you please answer with formulas? M N 0 2 1 Analysis of Waiting Lines Assignment You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not...

Q:

2 On January 1, 2017, Silicon Valley Bank purchased 3% bonds having a face value of $25,000,000,000 to yield a 2% market rate. 3 The bonds are dated January 1, 2017 and mature January 1, 2027 (10...

Q:

All I know is that I am to use an imaginary company that I make up other than that I don't know what to do. This is what I was given. This is all the information I was given. The company was not...

Q:

Homework 3 - Bar Codes Java 1 Description The Zone Improvement Plan (ZIP) Code is used by the Postal Service to efficiently deliver mail. For this assignment, we will only consider the first...

Q:

Name the industry sectors that rely the most on franchising to tap foreign markets?

Q:

A manufacturer of sports drinks has randomly sampled 198 men and 202 women. Each sampled participant was asked to taste an unflavored version and a flavored version of a new sports drink currently in...

Q:

Ction One: Multiple Choice Questions Saved The net present value method is a better method of evaluation than the internal rate of return method because: Multiple Choice 0 2 1 1 : 0 3 the NPV method...

Q:

The following accounts appear in the ledger of Marigold Corp. after the books are closed at December 31,2019 Common Stock, no par, $2 stated value, 399,000 shares authorized; 293,000 shares issued...