Gestión de contabilidad, Apuntes de Contabilidad

¡Descarga Gestión de contabilidad y más Apuntes en PDF de Contabilidad solo en Docsity!

PRACTICA

Aplica las herramientas de Excel para insertar y modificar un

ACTICA

ertar y modificar un minigráfico.

 - Maria Set Err: 

• 1 Juan 2,689.00 1,501.00 2,556.00 3,325. Ene Feb Mar Abr
• 2 Fredy 2,456.00 1,276.00 3,456.00 64,325.
• 3 Alexis 3,445.00 2,434.00 2,342.00 1,235.
• 4 Herly 2,546.00 2,786.00 3,789.00 2,365.
• 5 Elizabed 3,256.00 3,456.00 1,254.00 2,354.
• 6 Juana 1,657.00 3,564.00 4,321.00 1,262.
• 7 Bernardo 3,579.00 3,564.00 2,343.00 3,452.
• 8 Joseluis 4,451.00 4,352.00 2,345.00 3,212.
• 9 Maricielo 3,342.00 2,334.00 2,343.00 2,135.
• 10 Mariana 2,334.00 3,344.00 3,445.00 2,314.
• 11 Grecia 1,254.00 2,345.00 2,432.00 3,242.
• 12 Sheyla 4,322.00 2,345.00 4,832.00 3,678.
• 13 Hernan 2,345.00 4,543.00 2,345.00 2,554.
• 14 Carlos 3,651.00 1,651.00 2,162.00 2,045.
• 15 Pedro 1,772.00 2,841.00 2,710.00 1,567.
• 16 Luz_maria 3,169.00 2,792.00 3,667.00 1,921.
• 17 Maria 3,762.00 3,674.00 1,913.00 2,980.
• 18 Jhoana 1,722.00 2,218.00 3,633.00 2,269.
• 19 Carmen 3,081.00 2,448.00 2,457.00 2,649.
• 20 Karen 2,699.00 3,913.00 3,453.00 1,741. - Juan 2,689.00 1,501.00 2,556.00 3,325. ENERO FEBRERO MARZO ABRIL - Fredy 2,456.00 1,276.00 3,456.00 6,432. - Alexis 3,445.00 2,434.00 2,342.00 1,235. - Herly 2,546.00 2,786.00 3,789.00 2,365. - Elizabed 3,256.00 3,456.00 1,254.00 2,354.
• Juana 1,657.00 3,564.00 4,321.00 1,262.
• Bernardo 3,579.00 3,564.00 2,343.00 3,452.
• Joseluis 4,451.00 4,352.00 2,345.00 3,212.
• Maricielo 3,342.00 2,334.00 2,343.00 2,135.
• Mariana 2,334.00 3,344.00 3,445.00 2,314.
• Grecia 1,254.00 2,345.00 2,432.00 3,242.
• Sheyla 4,322.00 2,345.00 4,832.00 3,678.
• Hernan 2,345.00 4,543.00 2,345.00 2,554.
• Carlos 3,651.00 1,651.00 2,162.00 2,045.
• Pedro 1,772.00 2,841.00 2,710.00 1,567.
• Luz_maria 3,169.00 2,792.00 3,667.00 1,921.
• Maria 3,762.00 3,674.00 1,913.00 2,980.
• Jhoana 1,722.00 2,218.00 3,633.00 2,269.
• Carmen 3,081.00 2,448.00 4,367.00 2,649.
• Karen 2,699.00 3,913.00 3,453.00 1,741.
• SUMA 57,532.00 57,381.00 59,708.00 52,732.
• VENTA MAXIMA 4,451.00 4,543.00 4,832.00 6,432.
• VENTA MINIMA 1,254.00 1,276.00 1,254.00 1,235.
• 3,341.00 3,524.00 2,112.00 3,419.00 1,811.00 2,689. May Jun Jul Ago Set Oct
• 2,453.00 1,253.00 1,214.00 1,456.00 2,355.00 1,265.
• 2,355.00 5,412.00 4,324.00 1,432.00 2,356.00 2,365.
• 3,652.00 4,532.00 4,322.00 5,432.00 4,236.00 1,254.
• 4,353.00 4,632.00 2,354.00 1,243.00 5,432.00 2,365.
• 2,432.00 2,353.00 2,352.00 3,242.00 1,988.00 3,542.
• 4,325.00 3,432.00 2,421.00 3,242.00 2,087.00 1,275.
• 2,341.00 2,453.00 2,313.00 3,102.00 3,222.00 3,476.
• 3,321.00 2,534.00 3,251.00 1,253.00 3,253.00 2,325.
• 3,222.00 2,453.00 1,252.00 2,642.00 5,321.00 3,443.
• 2,344.00 2,453.00 2,412.00 3,521.00 4,008.00 5,322.
• 4,253.00 2,332.00 4,133.00 2,455.00 3,865.00 4,322.
• 1,453.00 2,342.00 2,424.00 2,244.00 2,984.00 2,574.
• 3,592.00 2,013.00 2,234.00 3,876.00 2,913.00 2,926.
• 1,547.00 3,990.00 3,764.00 1,953.00 2,387.00 2,790.
• 2,841.00 3,210.00 3,955.00 2,496.00 2,479.00 1,567.
• 3,760.00 3,154.00 2,506.00 3,929.00 2,560.00 2,159.
• 2,980.00 1,519.00 2,205.00 2,067.00 3,243.00 3,190.
• 2,817.00 3,452.00 2,905.00 3,468.00 2,805.00 1,617.
• 2,846.00 1,806.00 2,468.00 3,679.00 2,422.00 1,530.
• 3,341.00 3,524.00 2,112.00 3,419.00 1,811.00 2,689. MAYO JUNIO JULIO AGOSTO SETIEMBRE OCTUBRE
• 2,453.00 1,253.00 1,214.00 1,456.00 2,355.00 1,265.
• 2,355.00 5,412.00 4,324.00 1,432.00 2,356.00 2,365.
• 3,652.00 4,532.00 4,322.00 5,432.00 4,236.00 1,254.
• 4,353.00 4,632.00 2,354.00 1,243.00 5,432.00 2,365.
• 2,432.00 2,353.00 2,352.00 3,242.00 1,988.00 3,542.
• 4,325.00 3,432.00 2,421.00 3,242.00 2,087.00 1,275.
• 2,341.00 2,453.00 2,313.00 3,102.00 3,222.00 3,476.
• 3,321.00 2,534.00 3,251.00 1,253.00 3,253.00 2,325.
• 3,222.00 2,453.00 1,252.00 2,642.00 5,321.00 3,443.
• 2,344.00 2,453.00 2,412.00 3,521.00 4,008.00 5,322.
• 4,253.00 2,332.00 4,133.00 2,455.00 3,865.00 4,322.
• 1,453.00 2,342.00 2,424.00 2,244.00 2,984.00 2,574.
• 3,592.00 2,013.00 2,234.00 3,876.00 2,913.00 2,926.
• 1,547.00 3,990.00 3,764.00 1,953.00 2,387.00 2,790.
• 2,841.00 3,210.00 3,955.00 2,496.00 2,479.00 1,567.
• 3,760.00 3,154.00 2,506.00 3,929.00 2,560.00 2,159.
• 2,980.00 1,519.00 2,205.00 2,067.00 3,243.00 3,190.
• 2,817.00 3,452.00 2,905.00 3,468.00 2,805.00 1,617.
• 2,846.00 1,806.00 2,468.00 3,679.00 2,422.00 1,530.
  • 60,228.00 58,849.00 54,921.00 56,151.00 61,727.00 49,307.
    • 4,353.00 5,412.00 4,324.00 5,432.00 5,432.00 5,322.
    • 1,453.00 1,253.00 1,214.00 1,243.00 1,988.00 1,254.
• 3,987.00 3,575. Nov Dic
• 3,465.00 2,456.
• 2,356.00 4,334.
  • 324.00 3,425.
• 3,452.00 2,314.
• 3,587.00 2,345.
• 3,476.00 3,879.
• 4,536.00 2,498.
• 4,586.00 3,098.
• 2,363.00 2,432.
• 1,209.00 5,465.
• 1,644.00 3,452.
• 2,421.00 354.
• 3,504.00 3,752.
• 3,814.00 3,726.
• 2,928.00 3,574.
• 2,641.00 1,668.
• 2,270.00 3,135.
• 2,042.00 3,817.
• 3,623.00 3,853.
• 3,987.00 3,575.00 34,529.00 2,877.42 100,000. NOVIEMBRE DICIEMBRE SUMA PROPEDIO META
• 3,465.00 2,456.00 29,537.00 2,461.42 100,000.
• 2,356.00 4,334.00 34,390.00 2,865.83 100,000.
  • 324.00 3,425.00 38,663.00 3,221.92 100,000.
• 3,452.00 2,314.00 36,465.00 3,038.75 100,000.
• 3,587.00 2,345.00 32,645.00 2,720.42 100,000.
• 3,476.00 3,879.00 37,075.00 3,089.58 100,000.
• 4,536.00 2,498.00 38,301.00 3,191.75 100,000.
• 4,586.00 3,098.00 33,775.00 2,814.58 100,000.
• 2,363.00 2,432.00 34,565.00 2,880.42 100,000.
• 1,209.00 5,465.00 36,007.00 3,000.58 100,000.
• 1,644.00 3,452.00 41,633.00 3,469.42 100,000.
• 2,421.00 354.00 28,583.00 2,381.92 100,000.
• 3,504.00 3,752.00 34,319.00 2,859.92 100,000.
• 3,814.00 3,726.00 32,861.00 2,738.42 100,000.
• 2,928.00 3,574.00 34,599.00 2,883.25 100,000.
• 2,641.00 1,668.00 34,706.00 2,892.17 100,000.
• 2,270.00 3,135.00 30,451.00 2,537.58 100,000.
• 2,042.00 3,817.00 35,468.00 2,955.67 100,000.
• 3,623.00 3,853.00 34,033.00 2,836.08 100,000.
  • 58,228.00 63,152.
    • 4,586.00 5,465.
      • 324.00 354.

ENERO FEBRERO MARZO ABRIL MAYO

Juan 2,689.00 1,501.00 2,556.00 3,325.00 3,341. Fredy 2,456.00 1,276.00 3,456.00 6,432.00 2,453. Alexis 3,445.00 2,434.00 2,342.00 1,235.00 2,355. Herly 2,546.00 2,786.00 3,789.00 2,365.00 3,652. Elizabed 3,256.00 3,456.00 1,254.00 2,354.00 4,353. Juana 1,657.00 3,564.00 4,321.00 1,262.00 2,432. Bernardo 3,579.00 3,564.00 2,343.00 3,452.00 4,325. Joseluis 4,451.00 4,352.00 2,345.00 3,212.00 2,341. Maricielo 3,342.00 2,334.00 2,343.00 2,135.00 3,321. Mariana 2,334.00 3,344.00 3,445.00 2,314.00 3,222. TOTAL 29,755.00 28,611.00 28,194.00 28,086.00 31,795. VENDEDOR SUMA META 100% DIFRERENCIA Juan 34,529.00 ### 43% 57% Fredy 29,537.00 ### 37% 63% Alexis 34,390.00 ### 43% 57% Herly 38,663.00 ### 48% 52% Elizabed 36,465.00 ### 46% 54% Juana 32,645.00 ### 41% 59% Bernardo 37,075.00 ### 46% 54% Joseluis 38,301.00 ### 48% 52% Maricielo 33,775.00 ### 42% 58% Mariana 34,565.00 ### 43% 57% TOTAL

REPORTE DE JUAN

REPORTE DE ALEXIS

1 2 43%

REPORTE HERLY

1 2 48%

REPORTE DE BERNARDO

46%

REPORTE DE MARICIELO

1 42% 2

JUNIO JULIO AGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBRE SUMA

32,578.00 25,915.00 26,463.00 32,061.00 23,999.00 32,132.00 30,356. 1 2

REPORTE DE JUAN 37% 63%

REPORTE DE FREDY

1 2

RLY REPORTE DE ELIZABED

1 2 41%

REPORTE DE JUANA

1 2 46%

REPORTE JOSE LUIS

48%

MARICIELO

1 2

REPORTE JOSE LUIS

1 2 48%

MARICIELO

1 2