Question

Use the following table and write formula to answer the following questions:

1. In cell F3, calculate total number of offices of ICICI in the 4 cities.

2. In cell B9, find out maximum number of offices by a company in Delhi city.

3. In cell F6, write formula to calculate minimum number of offices of TATA amongst the 4 cities.

4. In cell E9, find out in Bangalore city, what is the average number of offices by all the companies.

5. In cell C9, find total number of offices in Mumbai cities for ICICI, SBI and Edelweiss companies.

6. In cell D9, find average number of offices in Ahmedabad city for TATA, HDFC and PNB companies.​

Answer 1

Answer:

1. 2372

2. By Edelweiss - 37

3. Bangalore

4. 48 offices

5. 94 offices

6. 117 offices....

Hope it helps you...

Answer 2

Explanation:

• In Microsoft Excel, when we proceed to find the sum of a group of cells, we use the SUM function to calculate the sum of the values of the selected cells. The SUM function accompanies the initial cell position and the final cell position separated by a ratio symbol :

For calculating total number of offices of ICICI in all the 4 cities, we need to write the function as,

=SUM(B2:E2)

• In Microsoft Excel, when we proceed to find the maximum of a group of cells, we use the MAX function to calculate the maximum of the values of the selected cells. The MAX function accompanies the initial cell position and the final cell position separated by a ratio symbol :

In cell B9, the maximum number of offices by a company in Delhi city is

=MAX(B2:B8)

• In Microsoft Excel, when we proceed to find the minimum of a group of cells, we use the MIN function to calculate the minimum of the values of the selected cells. The MIN function accompanies the initial cell position and the final cell position separated by a ratio symbol :

In cell F6, formula to calculate minimum number of offices of TATA amongst the 4 cities

=MIN(B6:E6)

• In Microsoft Excel, when we proceed to find the average of a group of cells, we use the AVERAGE function to calculate the average of the values of the selected cells. The AVERAGE function accompanies the initial cell position and the final cell position separated by a ratio symbol :

In cell E9, in Bangalore city, the average number of offices by all the companies.

=AVERAGE(E2:E8)

• In cell C9, total number of offices in Mumbai cities for ICICI, SBI and Edelweiss companies

=SUM(C3:C5)

• In cell D9,  average number of offices in Ahmedabad city for TATA, HDFC and PNB companies.

=SUM(D6:D8)

Learn more here

https://brainly.in/question/17098931

Learn more

https://brainly.in/question/48738430