The document contains details of sales data across multiple categories including books, apps, cameras, TV shows, exercise equipment, tablets, software, and cars. For each category, the document lists product names, relevant sales metrics like units sold and targets, prices, and calculates final prices with VAT and total sales revenue. The tasks involve formatting the data, calculating values using functions, analyzing sales targets, and creating bar charts to visualize results.
The document contains details of sales data across multiple categories including books, apps, cameras, TV shows, exercise equipment, tablets, software, and cars. For each category, the document lists product names, relevant sales metrics like units sold and targets, prices, and calculates final prices with VAT and total sales revenue. The tasks involve formatting the data, calculating values using functions, analyzing sales targets, and creating bar charts to visualize results.
The document contains details of sales data across multiple categories including books, apps, cameras, TV shows, exercise equipment, tablets, software, and cars. For each category, the document lists product names, relevant sales metrics like units sold and targets, prices, and calculates final prices with VAT and total sales revenue. The tasks involve formatting the data, calculating values using functions, analyzing sales targets, and creating bar charts to visualize results.
The document contains details of sales data across multiple categories including books, apps, cameras, TV shows, exercise equipment, tablets, software, and cars. For each category, the document lists product names, relevant sales metrics like units sold and targets, prices, and calculates final prices with VAT and total sales revenue. The tasks involve formatting the data, calculating values using functions, analyzing sales targets, and creating bar charts to visualize results.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 10
Task 1 - Book Sales
17.5% Books Price VAT Delivery Price Final Price Diary of a Wimpy Kid: 5.5 1 Harry Potter and the Sorcerer's Stone 6 2.2 The Heroes of Olympus 4.5 3 The Hunger Games 5.5 2 The Maze Runner 6.5 1.5 The Book with No Pictures 3.5 3 Mockingjay 5 2 Total Highest Lowest Average
1) Apply Formatting (Apply Borders, shading & format Text (including currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Use a function to work out the Final Price (Price + Tax + Delivery Price) 4) Work out the Total, Highest, lowest and average values of the Final Price.
Graph: 5) Create a simple bar chart showing the final price for each book. Include appropriate titles. Task 3 - Apps
Target 17.5% Apps Category Downloads Donwloads Price VAT Final Price Minecraft – Pocket Edition Games 103 100 2.5 Goblin Sword Games 32 100 3.5 Sleep Cycle alarm clock Health 120 100 1.75 Photo & Afterlight Video 234 100 2.8 7 Minute Workout Challenge Health 125 100 2.25 Photo & Videoshop Video 74 100 1.75 Total Count Highest Count All Apps Lowest Games Average Health
Sumif (Final Price)
Games Health Photo & Video
1) Apply Formatting (Apply Borders, shading & format Text (including
currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the Final Price (Price + Tax) 4) Work out the Total Sum (Downloads*Price) 5) Use an IF Function to work out if the Target downloads has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each APP. Include appropriate titles. Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each APP. Include appropriate titles. Total Sum on target Task 5 - Cameras 17.5% Units Target VAT (Price & Final Cameras Brand Sold Sales Price Lens Lens) Price Total Sum on Target D3300 Nikon 2 5 450 145 EOS 70D Cannon 4 3 400 105 EOS 6D Cannon 6 5 350 80 LUMIX Panasonic 4 3 550 55 D810 Nikon 2 5 350 85 Total Count Highest Count All Brands Lowest Nikon Average Cannon
Sumif (Final Prce)
Nikon Cannon
1) Apply Formatting (Apply Borders, shading & format Text
(including currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Use a Function to work out the Final Price (Price + Lens + Tax) 4) Work out the Total Sum (Units Sold *Price) 5) Use an IF Function to work out if the Target sales has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each camera. Include appropriate titles. Task 2 - Tv Shows 17.5% Tv Shows Season Units Sold Target Sales Price VAT Final Price Total Sum on target Once Upon A Time 2 23 15 12.5 The Walking Dead 3 45 20 13.5 Lost 4 24 20 10.5 Heroes 2 24 25 12.5 The 100 1 22 25 11.5 Under the Dome 1 12 20 10.5 Lost 5 23 20 9.55 Total Highest Lowest Count All Tv Shows Average
1) Apply Formatting (Apply Borders, shading & format Text (including
currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the Final Price (Price + Tax) 4) Work out the Total Sum (Units Sold *Price) 5) Use an IF Function to work out if the Target sales has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each TV show. Include appropriate titles. Task 4 - Exercise Equipment 17.5% Equipment Units Sold Target Sales Price VAT Final Price Total Sum On Target Treadmill 23 15 140 Exercise Bike 54 25 235 Rowing Machine 34 30 232 Step Machines 23 35 145 Total Highest Lowest Average
1) Apply Formatting (Apply Borders, shading & format Text (including currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the Final Price (Price + Tax) 4) Work out the Total Sum (Units Sold *Price) 5) Use an IF Function to work out if the Target sales has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each equipment. Include appropriate titles. Task 6 - Tablets 17.5% Tablets Brand Units Sold Target Sales Price VAT Final Price Total Sum on Taget Surface Pro 3 Microsoft 27 35 340 Nexus 7 Google 35 30 370 Venue 8 Pro Dell 32 30 450 iPad mini Apple 12 25 340 Total Highest Lowest Average
1) Apply Formatting (Apply Borders, shading & format Text (including currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the Final Price (Price + Tax) 4) Work out the Total Sum (Units Sold *Price) 5) Use an IF Function to work out if the Target sales has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each tablet. Include appropriate titles. Task 7 - Software 17.5% Software Brand Units Sold Target Sales Price VAT Final Price Total Sum on Target Photoshop Adobe 12 20 55 Word Microsoft 32 20 34 Fireworks Adobe 43 20 65 Windows 8 Windows 23 20 125 Dreamweaver Adobe 12 20 65 Excel Microsoft 31 20 35 Powepoint Microsoft 32 20 25 Total Highest Lowest Average
1) Apply Formatting (Apply Borders, shading & format Text (including
currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the Final Price (Price + Tax) 4) Work out the Total Sum (Units Sold *Price) 5) Use an IF Function to work out if the Target sales has been met. 6) Work out the Total, Highest, lowest and average values of the Total Sum.
Graph: 7) Create a simple bar chart showing the final price for each software. Include appropriate titles. Task 8: Cars 17.5% Car Name Brand Paid Price (inc VAT) Sold Price VAT New Sold Price Profit Made Profit Land Cruiser Toyota 21000 23000 Prado Toyota 11000 13000 Path Finder Nissan 18000 16000 Captiva Chevrolet 16000 16500 Total Highest Lowest Average
1) Apply Formatting (Apply Borders, shading & format Text (including
currency) 2) Work out the VAT price. You have to use absolute cell referencing. 3) Work out the New Sold Price (Sold Price + Tax) 4) Work out the Profit (New Sold Price-Paid Price) 5) Use an IF Function to work out if the profit is more than £1. 6) Work out the Total, Highest, lowest and average values of the New Sold Price.
Graph: 7) Create a simple bar chart showing the New Sold price for each car. Include appropriate titles.
