Activa JavaScript para disfrutar de los vídeos de la Mediateca.
3ESO SPREADSHEETS LEVEL 2EXERCISE 2 - Contenido educativo
Ajuste de pantallaEl ajuste de pantalla se aprecia al ver el vídeo en pantalla completa. Elige la presentación que más te guste:
This is the next level in excel sheets
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.
00:00:01
So, just copy, registro de ventas, fecha de venta, and 01, 03, 02, and all the data that is given.
00:00:15
For making it easier, I copy from here, copy, paste, paste, copy, and paste here.
00:00:46
Next one, cantidad, alt, plus, enter, vendida, ok, precio, alt, plus, enter, unitario.
00:00:57
Next one is IMPORTE SIN IVA.
00:01:12
We need to open a new line here.
00:01:23
IMPORTE DEL DESCUENTO
00:01:26
IMPORTE CON DESCUENTO
00:01:33
THE TAX AND THE FINAL PRICE
00:01:43
And we can copy the color.
00:02:03
And for making this line, go to Combinari Central and you've got it.
00:02:13
Okay, cantidad vendida, copy the figures, 20, 32, 22, 32.
00:02:31
For the price, I copy again from product A, control C and here with a control press, control V.
00:02:38
And 3 euros, control C, copy and paste.
00:02:47
Importe sin IVA. It's equal to the quantity by the unitary price.
00:02:52
Importe del descuento. Here I'm going to make some luck.
00:02:59
Importe del descuento se calcula sobre el importe sin IVA y hay que multiplicarlo por este 7,5% que es el descuento.
00:03:06
but since I want to do the self-filling here like here if I do the self-filling this is an error
00:03:14
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
00:03:24
importe con descuento is this amount minus this one so um this minus this one perfect
00:03:38
and for eva the value added tax is exactly the same as here but with this one 21 percent take
00:03:57
this value and multiply it by 21% that is here but remember to add it to here
00:04:05
yeah so finally with all the things is this one the final price just you have
00:04:19
to make the addition of the figures above and it's done we have finished this
00:04:30
practical you can improve the presentations
00:04:41
- Autor/es:
- BEATRIZ TORREJON
- Subido por:
- Beatriz T.
- Licencia:
- Reconocimiento - No comercial - Compartir igual
- Visualizaciones:
- 28
- Fecha:
- 1 de octubre de 2023 - 19:37
- Visibilidad:
- Público
- Centro:
- IES CERVANTES
- Duración:
- 04′ 48″
- Relación de aspecto:
- 1.78:1
- Resolución:
- 1280x720 píxeles
- Tamaño:
- 44.69 MBytes
