Project 4

1.       On the “Scores” worksheet, use a function to fill the value of “Full Name” column (column D) by joining “First Name” and “Last Name” which separated by space.

2.       On the “Scores” worksheet, use a function to fill the value of “Total score” (column J) by calculating the total value from column G to column I.

3.       On the “Scores” worksheet, enter a formula in J24 that uses an Excel function to return the “Total score” value of the student that has the highest value.

4.       In cell B3 of the “Data” worksheet, use a function that will display of first three characters from cell A3 and capitalize all of them. Fill the formula to the entire “Code name” column.

5.       On the “Scores” worksheet, use a function to fill the value of “Result” column by showing the text “Pass” if value of “Total score” is greater than or equal to the value of “Benchmark” column. Otherwise, leave it blank

6.       On the “Data” worksheet, in the “Number” column, use a function to count the number of occurrences of countries from the value in “Code” column (column D).

7.       Navigate to cell range named “Academy” and merge all cells of it into a cell without changing alignment.