You are supposed to create an excel sheet consisted to 20 records in it. The data file should not match other students’ data. (10 marks) You need to perform the following Excel options on your data
1. Calculate percentage in one column
2. Apply nested If Function on one column
3. Apply conditional formatting on one column
4. Calculate working days in one column
5. Apply countIf on one column
6. Concatenate the strings ( first name last name in one column)
7. Apply data validation rules ( string, numeric and list) on 3 columns
8. Apply group and un-group data option
9. Apply text to column option on data
10. Make line, pie and bar graph from the data