Inova Lights In Stores

the 2nd the 3rd TM

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

* I approached to see material

absolute and relative references

View more documents from pablo0101 .

Wording For A Giftcard Bridal Shower

Excel Offset property - VBA

Offset property
--------------------
offset property allows 2 arguments that correspond to the position on the cell. Example


--------

Object.offset (RowOffset, ColumnOffset)

ActiveCell.Offset (0, 0). Select 'as we put 0 for the arguments row and column selection
remains our initial active cell.


Activecell.0ffset (1.0). Select 'now the active cell is a line below


' if our initial active cell hubise now been active cell A1 A2 would

Activecell.0ffset Msgbox (1 , 0).
address

is also important to note that you get an error if you assign or tratamoos we move to a range of non-existent.



eg ActiveCell.Offset (-5, 0). Select 'we throw an error because there is no range is selected it would be 5 rows up from A2.


Similarly we can move between varying the value colmnas ColumnOffset

ActiveCell.Offset (0, 1). Select 'Move one column to the right

We may also use these arguments (RowOffset, ColumnOffset) to indicate where to move or assign a value to a particular cell. Sub


sample_vba_offset ()



As Range Dim RANGE RANGE
September
= Range ("B1")



RANGO.Offset (2, 4). Value = "27 May Champions Grand Final League - 2009 "

'we move below 2 rows and 4 columns to the right





End Sub' eye ... the same way you get an error if we try to move or assign a value to a range not existing.

ActiveCell.Offset (0, -3). Select 'move 3 columns to the left