2 Table Management
Explication de la tâche .
As you can imagine holding a table for your employees can be one hell of a challenge. Keeping it up to date and functionnal will be a challenge that might take you time and effort.
This file is a sample student list and inside of it you will find information on our employees Gender, Position, Status, Job Rating and Salary.
The most infamous one is the Job Rating. It is a score from 1 to 5, 1 being the lowest and 5 the highest. Managers were in charge of ranking their employees with these scores and we are now plagued with this important performance index.
You are now in charge of this important office document!
Here are some requirements you have to build with it:
Add yellow and white banded lines for ease of reading
Print a list of all junior staff from first hired to last hired in PDF format
Find average salaries for Full time, Half time and contract staff
🌶 Défi épicé . 🌶
Comment faire.
The first step to making this happen will be to create a table from your data. To do this simply hit CTRL-T or Insert Tab > Table while selecting a cell inside the range of data.
Once that is completed you should be able to change the style of the table by going on new CONTEXTUAL TAB called "table Design" or "Table Tools" (only shows up if you are clicking in the table) and Choose a table style that fits the requirements for the exercise.
You just finished the first objective! Well done!
The second thing you will need to get done is print a list of ONLY the junior staff in order of from eldest hire to newest hire. To do this you must use the filters located on the headers of each collumn.
These filters have shown up when you made your table and now let you modify and edit comfortably your data. For this second objective, you will need to hit the Position Filter and choose only the juniors and then hit the Hired Date Filter to sort them from eldest to newest.
Awesome you filtered and sorted the data!
Notice the blue numbers on the right side, that means a filter is active. Don't forget to remove it once your done!
To finish the next objective you need to export this to a PDF! All you gotta do is go to the File Tab > Export > Create PDF/XPS and choose where you want to save it! Huuuzzzza, you've made a clean PDF of only the juniors in the apt order!
Wow! So nice you finished the second objective!
Now for the last one, you will need to get your totals row to be able to find the averages of each status.
We start by Right Clicking in your table and go to Table > Totals Row. This will create a total row at the bottom of the table which sums the salaries together. Sadly, the sum is not what we require. Simply, click on the total and change it to Average! Once this is done, all you need to do is filter by position and see the new average change. Mark it down for each answer and you will have finished the exercise!
