Excel Assignment Part 2: Continue This Week

Question

Excel Assignment Part 2this Week You Will Continue To Work With The Sc Use your spreadsheet from last week. If you did not calculate the sales in column E within the spreadsheet, fill in that column with numbers. Create a column chart of the monthly sales based on class by selecting the range A2:D5; ensure the months display in the legend. Give the chart a title of "Monthly Sales" and label the vertical (Y) axis as "Sales in $". Next, create a pie chart showing the profit for April for all three classes. Title this chart "April’s Sales" with the legend displaying the three class names. Then, create a line chart of monthly sales based on class, using the same range as the column chart. Title this chart "Monthly Sales," label the Y-axis as "Sales in $" and position the legend on the right for both charts. Ensure months and class labels are correctly displayed. Rename the sheet tab to "Sales". Place a comment in cell A1 containing your full name and GID number. Save the spreadsheet with the filename format: CS105_Wk7_YourLastName_YourFirstName_YourGIDNumber. The charts should visually resemble the provided examples, depending on your data.

Dr. Jack HW Helper · Accepted Answer

Introduction The assignment focuses on creating comprehensive sales and profit analysis charts and data in Excel, building on a previously established spreadsheet. The goal is to utilize Excel’s charting and formatting capabilities to illustrate business performance across different classes and months, providing clear visual insights for decision-making. Data Preparation and Formatting To start, the existing spreadsheet from the previous week must be used. If sales numbers in column E are missing, they should be inputted with appropriate dollar values, formatted as currency with no decimal places. Additionally, the spreadsheet's header cells, such as "Software Sales," should be merged across cells B1 through D1, centered, and bolded for emphasis. The months—April, May, and June—should be entered in cells B2, C2, and D2, respectively, and formatted to be centered and bold. Similarly, the class names ("Word," "Excel," and "PowerPoint") are entered in cells A3, A4, and A5, formatted as bold. The sales data for each class and month should be filled in with individual dollar amounts, all formatted as currency. Total and average calculations for sales and profit are also necessary, using Excel formulas like SUM and AVERAGE in designated cells (e.g., B7, C7, D7 for total sales, and B8, C8, D8 for averages). Chart Creation and Customization The core of the assignment involves creating three types of charts: Column Chart: Displays monthly sales by class, selected from the range A2:D5. The chart should be titled "Monthly Sales," with the Y-axis labeled "Sales in $," and the months shown in the legend. Pie Chart: Represents the profit distribution among classes for April, with the title "April’s Sales" and a legend showing class names. Ensure the correct range of profit data for April is selected. Line Chart: Similar to the column chart, this visualizes monthly sales over the same range, titled "Monthly Sales," with the legend positioned to the right for clarity. All charts sh

Excel Assignment Part 2: Continue This Week ✓ Solved

Excel Assignment Part 2this Week You Will Continue To Work With The Sc

Sample Paper For Above instruction

Introduction

Data Preparation and Formatting

Chart Creation and Customization

Conclusion

References