Digital company wants to make a statistic study of its sales force in Spain. The company has the information contained in the following table:
They also
have a commissions table used to calculate commissions and bonus. The bands are
the following ones:
So you will have to complete the tasks listed below:
1) Insert
a title in red and Arial 12 letters. The title has to be the name of the
company.
2) Improve
the spreadsheet:
- The letters of the column’s titles
should be 12 green Comic sans.
- Apply borders to the cells or even
colors.
- Apply currency format with two
decimals to the sales column.
3) Calculate
the commissions the sellers are going to obtain considering the bands established
by the company.
4) Calculate
the bonus the sellers are going to receive taking into account the bands of the
table.
5) Obtain
the total net sales of the company.
6) Calculate
the salary of each employee.
The commissions and the bonus of each
employee are difficult to calculate. So I recommend you to watch the video
included for a clue and, if after all you don’t find the solution, ask me. I
will be glad to help you. You will also need to use the tutorials included in the last practice.
So cheer up
and don’t faint!
