Illustrated Excel 365/2021 | Module 4: SAM Project 1b скачать в хорошем качестве

Illustrated Excel 365/2021 | Module 4: SAM Project 1b

To Get this Solution Contact us on Email and WhatsApp is given in Video WhatsApp no : +923114151799 Email address: solution000777@gmail.com Format chart title Click the chart title. On the Format tab, select Shape Outline → Theme Colors → Brown, Accent 6 (10th column, 1st row). Go to Shape Effects → Shadow → Outer → Offset: Bottom Right. Gridlines Select the chart → Click Chart Elements (+) → uncheck Primary Major Vertical Gridlines. Check Primary Major Horizontal Gridlines. Horizontal axis title Click Chart Elements (+) → Axis Titles → Primary Horizontal. In the axis title box, type 2024 Quarters. Select the title text → change font to Calibri Light, size 16 pt. 2. Quarterly Profit worksheet → 2-D Pie Chart Select the pie chart → go to Chart Tools → Design → Chart Styles → Style 8 (this style shows percentages on slices). Move legend: click the legend → go to Legend Options → Left. Explode largest slice (Quarter 2): click Quarter 2 slice → drag slightly outward OR right-click → Format Data Point → Point Explosion: 10%. 3. New Services worksheet → Clustered Column Chart Resize & reposition Select the chart → drag so upper-left corner aligns with cell H3 and lower-right corner with cell N17. Chart title Add chart title: Quarterly Revenue. Colors Go to Chart Design → Change Colors → Monochromatic Palette 2. Change data series fill Click once on the Security plan series → right-click → Format Data Series → Fill → Dark Red, Accent 2, Lighter 40% (6th col, 4th row). Axis values formatting Select cells B5:F7 → apply Accounting number format → decrease decimals to 0. This formatting applies to the chart’s vertical axis labels automatically. 4. New Chart → Quarterly Profit (Line with Markers) Select range B20:E21 → Insert tab → Line with Markers chart. Add chart title: Quarterly Profit. Resize and reposition chart so upper-left corner is inside H19 and lower-right corner is inside N32. Move the legend to the left Chart Design Add Chart Element Legend Left. Explode the largest slice (Quarter 2) by 10% Click once on the Quarter 2 slice to select the whole series, then click that slice again to select just that point. Right-click Format Data Point Series Options Point Explosion = 10%. (Or drag the slice slightly outward, then fine-tune using Point Explosion = 10%.) New Services worksheet (Clustered Column: Oakland revenue over four quarters) Resize & reposition the clustered column chart Click the chart border to select the chart area. Drag the chart so its upper-left corner sits inside cell H3. Drag the sizing handles so the lower-right corner ends inside cell N17. (Tip: Zoom to 120–150% for precise corner placement.) Add a chart title Chart Design Add Chart Element Chart Title Above Chart. Click the title box and type Quarterly Revenue. Change chart colors to Monochromatic Palette 2 Chart Design Change Colors Monochromatic category Monochromatic Palette 2 (2nd one). Recolor the “Security” data series Click any Security column to select that series (click again if needed to ensure just that series is selected). Right-click Format Data Series Fill & Line (paint bucket) Fill: Solid fill. Choose Dark Red, Accent 2, Lighter 40% (Theme Colors: 6th column, 4th row). Apply Accounting number format to the source values (updates the axis) Select range B5:F7. Home Number group Accounting Number Format. Click Decrease Decimal until it shows 0 decimals. (If the vertical axis doesn’t reflect this, right-click the vertical axis Format Axis Number Accounting, Decimal places 0, and make sure “Linked to source” is checked.) Create a “Quarterly Profit” line chart with markers a) Insert the chart Select range B20:E21. Insert Insert Line or Area Chart Line with Markers. b) Set chart title Click the title and type Quarterly Profit. c) Resize & position Drag the chart so its upper-left corner sits inside cell H19 and its lower-right corner ends inside cell N32. #NewPerspectivesExcel2019Module1EndofModuleProject1 #NewPerspectivesExcel2019Module1EndofModuleProject2 #NewPerspectivesExcel2019Module2EndofModuleProject1 #NewPerspectivesExcel2019Module2EndofModuleProject2 #NewPerspectivesExcel2019Module3EndofModuleProject1 #NewPerspectivesExcel2019Module3EndofModuleProject2 #NewPerspectivesExcel2019Module4EndofModuleProject1 #NewPerspectivesExcel2019Module4EndofModuleProject2 #NewPerspectivesExcel2019Module5EndofModuleProject1 #NewPerspectivesExcel2019Module5EndofModuleProject2 #NewPerspectivesExcel2019Module6EndofModuleProject1 #NewPerspectivesExcel2019Module6EndofModuleProject2 #NewPerspectivesExcel2019Module7EndofModuleProject1 #NewPerspectivesExcel2019Module7EndofModuleProject2 #NewPerspectivesExcel2019Module8EndofModuleProject1 #NewPerspectivesExcel2019Module8EndofModuleProject2 #NewPerspectivesExcel2019Module9EndofModuleProject1 #NewPerspectivesExcel2019Module9EndofModuleProject2 #NewPerspectivesExcel2019Module10