Topic 2 - Spreadsheets

Study Unit 4 / 5: Exam – Percentages

 

PERCENTAGES
VAT
A percentage = a fraction i.e. 100% = 1
DETAILS R              %                  WRITTEN OUT AS EXCEL
SELLING PRICE 500            100                1.00
VAT   75              15                0.15
SELLING PRICE 575            115                1.15
MARK UP & MARKUP MARGIN
DETAILS R               %                WRITTEN OUT AS EXCEL
COST-OF-SALES 1,580             100              1.00
MARK-UP    316               20              0.20
SALES 1,896             120              1.20
GROSS PROFIT AND GROSS PROFIT MARGIN
DETAILS R             %                WRITTEN OUT AS EXCEL
COST OF SALES 2,000            80                0.80
GROSS PROFIT    500            20                0.20
SALES 2,500          100                1.00
Study Unit 4 / 5: Exam – VLOOKUP (Prev Lesson)
(Next Lesson) Study Unit 6: Spreadsheet security, risks and controls
Back to Topic 2 – Spreadsheets

No Comments

Comments are closed.