PRACTICA Nº 03
FUNCIONES MATEMATICAS
FACTURA INFORMATICA
PERFECT-SYSTEM S.A (Ventas de junio 2023)
MODELO UNIDADES PRECIO UNIDAD TOTAL DESCUENTO TOTAL IGV
PENTIUM 4 1,6 GH 25 129 3225 161.25 580.5
PENTIUM 4 1,7 GH 27 169 4563 228.15 821.34
PENTIUM 4 1,8 GH 30 175 5250 262.5 945
PENTIUM III 100 MHZ 15 112 1680 84 302.4
PENTIUM M 725 MH 14 152 2128 106.4 383.04
PENTIUM M 730 1,6 19 148 2812 140.6 506.16
TOTALES 130 885 19658 982.9 3538.44
PROMEDIO 21.66666667 147.5 3276.3333333333 163.81666666667 589.74
MAXIMO 30 175 5250 262.5 945
MINIMO 14 112 1680 84 302.4
DSTO: 0.05
IGV 0.18
A CUENTA: 0.75
MODELO UNIDADES PRECIO UNIDAD TOTAL DES
PENTIUM 4 1,6 GH 25 S/. 129.00 S/. 3,225.00 S/.
PENTIUM 4 1,7 GH 27 S/. 169.00 S/. 4,563.00 S/.
PENTIUM 4 1,8 GH 30 S/. 175.00 S/. 5,250.00 S/.
PENTIUM III 100 MHZ 15 S/. 112.00 S/. 1,680.00 S/.
PENTIUM M 725 MHZ 14 S/. 152.00 S/. 2,128.00 S/.
PENTIUM M 730 1,6 GH 19 $ 148.00 S/. 2,812.00 S/.
TOTALES S/. 130.00 S/. 885.00 S/. 19,658.00 S/.
PROMEDIO S/. 21.67 S/. 147.50 S/. 3,276.33 S/.
MAXIMO S/. 30.00 S/. 175.00 S/. 5,250.00 S/.
MINIMO S/. 14.00 S/. 112.00 S/. 1,680.00 S/.
DSTO:
IGV
PROMEDIO S/. 21.67 S/. 147.50 S/. 3,276.33 S/.
MAXIMO S/. 30.00 S/. 175.00 S/. 5,250.00 S/.
MINIMO S/. 14.00 S/. 112.00 S/. 1,680.00 S/.
DSTO:
IGV
A CUENTA:
IMPORTE TOTAL A CUENTA A PAGAR
3644.25 2733.1875 911.0625
5156.19 3867.1425 1289.0475
5932.5 4449.375 1483.125
1898.4 1423.8 474.6
2404.64 1803.48 601.16
3177.56 2383.17 794.39
22213.54 16660.155 5553.385
3702.25666666667 2776.6925 925.56416666667
5932.5 4449.375 1483.125
1898.4 1423.8 474.6
TOTAL DESCUENTO TOTAL IGV IMPORTE TOTAL A CUENTA A PAGAR
S/. 3,225.00 S/. 161.25 S/. 580.50 S/. 3,644.25 S/. 2,733.19 S/. 911.06
S/. 4,563.00 S/. 228.15 S/. 821.34 S/. 5,156.19 S/. 3,867.14 S/. 1,289.05
S/. 5,250.00 S/. 262.50 S/. 945.00 S/. 5,932.50 S/. 4,449.38 S/. 1,483.13
S/. 1,680.00 S/. 84.00 S/. 302.40 S/. 1,898.40 S/. 1,423.80 S/. 474.60
S/. 2,128.00 S/. 106.40 S/. 383.04 S/. 2,404.64 S/. 1,803.48 S/. 601.16
S/. 2,812.00 S/. 140.60 S/. 506.16 S/. 3,177.56 S/. 2,383.17 S/. 794.39
/. 19,658.00 S/. 982.90 S/. 3,538.44 S/. 22,213.54 S/. 16,660.16 S/. 5,553.39
/. 3,276.33 S/. 163.82 S/. 589.74 S/. 3,702.26 S/. 2,776.69 S/. 925.56
/. 5,250.00 S/. 262.50 S/. 945.00 S/. 5,932.50 S/. 4,449.38 S/. 1,483.13
/. 1,680.00 S/. 84.00 S/. 302.40 S/. 1,898.40 S/. 1,423.80 S/. 474.60
DSTO: 5%
IGV 18%
/. 3,276.33 S/. 163.82 S/. 589.74 S/. 3,702.26 S/. 2,776.69 S/. 925.56
/. 5,250.00 S/. 262.50 S/. 945.00 S/. 5,932.50 S/. 4,449.38 S/. 1,483.13
/. 1,680.00 S/. 84.00 S/. 302.40 S/. 1,898.40 S/. 1,423.80 S/. 474.60
DSTO: 5%
IGV 18%
A CUENTA: 75%
A PAGAR
911.06
1,289.05
1,483.13
474.60
601.16
794.39
5,553.39
925.56
1,483.13
474.60
925.56
1,483.13
474.60
FUNCIONES EN EXCEL
SUMA RESTA MULTIPLICA DIVIDE
10 2 12 8 20 5.0
4 3 7 1 12 1.3
3 1 4 2 3 3.0
6 2 8 4 12 3.0
4 5 9 -1 20 0.8
2 4 6 -2 8 0.5
6 4 10 2 24 1.5
POTENCIA
100.00
64.00
3.00
36.00
1024.00
16.00
1296.00
EJERCICIO 02
Registro de notas
Nombre Nota 1 Nota 2 Nota 3 Nota 4 Promedio
Arturo Castro 12 13 10 8 10.8
Angel Zapata 13 14 8 15 12.5
Marcela Castillo 15 15 12 14 14.0
Romina Donoso 14 12 14 14 13.5
Alberto Lorca 18 16 15 16 16.3
Mauricio Jerez 20 18 17 18 18.3
El promedio mas alto es: 18.3
El promedio mas bajo es: 10.8
El numero de alumnos es: 6
La nota mas repetida fue el: 14
