Overview Assignment 2: Excelling With Excel Due Week

Question

WK8_A2 Overview Assignment 2: Excelling with Excel Due Week 8 and worth 175 points Microsoft Excel is a great tool for presenting, organizing, and calculating data. It can be used to create budgets, track your weekly spending, or create detailed plans. This assignment will give you an opportunity to crunch the numbers on your most recent school supply purchases. Assignment Requirement: To successfully complete this assignment, submit a Microsoft Excel sheet that includes specific information and formatting as outlined in the instructions.

Dr. Jack HW Helper · Accepted Answer

In this assignment, you will demonstrate proficiency in Microsoft Excel by creating a detailed spreadsheet documenting your recent school supply purchases. The task involves data entry, formatting, calculations, and creating a visual representation through a pie chart. This exercise aims to develop skills in organizing data, applying formulas, and creating charts within Excel. The assignment begins with a Title Page worksheet, where personal and course details are to be entered, followed by a data worksheet focused on listing supplies, their quantities, prices, and total costs. You will need to perform multiple formatting tasks, including font changes, cell size adjustments, and color formatting to enhance readability. The creation of a pie chart visualizes the distribution of costs among different supplies, reinforcing your ability to analyze and present data graphically. Tasks Breakdown Part 1: Title Page Enter your name in cell B1, course section in B2, professor’s name in B3, and the assignment title in B4. Rename the worksheet to "Overview". Format all the title page information with Century Gothic font, size 14. Part 2: School Supplies Worksheet ("School Supplies") In cell A1, write the title (e.g., “School Supply Costs”) and format it with Calibri Light, size 20, in a chosen font color. Set up column headers in row 2: "School Supplies", "Quantity", "Price", and "Total Cost", formatted in bold, size 16. Enter names of ten school supplies in cells A3 to A12; also autofit column A. Enter quantities in column B; set column width to 11.5 inches; format B3-B12 with size 16, Calibri Light font, brown color. Enter prices in column C; expand column C to see costs; format C3-C12 with Arial, size 14, dark blue font. Calculate total costs in column D using multiplication formulas (B3*C3 in D3; fill down). Format D3-D12 with Arial Bold, size 14, dark blue font. Part 3: Create a Pie Chart Select data from "School Supplies" and "Total Costs". Insert a pie chart displaying d

Overview Assignment 2: Excelling With Excel Due Week

WK8_A2 Overview Assignment 2: Excelling with Excel Due Week 8 and worth 175 points

Paper For Above instruction

Tasks Breakdown

Part 1: Title Page

Part 2: School Supplies Worksheet ("School Supplies")

Part 3: Create a Pie Chart

Part 4: Finalize and Submit

References