Question

5. Write the Excel function to carry out the following tasks.
1. To do the total of numbers written in the cell range A2 to G2.
6. Conditional Formatting
¿ To find the average of numbers written in the cell range H1 to H6.
3. To find the highest number in the cell range B2 to G6.
To find the integer part of the number written in the cell K1.
To find the length of the text written in the cell A1.
To extract two characters from the left side of the text written in the ce
To extract four characters from the right side of the text written in the
To check the value of cell Al and to print 'Adult' if it is greater than
print 'Child'.
5
Excel 2010 - Part : 2
49​

Answer 1

Answer:

to do total od a2 to g2 you need to enter a formula called =sum and then select the cell range and then your answer will come

Answer 2

Answer:

a2 anad ag

Explanation:

Hope it helps u

FOLLOW MY ACCOUNT PLS PLS