The Internet belongs to everyone. Let’s keep it that way.

Protect Net Neutrality
Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

COMPUTAR

CLASES
by

javier castro

on 6 April 2017

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of COMPUTAR

excel
VOLUMENES DE TEXTOS GRANDES
ARITMETICO
ESTADISTICO
CONTABLE
O FINANCIERO
HOJA ELECTRONICA
HOJA DE CALCULO
CONCEPTOS
BASICOS
CON LA CAPACIDAD DE PROCESAR, ALMACENAR Y
MOSTRAR INFORMACION
FILAS
CELDAS
Rango
Min(Ci . . Cf)
MAX (Ci . . Cf)
Suma(Ci . . Cf)
COLUMNAS
(cc) photo by tudor on Flickr
FUNCIONES
Horizontales
1...1.048.576
Verticales
A....XFD
Promedio(Ci . . Cf)
Si ?
FORMULAS
(cc) image by nuonsolarteam on Flickr
DEFINICION
SE UTILIZA PARA HAllAR EL NUMERO MAYOR EN UN RANGO DETERMINADO...
EJEMPLO
DEFINICION
EJEMPLO
SE UTILIZA PARA HAllAR EL NUMERO MENOR EN UN RANGO DETERMINADO
DEFENICION
SE UTILIZA PARA HAllAR EL PROMEDIO EN UN RANGO DETERMINADO
EJEMPLO
EJEMPLO
DEFINICION
SE UTILIZA PARA HAllAR LA SUMA EN UN RANGO DETRMINADO
FUNCIONES PARA TEXTO
CONCATENAR(TEXTO 1; TEXTO 2;....)

SUSTITUIR(CELDA_TEXTO;
TEXTO ORIGINAL;
TEXTO NUEVO)

MINUSC(CELDA_TEXTO
EXTRAE(CELDA_TEXTO;
POSICION_TEXTO;
NUMERO DE CARACTERES)
EJEMPLOS
MAYUSC(CELDA_TEXTO
Full transcript