Enter a formula in cell B1 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the current monthly rents by the remaining months on each lease. Use the range names Rents and Leases.

answer; /// i believe that the above statement is ( true ); the firms competencies are its strengths, the firm is likely to have the most success if it focuses on these finding customers whose needs it can meet using these

the correct answer would be b, when, queen, calder hall and london.

explanation:

we always capitalize words when a paragraph or sentence is starting, when an important name is used, when a place is being written, or simply when a noun is used, etc. so in this sentence, sentence is starting from 'when', so it will be written in capital letters. secondly, queen is considered to be an important person, so it will also be written in capital letter. next, the name of the town is mentioned, i-e calder hall, which will also be written in capital letters. in the last,   city name is being used, 'london', which will also be written in capital letters. so option b is the most appropriate one.