Allot 2 – Spreadquibble Editing (10 marks)
The exercises in Lab 2 – Spreadquibble Editing succeed contribute cheerful manner control this integralot of the ordinance.
This integralot of the ordinance places you in the role of a sales balanceseer control a imaginary regalement union. In this role, you are obligatory control tracking and suspended sales and sales targets, and tracking and managing the act of sales staff.
Control this integralot of the ordinance, you succeed deficiency the subjoined finishs proficonsideration in the P2Axioms folder in the OrdinanceData.zip finish that is proficonsideration control download from Canvas:
1. P2-Data1.xlsx
You succeed whole the subjoined finishs which succeed comprehend your effect control this integralot of the ordinance and be integralot of the zip finish which you succeed suggest on Canvas (with YOURSTUDENTID replaced with your scholar ID enumerate):
1. P2-YOURSTUDENTID-SalesReports.xslx
Instructions
1. Open P2-Data1.xlsx using Microsoft Excel. Punishion ‘Reserve As’ to reserve a portraiture of this finish as P2- YOURSTUDENTID-SalesReports.xlsx (replacing YOURSTUDENTID with your scholar ID enumerate). Construct knowing you reserve your effect constantly to quit losing any progress! The passage and axioms that is comprised in P2-Data1.xlsx is the axioms you succeed be subjoining to and using control this integralot of the ordinance.
2. Control integral of the subjoined steps, punishion a operation wherever embezzle.
3. Control the Coercionbearancely Sales Summary quibble, construct the subjoined subjoinitions:
a. In the ‘Sum 2018’ support (F), subjoin controlmulas to rate the sum control sales balance integral impure coercionbearances control that expression of network.
b. In the ‘Incomplete 2019 Sales Extension’ support (G), subjoin controlmulas to rate the incomplete 2019 sales extension which is the treapermanent in Sum 2018 multigenous by the
Incomplete Sales Growth treapermanent in line 4. Complete the controlmula control ‘Classic Movie and TV Networks’ and punishion the rise discretion to portraiture the controlmula control the other expressions of network.
c. In the ‘Totals’ line (12), subjoin controlmulas to rate the sum control each coercionbearance, sum control 2018, and incomplete 2019 sales extension.
d. In the ‘Trend’ support (H), subjoin a Sparkline to demonstration the substitute in sales control each neteffect balance the coercionbearances in 2018.
e. Subjoin a chart that demonstrations how each of the networks contributed to the sum 2018 sales. Construct knowing the chart has an embezzle subjoinress and labels. Place the chart under the consideration.
f. In a cell immediately under the chart, little ( 200 articulation) absolve your precious of chart expression.
g. Controlmat the quibble embezzlely, ensuring integral cells and treasures are embezzlely controlmatted and the fluctuation are altogether evident at 100% zoom. Integral sales figures are in dollars.

4. Control the Premiumes quibble, construct the subjoined subjoinitions:
a. Control the ‘Sum Sales’ support (G), subjoin controlmulas to rate the sum annual sales (balance integral impure coercionbearances) of each sales figurative’s sales. Apply embezzle biased controlmatting to the sum sales support so that the advertring-to act of each separate sales figuratives compared to each other can be instantly seen.
b. In the ‘Bonus’ support (H), subjoin controlmulas so that sales figuratives whose sum annual sales are over the mediocre annual sales control integral sales figuratives assent-to a premium (‘Yes’), and the others do advertable attribuconsideration attribuconsideration attribuconsideration (‘No’). Also subjoin biased controlmatting in this support to highlight any ‘Yes’ treasures.
c. In the ‘Total’ line (18), subjoin controlmulas to rate the sum sales by sales figuratives control each coercionbearance and balance integral impure coercionbearances.
d. Under the Summary Statistics subjoinress, control each register penetrate controlmulas (in support D) to rate and parade the statistics as listed. Advertable attribuconsideration attributablee: You should advertable attribuconsideration attribuconsideration attribuconsideration entertain to substitute the axioms consideration in prescribe to complete this.
e. Subjoin a chart that demonstrations how sum sales by integral sales figuratives combined has grown and shrunk balance the impure coercionbearances. Construct knowing the chart has an embezzle subjoinress and labels. Place the chart under the consideration.
f. In a cell immediately under the chart, little ( 200 articulation) absolve your precious of chart expression.
g. Controlmat the quibble embezzlely, ensuring integral cells and treasures are embezzlely controlmatted and the fluctuation are altogether evident at 100% zoom. Integral sales figures are in dollars.
5. Control the Sales Projections quibble, construct the subjoined subjoinitions:
a. In the ‘Sum 2018’ support (B), substitute the static treasures to embezzle controlmulas that advert to the embezzle treasures in the Coercionbearancely Sales Summary quibble. Also, subjoin a controlmula in the Sums line control this support (cell B12) to rate the punish sum.
b. In the ‘% of Sum Sales’ support (C), subjoin the embezzle controlmulas to demonstration the percentage gift of each network’s sales to the sum 2018 sales.
c. In the ‘Target % of Target Sum Sales’ support (F), subjoin the embezzle controlmulas to demonstration the percentage gift of each network’s target sales whole to the sum target sales.
d. Delete the target whole control International Networks (cell E11). Then punishion Goal Seek to indicate the target whole of International Networks that is required control it to construct up 13% of sum sales hence from International Networks.
e. Controlmat the quibble embezzlely, ensuring integral cells and treasures are embezzlely controlmatted and the fluctuation are altogether evident at 100% zoom. Integral sales figures are in dollars.
6. Create a pivot consideration in a strange quibble using integral of the axioms (A9:G223) in the Skips quibble. Using this pivot consideration:
a. What is the sum of sales from skips control Film Regalement Networks in Australia (AUS)? Penetrate this treapermanent in the cell A4 of the Skips quibble.
b. How plenteous did Lisa Vanderbeck lavish on skips (Skip expenditures) in Coercionbearance 3? Penetrate this treapermanent in the cell A5 of the Skips quibble.

c. Which sales figurative had the prominent mediocre gain per skip? Penetrate their designate in cell A6 of the Skips quibble.
d. Which sales figurative made no skips in a loving coercionbearance? Penetrate their designate and the coercionbearance in which they made no skips (e.g. John Smith, Q1) in cell A7 of the Skips quibble.
e. Set up the pivot consideration to demonstration gain control the Film Regalement Neteffect merely, reclaimed down by Region and Coercionbearance. Controlmat the treasures paradeed by the pivot consideration embezzlely, ensuring that the fluctuation are altogether evident at 100% zoom.
7. Construct knowing you reserve your completed effectquibble as P2-YOURSTUDENTID-SalesReports.xlsx
(replacing YOURSTUDENTID with your scholar ID enumerate) control inferiority.

~~~For this or similar assignment papers~~~