Scribd
Upload
188 views6 pages

CSC134 - Excel - Muhammad Alif - 2021469618 - Rat1102a

The document shows monthly sales data for 12 months from January to December. It provides the weekly sales figures and total monthly sales. The highest monthly sales were in August at RM1,600 and the lowest were in March at RM750. The total annual sales for the period were RM12,150.

Uploaded by

szkipper 03
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
188 views6 pages

CSC134 - Excel - Muhammad Alif - 2021469618 - Rat1102a

The document shows monthly sales data for 12 months from January to December. It provides the weekly sales figures and total monthly sales. The highest monthly sales were in August at RM1,600 and the lowest were in March at RM750. The total annual sales for the period were RM12,150.

Uploaded by

szkipper 03
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

JANUARY FEBRUARY MARCH

week Sales Week Sales Week Sales


1 RM200 1 RM150 1 RM200
2 RM200 2 RM100 2 RM300
3 RM300 3 RM350 3 RM100
4 RM200 4 RM400 4 RM150
Total RM900 Total RM1,000 Total RM750

JULY AUGUST SEPTEMBER


week sales week sales week sales
1 RM350 1 RM400 1 RM300
2 RM400 2 RM400 2 RM400
3 RM150 3 RM400 3 RM350
4 RM50 4 RM400 4 RM500
Total RM950 Total RM1,600 Total RM1,550

MONTH JAN FEB MAR APR MAY JUN JUL


SALES RM900 RM1,000 RM750 RM800 RM1,000 RM850 RM950
TOTAL RM12,150

MAXIMUM=AUGUST(RM1600)
MINIMUM=MARCH(RM750)
APRIL MAY JUNE
week sales week sales week sales
1 RM250 1 RM400 1 RM250
2 RM350 2 RM200 2 RM350
3 RM50 3 RM300 3 RM100
4 RM150 4 RM100 4 RM200
Total RM800 Total RM1,000 Total RM850

OCTOBER NOVEMBER DECEMBER


week sales week sales week sales
1 RM350 1 RM200 1 RM250
2 RM400 2 RM350 2 RM300
3 RM450 3 RM350 3 RM400
4 RM300 4 RM150 4 RM150
Total RM1,500 Total RM1,050 Total RM1,100

AUG SEP OCT NOV DEC


RM1,600 RM1,550 RM1,500 RM1,050 RM1,100

You might also like