1.

Mohit has to prepare a report of data of sales. The data sheet is prepared in Open Office Calc. He has to select data from various zones and then has to display data in an order. Explain features of Calc that will help him arrange data in an order. Also suggest an appropriate function in Calc to view the highest sales in a zone.

Answer»

Sorting rearranges the range of cells but filtering only hides temporarily the rows/columns you do not want.

Max( ) : The MAX function is used to find the maximum of numbers in a given range of cells.



Discussion

No Comment Found

Related InterviewSolutions