Vlookup

Salam..



1) Find the total marks for each of students.
2) In Grade column, find the vlookup value based on table in left hand side.
3) Find the average, min, max of the total marks and also find the vlookup value for each answers. (You may use any cell at the Excel to show the result).

Lab Quiz (5%)

Salam..


Answer the following question based on the tables above.

1. Insert data for Person table ('6', 'Siti', 'Bestari Jaya', '22').

2. List all value from Company table. (YearofWork is greater than 7).

3. List column Name, Address from Person table . (Age is less or equal with 30).

4. Update from Company table where the Position is equal with 'Accountant' and set the Workplace as '456 Co.'.

5. Sort in ascending the Person table accordingly with the age.

Good Luck ;)