MS Excel Assignment Tasks || MS Office Tools || IICT

MS Excel Assignment Tasks || MS Office Tools || IICT 

Description:

                    This task is given to All students of first semester for the assessment for their Skills related to the MS Excel this assignment task will focus on the main three tabs and their operations such as :

data tab peepgram

insert tab Peepgram

home tab peepgram

All above mention tab will contained the relevant information and operation to perform task in the given assignment for the reference please watch all the relevant videos.

Assignment Tasks:
for this task please use the sample Excel data sheet which we used in our lab Link. you have to perform task on the sheet provided:

1. All data should be format as table.
2. All item which have Total less than 200 will be highlighted as red.
3. create pivot table on the new sheet for the summary of the sheet you can use any column of your choice for filter, column, rows and summation.
4.  create simple chart for the data available on the sheet you can insert any chart of your choice.
5. submit you excel sheet in which all the tasks performs on the Link. only Excel sheet will be accepted. Last date for submission is 30-04-2020 at 11:59 pm. 

Best of luck