Question

What is the output of following function , if values of cells A1:A4 are 12,10,8,4. =Average(A1:A4,6)

Answer 1

Answer:

Explanation:

Its syntax is:

=MAX(number1, number2, .......) where argument type is Number and return type is Number.

To know the highest of the cell values ranging from A1, A2, A3, ........ to An, the function will be written as:

=MAX(A1, A2, A3, ......., An)

     OR

=MAX(A1:An)

Question 4

Answer 2

Answer:

Zhdydykdskysysjsysyidiydkydysjsgjddjsttsutsjtstdjnyattntsjsisyei what isiidykskysyidgststsso