Due to the health emergency and longer winter break, I approached the next task.
of any doubt we are in contact, we communicated by mail.
Prof. Patricia Zurita
Task:
1) Open the Excel workbook. Place header (name of student). Subsequently make the points below.
2) Name the current sheet as financial control and then focus
labels columns, wrap text in the cell and define yellow fill all simple edges.
3) Calculate the amount fee for each registration form. This amount comes from dividing the requested loan plus the% charge in the cell defined by the number of assessments for each case.
Note: 2 to 6 installments fee is charged, in the F1 cell contains the value 10% surcharge.
4) Insert a column labeled as VAT after the Amount column and share it calculated for each record the value of VAT on the amount defined according to the% share in the corresponding cell.
5) Total fee in the column should show the total (amount in taxes) for each share.
6) In a new sheet called Statistics to display the total charge for each credit. For this column should be copied Customer Total Tuition and Fee Issue. In a column labeled as Total Payable at the end of this form, calculate the value that corresponds to the sum of all fees for each credit.
7) Save the current workbook with the name Cuentas.xls and send to: prof.patriciazurita @ gmail.com
labels columns, wrap text in the cell and define yellow fill all simple edges.
3) Calculate the amount fee for each registration form. This amount comes from dividing the requested loan plus the% charge in the cell defined by the number of assessments for each case.
Note: 2 to 6 installments fee is charged, in the F1 cell contains the value 10% surcharge.
4) Insert a column labeled as VAT after the Amount column and share it calculated for each record the value of VAT on the amount defined according to the% share in the corresponding cell.
5) Total fee in the column should show the total (amount in taxes) for each share.
6) In a new sheet called Statistics to display the total charge for each credit. For this column should be copied Customer Total Tuition and Fee Issue. In a column labeled as Total Payable at the end of this form, calculate the value that corresponds to the sum of all fees for each credit.
7) Save the current workbook with the name Cuentas.xls and send to: prof.patriciazurita @ gmail.com
* I approached to see material
0 comments:
Post a Comment