a. Create table "STUDENT" with attributes "STUDENT_ID", "STUDENT_NAME", "STUDENT GPA". b. Use appropriate datatype for each attribute. c. Insert details of three students. Use FOR loop to print these details in the descending order (Highest first and Lowest last) of 2 their GPA.

Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.

When a lot of changes are required in data, which one should be a preference to be used? String or StringBuffer?

The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out. To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation. Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column. In the appropriate cell below the staff table, use a function to display the current date without displaying the time. The averages will not be needed, so delete column O. The date for the next update isn't certain, so hide row 18. Switch to the Budget worksheet, which contains the department budgets from 2021 to 2025. There's already a pie chart showing 2021 budget information, and Carmelo wants another…