As PureAssignment official, we help students from all around the world with their Excel projects. Orthographic Dashboard Assignment is only one of them! If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.
To analyze and report on employment data for the Human Resources department at Orthographic
|ID||Employee ID number (unique)||text||ID is written in format “e###-###”|
|FIRST||Employee first name||text||Do not include middle initials|
|LAST||Employee last name||text||Do not include middle initials|
|DEPT||Employee department||text||Accounting, Administration, Customer Support, Human Resources, Finance, Marketing, IT, R&D, or Sales|
|HIRE DATE||Date of employee hire||date||Use the date format mm/dd/yyyy|
|OFFICE||Location of the employee office||text||Boston, Chicago, Dallas, Denver, or San Francisco|
|STATE||Employee office state||text||Use two-letter abbreviation in capital letters (MA, IL, TX, CO, or CA)|
|BASE SALARY||Employee base salary||number||Use currency format; do not include bonuses or commission fees|
|BONUS||Employee end-of-year bonus||number||Use currency format; do not include base salary or commission fees|
|COMMISSION||Employee commission fee||number||Use currency format; do not include base salary or bonuses|
|PERSONAL DAYS||Days excused from work with pay||number||The number of days taken by the employee for personal days|
|SICK DAYS||Sick days with pay||number||The number of days in which the employee received sick-day benefits|
|EVAL SCORE||Year-end employee evaluation||number||Evaluation scores range from 1 (poor) to 5 (excellent)|
Calculated Fields Related with Orthographic Dashboard Assignment
|FULL NAME||Employee first and last name||text||Calculate by combining the FIRST and LAST field separated by a single space|
|HIRE YEAR||Year of employee hire||number||Calculate by extracting the year value from the HIRE DATE field|
|WAGES||Total employee wage compensation||number||Calculate by adding the BASE SALARY, BONUS, and COMMISSION fields|
Where to start to get The Best Excel Homework Help Service?
Choose PureAssignment for reliable, secure, and high-accuracy online Excel help services that guarantee your academic success. If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.