Question: Phase 2 : Implement Advanced Operations and Functionalities Tasks: 1 . Implement Excel - like Functions: sum _ cells ( spreadsheet , range ) :
Phase : Implement Advanced Operations and Functionalities Tasks: Implement Excellike Functions: sumcellsspreadsheet range: Sum the values within a specified range. averagecellsspreadsheet range: Calculate the average of values within a specified range. mincellsspreadsheet range: Find the minimum value within a specified range. maxcellsspreadsheet range: Find the maximum value within a specified range. Data Type Conversion: converttofloatspreadsheet row, col: Convert the value of the specified cell to a float. converttostringspreadsheet row, col: Convert the value of the specified cell to a string. Sorting: sortrowspreadsheet row: Sort the specified row in place if all values in the row are of the same type. Otherwise, display the message Cannot sort row: values are of different types without doing the sorting. sortcolumnspreadsheet col: Sort the specified column in place if all values in the column are of the same type. Otherwise, display the message Cannot sort column: values are of different types without doing the sorting. Expected Output: Users can perform arithmetic operations on ranges of cells. Data type conversions can be executed on specified cells. Rows and columns can be sorted in place.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
