Скачать или смотреть 4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4 | COURSE NAME CIS108 - MASTER 20250127

#4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4
#4.3 Project: Excel Chapter 3 (SIMnet) #Independent Project 3-4 #COURSE NAME CIS108 #MASTER 20250127
Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?i...

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more

#4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4
#4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3 4
#4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 34
#Project: Excel Chapter 3 (SIMnet) Independent Project 3-4
#Project: Excel Chapter 3 (SIMnet) #Independent Project 3-4
#4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4 | COURSE NAME CIS108
#4.3 Project: Excel Chapter 3 (SIMnet) #Independent Project 3-4 #COURSE NAME CIS108
#Excel #Chapter 3
#SIMnet
#Independent Project
#CIS108
#MASTER 20250127
#4.3 Project
#Excel Formatting
#Excel Functions
#Excel Charts
#Data Analysis
#pivottables s
#Conditional Formatting
#Spreadsheet Skills
Mark the steps as checked when you complete them.


Open the ClassicGardens-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.

Use the Quick Analysis tool to create a Clustered Column chart object for cells A4:G9.

Move the chart object so that its top-left corner is at cell A12. Size the bottom of the chart to reach cell H30.

Edit the chart title to display CGL Gross Margin in Dollars on the first line. On the second line, type By Department. (In the Formula bar, press Alt+Enter to start a new line.)

Apply chart Style 14 to the chart.

Apply a 1 pt Black, Text 1 (second column) outline to the chart area.

Display the primary minor horizontal axis gridlines. Format the major value axis gridlines with a Black, Text 1 outline color. Do not change the color for the minor gridlines. (The Chart Elements drop-down list identifies the gridlines as Vertical (Value) Axis because they track values on the vertical axis.)

Resize the data range to remove the Design Consulting data series from the chart (Figure 3-84).
Resize the chart by dragging the resize pointer
Figure 3-84 Dragging the resize pointer


Select cell A1 and click the BreakEven sheet tab.
Review break-even formulas and build the data source for a line chart.


Select cell B8. The margin per unit is calculated by subtracting the variable cost from the sales price.

Select cell B10. The formula divides the fixed cost by the sales price minus the variable cost (margin per unit). The results are rounded to show no decimal places.

Review the references and formulas in row 15. Build a table for the chart by copying the formulas in row 15 to the blank rows below it up to and including row 24.

Select cell B5 and type 200. Verify that at this price, the break-even point is 200 units. This is the level at which the profit covers all costs.
Create a line chart.


Select cells B14:C24 and E14:F24.

Create a 2-D Line chart with markers for each line.

Position the chart object to start at cell A26 and to reach cell H45.
Edit the source data.


Click the Select Data button [Chart Design tab, Data group].

Click Edit in the Horizontal (Category) Axis Labels area (Figure 3-85). Excel has determined a scale for the category labels, but you can override those results.
Reset the axis labels to override the default number scale
Figure 3-85 Axis labels reset override default number scale


Select cells B15:B24 for the Axis label range and click OK.

Deselect the # Sold box in the Legend Entries (Series) area and click OK (Figure 3-86). These are category labels and should not be plotted as a line.