Bai Giai Sheet TK1 On1_On Mot So Ham 1

Bai Giai Sheet TK1 On1_On Mot So Ham 1 - Hng SX M hng Ngy...

Info icon This preview shows pages 1–7. Sign up to view the full content.

Hãng SX Mã hàng Ngày nhập Sô lượng Khuyến mãi 1 Khuyến mãi 2 SO 05/01/2012 650 SA 06/05/2012 100 TO 07/04/2012 90 TO 04/08/2012 250 SA 07/07/2012 600 TO 09/07/2012 55 SO 25/08/2012 290 SA 28/09/2012 450 SO 30/09/2012 70 TO 24/09/2012 6 SA 21/10/2012 60 TO 26/11/2012 170 SA 25/11/2012 450 SO 20/12/2012 95 Mô tả: Số lượng là các ký tự số của cột Mã hàng Tên hàng và hãng SX TV _ 650 TV _ 100 DM _ 90 LO _ 250 TV _600 DM _55 LO _290 LO _450 DM _70 TV _6 LO _60 TV _170 DM _450 DM _95
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Khuyến mãi 3 Khuyến mãi 4 400000 1 5 4 8 400000 7 7 8 400000 9 9 9 10 11 400000 11 12 Khuyến mãi 5 Khuyến mãi 6 Khuyến mãi 7
Image of page 2
1 1 0 0 1 1 0 1 1 1 0 1 1 0
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

TK B NG NH N XÉT H C T P Mã HV H tên Đi m Đi m TC X p Lo i ế X p h ng ế A01 Le A 5 B01 Bui C 3.5 C02 Tran Y 7.5 A05 Do G 8 B03 Truong L 6.5 A07 Tran D 3 A05 Phan A 9.5 B04 Bui K 8.5 A04 Pham A 5.5 B08 Ly B 2 C10 Tran Y 8 T ng s h c viên Đi m TC cao nh t Đi m TC th p nh t S h c viên có x p lo i Khá ế S h c viên có x p lo i Kém ế
Image of page 4
DÙNG STT 1 2 3 4 5 6 7 8 9 THỐNG KÊ 1 MẶT HÀNH TỔNG SỐ MẶT HÀNG TỔNG SỐ LƯỢNG A001 =COUNTIF($D$3:$D$11,A15) =SUMIF($D$3:$D$11,A15,$E$3:$E$11 B001 1 150 D003 2 1000 C002 1 200 KÝ TỰ ĐẦU MÃ MH A B C D
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

G HÀM COUNTIF VÀ SUMIF ĐỂ THỐNG KÊ MẶT HÀNH A001 A002 A001 B001 B002 C001 C002 D003 D003 1) THỐNG KÊ 3 (THEO SỐ LƯỢNG) THÁNG 1 =SUMIFS($E$3:$E$11,$D$3:$D$11,$C23&"*",$F$3:$F$11,D$22) 0 0 0
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.
  • Summer '13

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern