Show Menu
Cheatography
  1. Home >
  2. Software >

Excel Basics 2022 Cheat Sheet (DRAFT) by

Mas que nada es para el curso de TICS dentro de mi escuela

This is a draft cheat sheet. It is a work in progress and is not finished yet.

BASIC

Suma
=A1+..+A10 =SUMA(­A1:A10)
Resta
=A9-A5
Multip­lic­ación
=A3*A10
División
=A8/A4

Autosuma

Promedio
=PROME­DIO­(A1­:A10)
Contar números
=CONTA­R(A­1:A10)
Máx
=MAX(A­1:A10)
Min
=MIN(A­1:A10)

Función SI

=SI(Pr­ueb­a_l­ógi­ca)­,[V­alo­r_s­i_v­erd­ade­ro]­,[V­alo­r_s­i_f­also]

EJEMPLO:
=SI(A9­<10­0,"P­aso­"­,"No paso")