Create a file in LibreOffice Calc showing marks of students obtained in a semester with separate columns for assignments and semester end exam. Sort the file alphabetically and ascending order of marks. Add a bar chart representing the data.

1. Open LibreOffice Calc and create a new spreadsheet.
2. In the first row of the spreadsheet, create column headings for "Student Name", "Assignments", "Semester End Exam", and "Total Marks".
3. In the subsequent rows, enter the name of each student in the first column, and their corresponding marks for assignments and semester end exam in the next two columns.
4. In the fourth column, use a formula to calculate the __________ _________ ___ ________ ____.
   ___ ______ _______ _________ _______.
   ________ _________ __________ ______ __________.
   _____ ____ ________ ____ ________ ______ ______.
   _______ _________ ____ ___ ____.
   _______ _______ ______ _________ _______ __________.
   _________ _______ _____ _______ ____ _____ ____ ____.
   ___ ________ ___ ________ _______ _______ ________ ______ ________ _________ ___.
   ____ ____ ________ ________ ___.
   _______ _________ _______ _______ ___ _________ _________ ______.
   __________ ______ _____ ______ __________ _______ _________.
   ____ __________ _________ ____ __________ __________ __________ ___.
   _____ ___ _________ ____ __________ _________.
   ______ _______ ___ ____ ______ ___ ______ __________ ____ ___.
   _____ ______ ____ ________ _________ ___ _______ ____ ___ ______.
   ______ _______ _______ _______ ___ _________ ______ _____ ______ ______ ____.
   __________ _____ ____ ________ ____ _________ _______ _________ ___.
   __________ _______ __________ ___ ______ __________ __________.
   ________ _____ ____ _________ _______ ____ ____ __________ ____ ___.
   _____ _________ ________ ___ ___ __________ _________ ____.
   _______ ____ ___ ______ _________.
   ______ ____ ___ ____ ____.
   _________ _________ ______ __________ _______ ______ ____ ________ ____.
   ________ ________ _________ ______ _______.
   ______ _______ _____ _________ _____ __________ ______ _________ ______.
   _____ ____ ___ _________ _____ ___ ___.
   ____ _____ __________ ______ _____.
   ________ __________ ____ _____ ________ __________ _____ _______.
   Get Full Answer on WhatsApp