1
00:00:01,389 --> 00:00:15,230
This is the second exercise. We have finished this one. This is the second. This is what you have here. And now you have to complete the table with the data that is given to you.

2
00:00:15,230 --> 00:00:29,149
So, just copy, registro de ventas, fecha de venta, and 01, 03, 02, and all the data that is given.

3
00:00:46,719 --> 00:00:57,250
For making it easier, I copy from here, copy, paste, paste, copy, and paste here.

4
00:00:57,250 --> 00:01:12,849
Next one, cantidad, alt, plus, enter, vendida, ok, precio, alt, plus, enter, unitario.

5
00:01:12,849 --> 00:01:23,200
Next one is IMPORTE SIN IVA.

6
00:01:23,200 --> 00:01:26,959
We need to open a new line here.

7
00:01:26,959 --> 00:01:33,530
IMPORTE DEL DESCUENTO

8
00:01:33,530 --> 00:01:43,450
IMPORTE CON DESCUENTO

9
00:01:43,450 --> 00:02:03,379
THE TAX AND THE FINAL PRICE

10
00:02:03,379 --> 00:02:13,300
And we can copy the color.

11
00:02:13,300 --> 00:02:31,979
And for making this line, go to Combinari Central and you've got it.

12
00:02:31,979 --> 00:02:38,979
Okay, cantidad vendida, copy the figures, 20, 32, 22, 32.

13
00:02:38,979 --> 00:02:47,979
For the price, I copy again from product A, control C and here with a control press, control V.

14
00:02:47,979 --> 00:02:52,979
And 3 euros, control C, copy and paste.

15
00:02:52,979 --> 00:02:59,080
Importe sin IVA. It's equal to the quantity by the unitary price.

16
00:02:59,699 --> 00:03:05,280
Importe del descuento. Here I'm going to make some luck.

17
00:03:06,919 --> 00:03:14,659
Importe del descuento se calcula sobre el importe sin IVA y hay que multiplicarlo por este 7,5% que es el descuento.

18
00:03:14,659 --> 00:03:24,439
but since I want to do the self-filling here like here if I do the self-filling this is an error

19
00:03:24,439 --> 00:03:38,939
because it takes me 21 and then it takes 0 no I don't want this is to do for that I fix the row and the column with the dollar

20
00:03:38,939 --> 00:03:57,340
importe con descuento is this amount minus this one so um this minus this one perfect

21
00:03:57,340 --> 00:04:05,860
and for eva the value added tax is exactly the same as here but with this one 21 percent take

22
00:04:05,860 --> 00:04:19,000
this value and multiply it by 21% that is here but remember to add it to here

23
00:04:19,000 --> 00:04:30,060
yeah so finally with all the things is this one the final price just you have

24
00:04:30,060 --> 00:04:41,629
to make the addition of the figures above and it's done we have finished this

25
00:04:41,629 --> 00:04:46,750
practical you can improve the presentations