Create a file MS Excel, giving it the name "Zadanie_1." Search the Internet for information about the dollar and the euro for the current week of the current year. Copy the data on the model considered in the computer lab №2 Workshop (Part 1) Figure 2.13 on List 1 and List 2 books you have created Excel. Rename sheet 1 in the "dollar" and rename it to Sheet 2 "euro".
Arrange to get a table, as shown in Figure 2.13 Computer Workshop (Part 1).
On a sheet of "dollar" plot the dynamics of the dollar and decorate it according to the figure 2.19 practical lesson number 2 computer workshop (part 1).
On a sheet of "euro" plot the dynamics of the euro and to design it in accordance with Figure 2.19 practical lesson number 2 computer workshop (part 1).
Save the file "Zadanie_1" folder you created in the "Test".
Create a file MS Excel, giving it the name "Zadanie_2." Open the file named "Zadanie_2" and on the first sheet
create a table modeled on the table, pattern represented 2.23 Computer workshop (part 1).
How to do it?
Imagine that you are an employee of the company, which employs 10 people. Fill in your own content columns "Name", "Sex", "Birthday" (think of the data or take your work colleagues or your fellow students), "date of employment", "The salary" (here you can dream up but did not take his "high" from reality).
Further, according to the pattern discussed in Table 2.23, calculate the age and experience you invented 10 employees, respectively, filling out the remaining two columns "Age" and "work experience."
Determine the number of employees over 35 years old. Apply for a job, as shown in Figure 2.23.
Save the file "Zadanie_2" folder you created in the "Test".
The earlier you have created a working folder "Test" create a file MS Excel, giving it the name "Zadanie_3", and proceed to the assignment.
Open the file you created and copy jobs from the 2 two columns - "Name" and "The salary" in the list Open your file "Zadanie_3."
Add the resulting two-column table of the third column, calling it the "Financial assistance to leave."
Using logical functions discussed in practical work №3 first part of the computer workshop, determine the size of the financial assistance to employees.
Conditions for allocation of financial assistance are:
if the salary of the employee no more than (less than or equal to) 20 000 p., the financial aid allocated to the release of 5% of the salary;
if the salary of the employee for more than 20 000 rub., the financial aid allocated to the leave at a rate of 3% of salary.
If your employees´ salaries are not included in the proposed range in the problem, then resize the salaries so that the task was different solutions.
In the columns "Name" and "Financial assistance to the release of" build on the same piece of the pie chart to include the signature value in the sectors chart.
Save the file "Zadanie_3" folder you created in the "Test".
The earlier you have created a working folder "Test" create a file MS Excel, giving it the name "Zadanie_4", and proceed to the assignment.
Make a table for the calculation of rent for tenants of 10 apartments, presented in the screenshot below (the remaining 7 apartments area and the number of living people need to come up with your own).
For the calculation you need the raw data, that you take from the top of the table represented by the screenshot - tariffs.