Question

who will put correct answers I will mark as brainliest​

Answer 1

Answer:

(A) Formula sum bracket A To E close kk

Answer 2

Answers:

a. To Calculate the Total sales of North Zone, write the formula given below,

$\dag\underline{\boxed{\tt=SUM(B3:E3)}}$

Explanation: The SUM() function of MS-EXCEL is used to calculate sum of numbers in a given range. Here, total sales of North Zone is present in the range B3 : E3. So, we wrote the formula =SUM(B3 : E3).

b. The feature used for arranging the Sales from Lowest to the Highest is - Sort feature (Lowest to Highest) present in editing group of Home Tab.

c. To Find the Maximum Sales in the East Zone, write the formula given below,

$\dag\underline{\boxed{\tt=MAX(B5:E5)}}$

Explanation: The MAX() function in MS-EXCEL is used to calculate maximum of numbers in a given range. Here, Sales of East Zone is in the range B5 : E5. So, we wrote the formula =MAX(B5 : E5)

d. To Find the average sales in Jan-Mar in cell C7, write the formula given below,

$\dag\:\underline{\boxed{\tt =AVERAGE(B3:B6)}}$

Explanation: The AVERAGE() function in MS-EXCEL is used to calculate the average of numbers in a specific range. Here, the Sales in Jan-Mar is present in the range B3 : B6. So, we wrote the formula =AVERAGE(B3 : B6)

e. To Find the difference between the sales in East Zone and the West Zone in Apr-Jun, write the formula given below,

$\dag\:\underline{\boxed{\tt =C5-C4}}$

Explanation: The Sales in East Zone (in Apr-Jun) is present in the location C5 and that of West Zone is present in C4. So, to find out the difference, we wrote the formula = C5 - C4