Hoja Para Calcular En Excel 2007

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Hoja Para Calcular En Excel 2007 as PDF for free.

More details

  • Words: 181
  • Pages: 1
17941742.xls

Unidades Vendidas CMPSA Store

UNIDADES

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC PROM ANUAL

CPU

MOUSE

45 34 10 20 28 39 55 56 35 20 25 50

11 14 5 10 18 25 40 37 16 18 22 26

TEL

46 35 11 21 29 40 56 57 36 24 26 55

FAX

DISCOS

14 16 18 20 22 24 26 28 30 32 40 42

20 18 10 12 15 22 32 35 21 5 12 16

TOTAL MES

136.00 117.00 253.00 83.00 112.00 150.00 209.00 213.00 138.00 99.00 125.00 189.00

3475.0% 2017% 3633% 2600% 1817% 15200.00%

1. Sumar los Totales del Mes con SUM.

Hecho por: Teomar de Arce Díaz

Unidades Vendidas en los últimos 6 meses JUL

55

AUG

56

SEP

35 Column B

2. Calcular los Promedios Anuales por Unidades con AVERAGE. 3. Incluir una grafica de barra para los ultimos 6 meses de ventas del CPU.

OCT

20

4. Añadir un Área que diga: Hecho por: Su Nombre

NOV

25

DEC

50

0

10

20

30

40

50

60

Related Documents