Question

An assignment was given to Sanjiv and Vibha by their teacher. They were shown the screen shot given

below and were asked to answer the following questions:

a. What happens when the formula =B2+C2 is entered in D2

b. What happens when the formula of D2 is copied over to D6

c. What will happen if we modify the formula in the cell D6 to =$B6+$C6?

d. Teacher asked Sanjiv to add one more column „Flight Name‟ before Base Fare. Suggest him how

he will do.

e. Suggest the Excel function to find the highest Base fare of flights.​

Answer 1

Answer:

i•B2+C2 then 130+2300 =2430

ii. B3 +C3= 490+2190=2680

iii. then also=295+3040=3335