excel clase 03

Upload: yoni

Post on 10-Jan-2016

225 views

Category:

Documents


0 download

TRANSCRIPT

Hoja1ProductoUSB 32"ItemCdigoMarcaEneFebMarPromedioPrecioTotal (und)Total (S/.)1OVOLEUSB32"1Lenovo569471457499.00361497538922Kingstong782652365599.67281799503723Sony459931485625.00301875562504Samsung365560459461.33331384456725Phillips748540687658.33321975632006LG236570189331.6735995348257HP748603863738.0034221475276OVOLESUB32"1

Hoja2Cdigo1MarcaERROR:#N/A

VentasEneFebMar459931485Promedio625Precio30

Total (und)1875Total (S/.)56250

Hoja3Producto:VinosItemCdigoMarcaEneFebMarPrecio (S/.)PromedioTotal (und)Total (S/.)1TAMAVIN1Tacama42545830026394.331183307582GAROVIN2Gato Negro47756941526487.001461372563LAIAVIN3La Estancia46957462028554.331663465644VIJAVIN4Via Vieja42651257830505.331516454805QULOVIN5Queirolo40553934822430.671292279076CAO VIN6Casillero 41550065833524.331573519097COLOVIN7Copello43661262119556.331669317118TAROVIN8Tabernero44432525425341.00102325575

GGROVIN2

Hoja4CdigoMarcaLa EstanciaVentasEneFebMar469574620Precio(S/.)28Promedio554.33Total (und)1663Total (S/.)46564