Funciones Matemá
Función Suma Función Producto
Función Redondear Función [Link]
Matemáticas
ión Producto Función Potencia
ión [Link] Función [Link]
1. Función Suma
Suma todos los valores de un Rango de Celdas
Sintaxis:
=Suma(número1, [número],...)
Ejercicio 1: Calcular los incrementos y las sumas respectivas:
GRUPO GALA
Incrementos Trimestrales
por Categoría
Bebidas 5.00%
Condimentos 8.00%
Lácteos 3.00%
Frutas y Verduras 4.00%
Categoría 1er Trim.
Bebidas S/65.15
Condimentos S/44.75
Lácteos S/83.12
Frutas y Verduras S/50.35
Total Ingresos S/. 243.37
Gastos Fijos S/. 12.00
Gastos Variables S/. 15.50
Total Gastos S/. 27.50
Beneficio S/. 215.87
Beneficio Acumulado S/. 929.70
Ejercicio 2: Calcular los Ingresos, egresos y Utilidad en el siguiente cuadro.
Enero
Ventas S/. 18,900.00
Ingresos Financieros S/. 3,000.00
Otros S/. 18,000.00
Compras S/. 13,965.00
Otros Gastos S/. 1,365.00
Ingresos S/. 39,900.00
Egresos S/. 15,330.00
Utilidad S/. 24,570.00
FUNCIÓN SUMA
GRUPO GALATAR S.A.
Incrementos de los gastos
Gastos fijos: 2.00%
Gastos Variab.: 3.00%
2º Trim. 3er Trim. 4º Trim. Total anual
S/68.41 S/71.83 S/75.42 S/280.80
S/48.33 S/52.20 S/56.37 S/201.65
S/85.61 S/88.18 S/90.83 S/347.74
S/52.36 S/54.46 S/56.64 S/213.81
S/. 254.72 S/. 266.66 S/. 279.26 S/. 1,044.01
S/. 12.24 S/. 12.48 S/. 12.73 S/. 49.46
S/. 15.97 S/. 16.44 S/. 16.94 S/. 64.85
S/. 28.21 S/. 28.93 S/. 29.67 S/. 114.31
S/. 226.51 S/. 237.74 S/. 249.58 S/. 929.70
en el siguiente cuadro.
Febrero
Marzo
Mayo
S/. 18,750.00 S/. 22,526.00 Abril
S/. 19,526.00 S/. 18,963.00
S/. 3,000.00 S/. 3,000.00 S/. 3,000.00 S/. 3,000.00
S/. 1,652.00 S/. 2,365.00 S/. 1,635.00 S/. 1,869.00
S/. 12,398.00 S/. 13,687.00 S/. 15,638.00 S/. 14,635.00
S/. 1,698.00 S/. 1,639.00 S/. 1,785.00 S/. 1,365.00
S/. 23,402.00 S/. 27,891.00 S/. 24,161.00 S/. 23,832.00
S/. 14,096.00 S/. 15,326.00 S/. 17,423.00 S/. 16,000.00
S/. 9,306.00 S/. 12,565.00 S/. 6,738.00 S/. 7,832.00
Junio
S/. 19,636.00
S/. 3,000.00
S/. 1,365.00
S/. 12,563.00
S/. 1,478.00
S/. 24,001.00
S/. 14,041.00
S/. 9,960.00
FUNCIÓN PRODU
2. Función PRODUCTO
Multiplica todos los números proporcionados como argumentos.
Sintaxis:
= Producto(número1, [número],...)
Ejercicio 1: Calcular el Descuento y el neto del sigiuente cuadro:
Descuento 10%
Codigo Cargo
T001 ANALISTA
T002 CAJERO
T003 PROGRAMADOR
T004 DIGITADOR
T005 GERENTE
T006 SECRETARIA
T007 TESORERO
T008 ANALISTA
T009 PROGRAMADOR
T010 PROGRAMADOR
T011 DIGITADOR
T012 SECRETARIA
T013 GERENTE
Totales:
Ejercicio 2: Calcular las Licitaciones del sigiuente cuadro:
Apertura 5%
Comisión 15%
Nro
Empresa
Licitación
Silsa 115151-2010
Nutricsa 115447-2010
Lavaquick 159811-2010
Infordata 169887-2010
Nutricsa 121955-2010
Karvar 169552-2010
Silsa 124445-2010
Silsa 115621-2010
Nutricsa 263655-2010
HyC Data 145899-2010
Medicion 157888-2010
Arquitec 199366-2010
Electrosa 155455-2010
HyC Data 158955-2010
Esvicsa 186599-2010
Totales
Ejercicio 3: Calcular las Comisiones del sigiuente cuadro:
Productos Comisiones
TV 2%
Lavadora 4%
Licuadora 10%
Código del Vendedor TV
A001 S/.2,560.00
A002 S/.6,350.00
A003 S/.1,456.00
A004 S/.9,630.00
A005 S/.5,892.00
A006 S/.2,312.00
A007 S/.1,450.00
A008 S/.1,999.99
A009 S/.1,230.00
A010 S/.1,450.00
Totales: S/.34,329.99
UNCIÓN PRODUCTO
Básico Descuento Neto
S/2,500.00 S/.250.00 S/.2,250.00
S/1,200.00 S/.120.00 S/.1,080.00
S/1,800.00 S/.180.00 S/.1,620.00
S/1,500.00 S/.150.00 S/.1,350.00
S/3,450.00 S/.345.00 S/.3,105.00
S/1,000.00 S/.100.00 S/.900.00
S/1,200.00 S/.120.00 S/.1,080.00
S/2,500.00 S/.250.00 S/.2,250.00
S/1,800.00 S/.180.00 S/.1,620.00
S/1,800.00 S/.180.00 S/.1,620.00
S/1,500.00 S/.150.00 S/.1,350.00
S/1,000.00 S/.100.00 S/.900.00
S/3,450.00 S/.345.00 S/.3,105.00
S/.24,700.00 S/.2,470.00 S/.22,230.00
Licitaciones - Relación de Proyectos - Mes Noviembre
Fecha Monto Valor
Tasa
Proyecto Proyectado Inicial
3/2/2015 S/.2,312,563.00 29.99% S/.693,537.64
3/4/2016 S/.23,564,125.00 24.36% S/.5,740,220.85
3/4/2014 S/.85,693,256.00 25.36% S/.21,731,809.72
3/5/2016 S/.21,456,358.00 35.26% S/.7,565,511.83
3/7/2017 S/.45,632,568.00 23.45% S/.10,700,837.20
3/13/2016 S/.1,234,567.00 36.66% S/.452,592.26
3/14/2016 S/.2,589,634.00 29.89% S/.774,041.60
3/14/2017 S/.24,578,951.00 25.36% S/.6,233,221.97
3/16/2016 S/.1,234,567.00 18.90% S/.233,333.16
3/17/2016 S/.2,453,565.00 19.88% S/.487,768.72
3/19/2017 S/.12,456,389.00 19.63% S/.2,445,189.16
3/23/2015 S/.4,785,456.00 39.25% S/.1,878,291.48
3/23/2016 S/.1,245,632.00 34.58% S/.430,739.55
3/24/2016 S/.85,425,654.00 32.56% S/.27,814,592.94
3/25/2016 S/.52,456,825.00 34.25% S/.17,966,462.56
S/.367,120,110.00 S/.105,148,150.66
Comisiones
Lavadora Licuadora Monto Total TV
S/.899.99 S/.310.33 S/.3,770.32 S/.75.41
S/.999.99 314.22.309 S/.7,349.99 S/.147.00
S/.1,099.00 S/.355.30 S/.2,910.30 S/.58.21
S/.1,200.00 S/.199.90 S/.11,029.90 S/.220.60
S/.1,111.99 S/.245.36 S/.7,249.35 S/.144.99
S/.1,056.33 S/.289.33 S/.3,657.66 S/.73.15
S/.989.99 S/.197.30 S/.2,637.29 S/.52.75
S/.947.26 S/.289.44 S/.3,236.69 S/.64.73
S/.1,025.00 S/.235.74 S/.2,490.74 S/.49.81
S/.1,023.00 S/.301.99 S/.2,774.99 S/.55.50
S/.10,352.55 S/.2,424.69 S/.47,107.23 S/.942.14
Mes Noviembre
Monto
Apertura Comisión
Abonado
S/.34,676.88 S/.346,884.45 S/.1,075,098.98
S/.287,011.04 S/.3,534,618.75 S/.9,561,850.64
S/.1,086,590.49 S/.12,853,988.40 S/.35,672,388.61
S/.378,275.59 S/.3,218,453.70 S/.11,162,241.12
S/.535,041.86 S/.6,844,885.20 S/.18,080,764.26
S/.22,629.61 S/.185,185.05 S/.660,406.93
S/.38,702.08 S/.388,445.10 S/.1,201,188.78
S/.311,661.10 S/.3,686,842.65 S/.10,231,725.72
S/.11,666.66 S/.185,185.05 S/.430,184.87
S/.24,388.44 S/.368,034.75 S/.880,191.91
S/.122,259.46 S/.1,868,458.35 S/.4,435,906.97
S/.93,914.57 S/.717,818.40 S/.2,690,024.45
S/.21,536.98 S/.186,844.80 S/.639,121.32
S/.1,390,729.65 S/.12,813,848.10 S/.42,019,170.69
S/.898,323.13 S/.7,868,523.75 S/.26,733,309.44
S/.5,257,407.53 S/.55,068,016.50 S/.165,473,574.69
Lavadora Licuadora Total Comisión
S/.150.81 S/.377.03 S/.603.25
S/.294.00 S/.735.00 S/.1,176.00
S/.116.41 S/.291.03 S/.465.65
S/.441.20 S/.1,102.99 S/.1,764.78
S/.289.97 S/.724.94 S/.1,159.90
S/.146.31 S/.365.77 S/.585.23
S/.105.49 S/.263.73 S/.421.97
S/.129.47 S/.323.67 S/.517.87
S/.99.63 S/.249.07 S/.398.52
S/.111.00 S/.277.50 S/.444.00
S/.1,884.29 S/.4,710.72 S/.7,537.16
Monto
Pendiente
S/.1,237,464.02
S/.14,002,274.36
S/.50,020,867.39
S/.10,294,116.88
S/.27,551,803.74
S/.574,160.07
S/.1,388,445.22
S/.14,347,225.28
S/.804,382.13
S/.1,573,373.09
S/.8,020,482.03
S/.2,095,431.55
S/.606,510.68
S/.43,406,483.31
S/.25,723,515.56
S/.201,646,535.31
3. Función POTENCIA
Eleva un número a una potencia especificada.
Sintaxis:
=POTENCIA(Número,potencia)
Ejercicio 1: Calcular las potencias de los siguientes números:
Número Potencia
1 4
2 5
3 3
4 6
5 7
6 2
Ejercicio 2: Calcular el Valor Futuro (VF) de una cantidad de dinero depositada e
Fórmula
𝐕𝐅=𝐕𝐀(𝟏+𝐢)^𝐧
VA S/. 26,532.00
n 6
i 8%
VF S/. 42,102.95
Ejercicio 3 Calcular el Valor Actual (VA), dada por la siguiente Fórmula:
Fórmula
𝑽𝑨=𝑽𝑭/ 〖 (𝟏+𝒊) 〗 ^𝒏
VF S/.7,852.00
n 4
i 15%
VA S/.4,489.41
FUNCIÓN POTENCIA
Resultado
1
32
27
4096
78125
36
de dinero depositada en una entidad bancaria.
guiente Fórmula:
5. Función REDONDEAR
La función REDONDEAR en Excel nos ayuda a redondear un número a una cantidad de decimales
especificados. La cantidad de decimales especificados puede ser un
número positivo o cero.
Sintaxis:
=REDONDEAR(Número,num_decimales)
Ejercicio 1: Redondear los siguientes números a 2 decimales utilizando la función redonde
Número
4.345678
16.356789007
36.23634544
64.6454333
27.78923456
144.4687566
Ejercicio 2: Redondear el promedio a 2 decimales
Alumno
Eliana
Milagros
José
Carlos
Rosa
Carla
Luis
Marlene
Patricia
Karen
Mary
FUNCIÓN REDONDEAR
ar un número a una cantidad de decimales
de ser un
s números a 2 decimales utilizando la función redondear.
Redondear a 2 Decimales
4.35
16.36
36.24
64.65
27.79
144.47
io a 2 decimales
Nota1 Nota2 Promedio
12 13 12.50
13 13 13.00
11 12 11.50
09 15 12.00
08 14 11.00
11 13 12.00
13 10 11.50
12 09 10.50
11 08 9.50
12 07 9.50
10 10
10.00
6. Función [Link]
La función [Link] en Excel nos permite hacer una suma de celdas que cumplen con un det
excluir aquellas celdas que no nos interesa incluir en la operación.
Sintaxis:
=[Link](rango, criterio, [rango_suma])
Ejercicio 1: Dada la siguiente Base de Datos:
Fecha Subcuenta
02-01-14 4000002
02-01-14 4000004
02-01-14 4000002
02-01-14 4000002
02-01-14 4000001
02-01-14 4000001
03-01-14 4000002
03-01-14 4000001
03-01-14 4000003
03-01-14 4000001
04-01-14 4000004
05-01-14 4000004
05-01-14 4000001
05-01-14 4000002
05-01-14 4000001
05-01-14 4000001
06-01-14 4000003
06-01-14 4000004
07-01-14 4000001
07-01-14 4000003
07-01-14 4000003
07-01-14 4000004
07-01-14 4000001
07-01-14 4000001
08-01-14 4000004
08-01-14 4000002
08-01-14 4000004
08-01-14 4000001
08-01-14 4000002
08-01-14 4000002
08-01-14 4000002
09-01-14 4000001
09-01-14 4000001
09-01-14 4000001
09-01-14 4000001
09-01-14 4000004
09-01-14 4000001
09-01-14 4000004
09-01-14 4000001
09-01-14 4000001
10-01-14 4000001
10-01-14 4000001
10-01-14 4000002
11-01-14 4000002
11-01-14 4000003
11-01-14 4000001
11-01-14 4000001
12-01-14 4000004
12-01-14 4000004
12-01-14 4000004
12-01-14 4000003
12-01-14 4000003
13-01-14 4000001
13-01-14 4000002
13-01-14 4000001
13-01-14 4000002
14-01-14 4000001
14-01-14 4000001
14-01-14 4000003
14-01-14 4000001
14-01-14 4000001
14-01-14 4000001
14-01-14 4000001
15-01-14 4000003
15-01-14 4000004
15-01-14 4000001
15-01-14 4000004
15-01-14 4000001
15-01-14 4000001
15-01-14 4000004
16-01-14 4000004
16-01-14 4000004
16-01-14 4000003
16-01-14 4000002
16-01-14 4000002
16-01-14 4000001
17-01-14 4000004
17-01-14 4000001
17-01-14 4000001
18-01-14 4000001
18-01-14 4000003
18-01-14 4000003
18-01-14 4000003
18-01-14 4000001
19-01-14 4000003
19-01-14 4000001
19-01-14 4000003
19-01-14 4000002
Ejemplo 1: Calcular el total de Compras de las siguientes Librerias
Librerias
Crisol
Artesco
Stanford
Isabel
Bruño
Ejemplo2: Calcular el Total compra de las siguientes Localidades
Localidad
Lima
Piura
La Libertad
Cuzco
Loreto
Ejemplo3: Calcular el Total compra de las siguientes Librerias. (Ut
Seleccione la Librería
Total Compra
Calcular el Total compra de los siguientes Clientes. (Uti
Ejemplo4:
Listas)
Seleccione el Cliente:
Total Compra
FUNCIÓN [Link]
una suma de celdas que cumplen con un determinado criterio y de esta manera
n la operación.
s:
Cliente Librerias Producto Localidad
Mendoza Crisol Lapices Lima
Castillo Artesco Lapices La Libertad
Mendoza Crisol Lapices La Libertad
Mendoza Stanford Lapices Piura
Rodriguez Crisol Lapices Cuzco
Rodriguez Isabel Lapices Loreto
Mendoza Isabel Lapices Piura
Rodriguez Bruño Lapices Piura
Palomino Bruño Lapices Loreto
Rodriguez Bruño Lapices Loreto
Castillo Artesco Lapices Loreto
Castillo Crisol Lapices Lima
Rodriguez Bruño Lapices La Libertad
Mendoza Artesco Lapices Cuzco
Rodriguez Artesco Lapices Cuzco
Rodriguez Crisol Lapices Loreto
Palomino Artesco Lapices Cuzco
Castillo Crisol Lapices Loreto
Rodriguez Artesco Lapices Lima
Palomino Isabel Lapices Lima
Palomino Crisol Lapices Lima
Castillo Bruño Lapices Piura
Rodriguez Crisol Lapices Cuzco
Rodriguez Bruño Lapices Loreto
Castillo Bruño Lapices La Libertad
Mendoza Bruño Lapices Piura
Castillo Bruño Lapices Cuzco
Rodriguez Artesco Lapices Loreto
Mendoza Isabel Lapices Loreto
Mendoza Bruño Lapices Loreto
Mendoza Crisol Lapices Loreto
Rodriguez Crisol Lapices Lima
Rodriguez Crisol Lapices La Libertad
Rodriguez Stanford Lapices Piura
Rodriguez Isabel Lapices Piura
Castillo Crisol Lapices Piura
Rodriguez Stanford Lapices Cuzco
Castillo Artesco Lapices Cuzco
Rodriguez Isabel Lapices Cuzco
Rodriguez Crisol Lapices Loreto
Rodriguez Artesco Lapices La Libertad
Rodriguez Crisol Lapices La Libertad
Mendoza Stanford Lapices Loreto
Mendoza Stanford Lapices Lima
Palomino Artesco Lapices Lima
Rodriguez Artesco Lapices Lima
Rodriguez Bruño Lapices Cuzco
Castillo Stanford Lapices Lima
Castillo Crisol Lapices La Libertad
Castillo Stanford Lapices Piura
Palomino Crisol Lapices Piura
Palomino Stanford Lapices Loreto
Rodriguez Stanford Lapices Lima
Mendoza Bruño Lapices Lima
Rodriguez Stanford Lapices La Libertad
Mendoza Isabel Lapices La Libertad
Rodriguez Isabel Lapices Lima
Rodriguez Isabel Lapices Lima
Palomino Isabel Lapices La Libertad
Rodriguez Isabel Lapices La Libertad
Rodriguez Stanford Lapices Piura
Rodriguez Bruño Lapices Cuzco
Rodriguez Artesco Lapices Loreto
Palomino Bruño Lapices Lima
Castillo Isabel Lapices La Libertad
Rodriguez Isabel Lapices La Libertad
Castillo Artesco Lapices Piura
Rodriguez Artesco Lapices Piura
Rodriguez Bruño Lapices Piura
Castillo Isabel Lapices Loreto
Castillo Bruño Lapices Lima
Castillo Stanford Lapices La Libertad
Palomino Isabel Lapices Piura
Mendoza Crisol Lapices Piura
Mendoza Stanford Lapices Cuzco
Rodriguez Stanford Lapices Loreto
Castillo Isabel Lapices Piura
Rodriguez Crisol Lapices Piura
Robles Crisol Lapices Piura
Rodriguez Bruño Lapices Lima
Palomino Artesco Lapices La Libertad
Palomino Stanford Lapices Cuzco
Palomino Artesco Lapices Loreto
Rodriguez Isabel Lapices Loreto
Palomino Crisol Lapices La Libertad
Rodriguez Artesco Lapices Piura
Robles Bruño Lapices Piura
Mendoza Bruño Lapices Cuzco
al de Compras de las siguientes Librerias
Total Compra
S/. 11,959.30
S/. 11,003.50
S/. 8,019.28
S/. 8,765.04
S/. 10,631.80
otal compra de las siguientes Localidades
Total Compra
S/. 9,277.16
S/. 12,583.52
S/. 10,517.34
S/. 7,400.96
S/. 10,599.94
otal compra de las siguientes Librerias. (Utilizando Listas)
otal compra de los siguientes Clientes. (Utilizando
Asignar nombre a cada column
Importe de Compra IGV Total de Compras Cliente
S/. 570.00 S/. 102.60 S/. 672.60 Mendoza
S/. 315.00 S/. 56.70 S/. 371.70 Castillo
S/. 504.00 S/. 90.72 S/. 594.72 Rodriguez
S/. 294.00 S/. 52.92 S/. 346.92 Palomino
S/. 136.00 S/. 24.48 S/. 160.48
S/. 512.00 S/. 92.16 S/. 604.16
S/. 352.00 S/. 63.36 S/. 415.36
S/. 152.00 S/. 27.36 S/. 179.36
S/. 273.00 S/. 49.14 S/. 322.14
S/. 918.00 S/. 165.24 S/. 1,083.24
S/. 160.00 S/. 28.80 S/. 188.80
S/. 450.00 S/. 81.00 S/. 531.00
S/. 320.00 S/. 57.60 S/. 377.60
S/. 720.00 S/. 129.60 S/. 849.60
S/. 477.00 S/. 85.86 S/. 562.86
S/. 544.00 S/. 97.92 S/. 641.92
S/. 333.00 S/. 59.94 S/. 392.94
S/. 352.00 S/. 63.36 S/. 415.36
S/. 484.00 S/. 87.12 S/. 571.12
S/. 510.00 S/. 91.80 S/. 601.80
S/. 204.00 S/. 36.72 S/. 240.72
S/. 288.00 S/. 51.84 S/. 339.84
S/. 315.00 S/. 56.70 S/. 371.70
S/. 405.00 S/. 72.90 S/. 477.90
S/. 288.00 S/. 51.84 S/. 339.84
S/. 504.00 S/. 90.72 S/. 594.72
S/. 928.00 S/. 167.04 S/. 1,095.04
S/. 810.00 S/. 145.80 S/. 955.80
S/. 378.00 S/. 68.04 S/. 446.04
S/. 322.00 S/. 57.96 S/. 379.96
S/. 306.00 S/. 55.08 S/. 361.08
S/. 225.00 S/. 40.50 S/. 265.50
S/. 608.00 S/. 109.44 S/. 717.44
S/. 588.00 S/. 105.84 S/. 693.84
S/. 350.00 S/. 63.00 S/. 413.00
S/. 525.00 S/. 94.50 S/. 619.50
S/. 208.00 S/. 37.44 S/. 245.44
S/. 330.00 S/. 59.40 S/. 389.40
S/. 444.00 S/. 79.92 S/. 523.92
S/. 672.00 S/. 120.96 S/. 792.96
S/. 414.00 S/. 74.52 S/. 488.52
S/. 504.00 S/. 90.72 S/. 594.72
S/. 437.00 S/. 78.66 S/. 515.66
S/. 544.00 S/. 97.92 S/. 641.92
S/. 1,080.00 S/. 194.40 S/. 1,274.40
S/. 774.00 S/. 139.32 S/. 913.32
S/. 893.00 S/. 160.74 S/. 1,053.74
S/. 240.00 S/. 43.20 S/. 283.20
S/. 779.00 S/. 140.22 S/. 919.22
S/. 270.00 S/. 48.60 S/. 318.60
S/. 468.00 S/. 84.24 S/. 552.24
S/. 384.00 S/. 69.12 S/. 453.12
S/. 176.00 S/. 31.68 S/. 207.68
S/. 357.00 S/. 64.26 S/. 421.26
S/. 864.00 S/. 155.52 S/. 1,019.52
S/. 945.00 S/. 170.10 S/. 1,115.10
S/. 385.00 S/. 69.30 S/. 454.30
S/. 405.00 S/. 72.90 S/. 477.90
S/. 198.00 S/. 35.64 S/. 233.64
S/. 500.00 S/. 90.00 S/. 590.00
S/. 1,113.00 S/. 200.34 S/. 1,313.34
S/. 684.00 S/. 123.12 S/. 807.12
S/. 432.00 S/. 77.76 S/. 509.76
S/. 260.00 S/. 46.80 S/. 306.80
S/. 220.00 S/. 39.60 S/. 259.60
S/. 280.00 S/. 50.40 S/. 330.40
S/. 510.00 S/. 91.80 S/. 601.80
S/. 722.00 S/. 129.96 S/. 851.96
S/. 572.00 S/. 102.96 S/. 674.96
S/. 832.00 S/. 149.76 S/. 981.76
S/. 280.00 S/. 50.40 S/. 330.40
S/. 540.00 S/. 97.20 S/. 637.20
S/. 520.00 S/. 93.60 S/. 613.60
S/. 590.00 S/. 106.20 S/. 696.20
S/. 264.00 S/. 47.52 S/. 311.52
S/. 532.00 S/. 95.76 S/. 627.76
S/. 312.00 S/. 56.16 S/. 368.16
S/. 782.00 S/. 140.76 S/. 922.76
S/. 708.00 S/. 127.44 S/. 835.44
S/. 918.00 S/. 165.24 S/. 1,083.24
S/. 741.00 S/. 133.38 S/. 874.38
S/. 342.00 S/. 61.56 S/. 403.56
S/. 429.00 S/. 77.22 S/. 506.22
S/. 285.00 S/. 51.30 S/. 336.30
S/. 893.00 S/. 160.74 S/. 1,053.74
S/. 594.00 S/. 106.92 S/. 700.92
S/. 450.00 S/. 81.00 S/. 531.00
S/. 198.00 S/. 35.64 S/. 233.64
Asignar nombre a cada columna.
Librerias Producto Localidad
Crisol Lapices Lima
Artesco Grapas La Libertad
Stanford Carpetas Piura
Isabel Boligrafos Cuzco
Bruño Archivadores Loreto
FUNCIÓN [Link]
6. Función [Link]
La función [Link] en Excel nos permite hacer una suma de celdas que cumplen con u
interesa incluir en la operación.
Sintaxis:
=[Link]([rango_suma], rango, criterio)
MES DEPARTAMENTO BANCO
ENERO LIMA INTERBANK
FEBRERO AREQUIPA BCP
MARZO CUZCO FINANCIERO
ENERO AREQUIPA INTERBANK
FEBRERO CUZCO BCP
MARZO LIMA FINANCIERO
ENERO CUZCO INTERBANK
FEBRERO LIMA BCP
MARZO AREQUIPA FINANCIERO
¿Cuál es el Monto acumulado del Interbank en soles?
1
¿Cuál es el Monto acumulado de las captaciones del Financiero en soles?
2
¿Cuánto es la suma del Monto del BCP en febrero en dolares?
3
¿Cuánto es el acumulado del Monto de las colocaciones en Arequipa?
4
FUNCIÓN [Link]
er una suma de celdas que cumplen con uno o varios criterios y de esta manera excluir aquellas celdas que no nos
OPERACIÓN MONEDA MONTO
CAPTACION SOLES 2,600.00
COLOCACION DOLARES 1,250.00
CAPTACION SOLES 2,700.00
COLOCACION DOLARES 1,800.00
CAPTACION SOLES 3,000.00
COLOCACION DOLARES 1,400.00
CAPTACION SOLES 3,200.00
COLOCACION DOLARES 1,900.00
CAPTACION SOLES 1,680.00
ank en soles?
taciones del Financiero en soles?
n febrero en dolares?
as colocaciones en Arequipa?
