Embed Size (px)
Citation preview
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 1/16
TALLER 1: CONOCER LAS PRINCIPALES HERRAMIENTAS
enero febrero marzo
1
2
3/12/2015 3
3/13/2015 1:01 4
3/14/2015 1:02 5
3/15/2015 1:03 6
3/16/2015 1:04 7
3/17/2015 1:05 8
3/18/2015 1:06 9
3/19/2015 1:07 10
3/20/2015 1:08 11
3/21/2015 1:09 12
3/22/2015 1:10 13
3/23/2015 1:11 14
3/24/2015 1:12 15
3/25/2015 1:13 16
3/26/2015 1:14
3/27/2015 1:15
3/28/2015
3/29/2015
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 2/16
E EXCEL
wewe
wewe lunes
wewe martes
wewe miércoles
wewe jueves
wewe viernes
wewe sba!o
wewe !omin"o
wewe lunes
wewe martes
wewe miércoles
wewe
wewe
wewe
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 3/16
06/26/201517:20:58 #$%&#'( $&*#+,-+ .(('
. .-,.(
, ,,
1 %aiza %un!umi vi! ,ssa! 20 17
2 $acoto elaste"ui %arlos oao 19 20
3 ola ambrano +oberto (n!res 20 20
4 inueza %amino u"o avi! 19 19
5 ambrano (ba! rowen!e esus 20 206 avala %alle 'uis (n!res 20 19
7
8
9
10
TALLER 2: FUNCIONES BASICAS Y PROTECCIÓN DE HOJAS
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 4/16
06/26/201517:20:58 #$%&#'( $&*#+,-+ .(('
&.,#+$,( # '($ &#+($ (+(($
#$%&#'( $&*#+,-+ .(('
%# +((#' -+(. ('#+#
$(',.($
($,.(&+(atematica %ontabili!a!
,,, $ u m a
, ,, ,,,
19 56 1867 20 20 20
18 57 1900 19 16 19
18 58 1933 18 20 19
18 56 1867 20 17 18
20 60 2000 19 20 1717 56 1867 18 19 20
N EXCEL
* r o m e ! i
o
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 5/16
06/26/201517:20:58 #$%&#'( $&*#+,-+ .(('
#lectronica
$ u m a
* r o m e ! i o
, ,, ,,, $ u m a
60 2000 19 20 20 59
54 1800 20 20 20 60
57 1900 16 20 20 56
55 1833 20 17 20 57
56 1867 20 18 20 5857 1900 20 19 19 58
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 6/16
06/26/201517:20:58 #$%&#'( $&*#+,-+ .(('
* r o m e ! i o
1967 1944 ecelente
2000 1900 ace;table
1867 1900 ace;table
1900 1867 ace;table
1933 1933 ecelente1933 1900 ace;table
* r o m e ! i o
0 e n e r a l
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 7/16
TALLER 3: FORMATO DE NUMEROS
*orcentaje
one!a
%ontabili!a!ec<a = <ora
5 500 > 500 &$> 500 1/7/1900 8
6 600 > 600 &$> 600 1/8/1900 9
7 700 > 700 &$> 700 1/9/1900 10
8 800 > 800 &$> 800 1/10/1900 11
1 100 > 100 &$> 100 1/11/1900 12
13/03/15
500? 1? 1?
600? 2? 2?
700? 3? 3?
800? 4? 4?
900? 5? 5?
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 8/16
TALLER 4: OPERACIONES BASICAS
&',*',%(%,-. ,,$,-. $&( +#$(
8 24 24 243 3 8 8
24 8 32 16
EJERCICIO 1 $&( +#$( &',*',%(%,-.
3 6 4
3 2 3
6 4 12
EJERCICIO 1 artita tiene tres;eras@ su ;a;a le!a 3 masose leAuita 2 manzanas(;arece un ma"o =le tri;licalo Auetiene = lue"oa;arece su ami"o
uan = le re"ala lamita! !e las ;eras
EJERCICIO 2 rowen tiene una ;izzafamiliar !e !iez ;e!azos =!e bono le re"ala cuatro;e!azos mas@ ;ero resultaAue un ;erro le robo !os;e!azosB como el ;erroestaba !entro !e la;izzeria@ le !u;lican los;e!azos Aue Aue!aron@lue"o fue a su casa !on!econ;artio entre 8 ami"os
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 9/16
80
,,$,-. EJERCICIO 2$&( +#$( &',*',%(%,-.
12 10 14 12
2 4 2 2
6 14 12 24
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 10/16
,,$,-.
24
8
3
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 11/16
TALLER 5: ANCLAR FORMULAS
SUMA PROMEDIO CONTAR MAX Y MIN CONDICION CONTAR
12 165 6 22 (*+&#C( 9
10 165 6 +#*+&#C(
22 (( (*+&#C(
22 *(*( (*+&#C(
Dóla 3!"#E$% 5!5"
(+#.,.( D%la&' E$%' 1003000 77720 53763 1000
1000 25907 17921 2000
5700 147668 102151 3000
6100
SOL 2.99
DOLARES SOLES
1(( 2))14 41!"#5* 1*(!43
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 12/16
1
4
5
22
163934426163934426
327868852
491803279
100
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 13/16
ELECCIONES 2020
%an!i!atos
*+-,.%,($
'os +ios ua=as *ic<inc<a #l -ro #smeral!as
Al+a% N%,%a 23@000 28@000 57@800 85@320 87@541
-$.ll&/% La''% 23@659 23@684 89@526 87@426 23@654
Ra0a&l C%&a 42@580 10@500 63@257 32@587 78@526
A,ala B$aa/ 47@521 5@222 6@335 58@741 32@569
L&. M%&% 10@000 96@547 96@325 8@542 41@055
Ja./& N&,% 25@417 12@000 36@520 8@950 52@160
otal !e votos ;or ;ais
TALLER #: FORMATO CONDICIONAL 6ALIDACION DE DATOS INSE
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 14/16
5 o t a l !
e v o t o s
* a r t e ; r o ; o r c i o n a l
281@661 22
247@949 19
227@450 18
150@388 12
252@469 19
135@047 10
1@294@964 100
CIÓN DE -RAFICOS ormato con!icional
vali!acion !e !atos
conD"uracion !e ;a"ina
23
"532(
"*541
Al+a%
050@000
100@000150@000200@000250@000300@000
%<art
*+-/,.%,($ 'os +ios u
#l -ro #s
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 15/16
((
2"(((
5*"((
%,%a
itle
a=as *ic<inc<a
meral!as
7/18/2019 TALLER EXCEL-PARCIAL 1.xlsx
http://slidepdf.com/reader/full/taller-excel-parcial-1xlsx 16/16
TALLER *: FORMATO CONDICIONAL
FORMATO CONDICIONAL
1 15 26 56
3 26 52
12 53
15 53
14 97
16 58
20 96
18 1
10 3
13 5
