formulae: the basics suki’s skates:shop- revenue suki’s skates:shop- revenue what “if”...

MIRAGE AHMED’S ICT E - PORTFOLIO

UNIT 7.4 SPREADSHEETS

UNIT 7.4 CONTENTS

FORMULAE: THE BASICS SUKI’S

SKATES:SHOP-REVENUE WHAT “IF” ANSWERS

COSTS & PROFITS SUKI’S COSTS SUKI’S PROFITS WHAT IF QUESTIONS

ABSOLUTE & RELATIVE CELL REFRENCING SUKI’S SPECIAL OFFER(R

ELATIVE) SUKI’S SPECIAL OFFER(A

BSOLUTE) EXTENSION

RULES AND VARIABLES• SID’S SNOW SCHOOL

CREATNG CHARTS PIE CHART BAR CHART LINE CHART GLOSSARY OF KEY TERMS

1 GLOSSARY OF KEY TERMS

2

SUKI’S REVENUE SHOP

BACK

WHAT “IF” ANSWERS

BACK

SUKI’S COSTSFIRST I PUT EQUALS IN THE FORMULAE BOX .

THEN I PUT IN THE COST THEN I PUT THE TIMES SIGN AND THE UNIT SALES AND PUSHED ENTER.

BACK

SUKI’S PROFITS

BACK

WHAT IF QUESTIONS

BACK

BACK

SUKI’S SPECIAL OFFER RELATIVE

BACK

SUKI’S SPECIAL OFFER ABSOLUTE

BACK

EXTENSION

BACK

RULES AND VARIABLES

BACK

SID’S SNOW SCHOOL

BACK

I CHANGED THE COLOURS SO THE NUMBERS STAND OUT.

PIE CHART

37%

26%

19%

2%

9%

8%

REVENUE COMPARISON

Ski lessonsSnowboarding lessonsLift passHot DrinksSki GlovesHats

THIS IS A PIE CHARTS OF

SID’S SKI SHOP PRODUCTS AND THE

TOTAL REVENUE.

BACK

BAR CHART

Ski lessons

Snowboarding lessons

Lift pass

Hot Drinks

Ski Gloves

Hats

0 50 100 150 200 250 300

Series1

ACTIVIVTY AND UNIT SALES FOR SID’S SKI SHOP

THIS IS A BAR CHART SOWING THE ACTIVITY PRODUCT AND

UNIT SALES FOR SID’S SKI

SHOP

BACK

LINE CHART

Janu

ary

Febr

uary

Mar

chApr

ilMay

June Ju

ly

Augus

t

Sept

embe

r

Octob

er

Novem

ber

Decem

ber

£0.00

£1,000.00

£2,000.00

£3,000.00

£4,000.00

£5,000.00

£6,000.00

£7,000.00

Series1

THE TOTAL REVENUE FOR

2008

THIS IS A LINE CHART SHOWING THE TOTAL REVENUE FOR 2008.

BACK

GLOSSARY OF KEY TERMS 1

BACK

GLOSSARY OF KEY TERMS 2

BACK

ASSESMENT

ASSESMENT

ASSESMENT

ASSESMENT CHART