Fluent Essays

Instructions to Complete Week 8 Assignment 2 Use this workbook to write down and calculate the costs of the school materials you purchased for this quarter. Consider the following materials you needed for your course work (i.e., use the stated amounts below regardless of the actual items / costs you may have purchased / paid): First, in the Title Page worksheet, enter the following information. Type your name in cell B1. Type in the course section you are in cell B2. (For example: CIS105111) Type your professor’s name in cell B3. Type the title of the assignment in cell B4. (The title is “Excelling with Excel”) Rename the worksheet to Overview. Change the font type for this information to Century Gothic. Change the font size for this information to 14 point. Open an Internet browser such as Mozilla Firefox or Google Chrome. Search for the school supplies you purchased at Amazon, Office Depot, Staples, or some other store. Amazon: www.amazon.com Office Depot: www.officedepot.com Staples: www.staples.com Find ten supplies that you purchased. You can include textbooks, lab code fees, and paper supplies such as notepads, planners, pens, pencils, highlighters, etc. Go to Sheet 3. This will be where you add your list of school supplies. Type a title in cell A1. (For example: “School Supply Costs” or “My School Purchases.”) Format cell A1, so the font type is Calibri Light (Headings), the font size is 20-point, and the font color is one of your choosing. Enter the following labels in the cells specified. Cell A2: School Supplies Cell B2: Quantity Cell C2: Price Cell D2: Total Cost Make the font size 16 point and bold these labels. Column A: School Supplies In cells A3 through A12, enter the names of the ten (10) school supplies that you purchased. (If you didnt buy 10 supplies, list what you would have purchased or will purchase next term.) Autofit the contents of column A so you can see the name of each supply item name. Format cells A3 through A12 so the text is 16-point Calibri Light (Headings) and the font color is orange. Column B: Quantity In column B enter the Quantity for each of the supplies. For example, will you need four (4) notebooks? Set the width of column B to 11.5”. Format cells B3 through B12 so the text is 16-point Calibri Light (Headings) and the font color is brown. Column C: Price Enter the price for each school supply item. For example, a single notebook costs $5. Expand column C so you can see all of your costs. Format cells C3 through C12 so the font is Arial, the font size is 14-point, and the font color is dark blue. Column D: Total costs Use the multiplication function to determine the total cost for each item. Hint (In D3, the formula would be =(B3*C3). Fill in cells D4 through D12 to calculate the total cost of the other supplies. Format cells D3 through D12 so the font is Arial Bold and the font size is 14-point, and the font color is dark blue. Now, rename Sheet 3 to “School Supplies.” Create a pie chart In the School Supplies worksheet, select the range “School Supplies” and “Total Costs.” Insert a pie chart that displays the school supply items and the total cost for each item. Select the pie chart view that shows the dollar amounts for each item. Add a title to your chart so the title is above the chart (can be found in “Chart Formatting”). Add data labels to the pie chart that shows the total cost for each item. Position the chart so it does not overlap with the data in column A, column B, and column C. Review the assignment for accuracy. Note: Delete the WK8_A2_Overview and WK8_A2_Instructions sheet before you submit this assignment for grading. (Left click on each sheet to delete.) cis105_assignment2_sample.xlsx cis105_assignment2_template_and_directions.xlsx Unformatted Attachment Preview Name: Course Section: Professor Name: Title of the Assignment: Jane Doe CIS1051111 Eleanor Smith Excelling with Excel My School Purchases School Supplies Pens Pencils Notebooks TestOut Books Computer mouse Paper Calendar Agenda Calculator Quantity 5 1 4 1 2 1 2 1 1 1 Price Total Cost $5 $5 $5 $100 $75 $30 $10 $10 $20 $50 Breakdown of School Supply Costs Pencils, $5 Pens, $25 Notebooks, $20 Calculator, $50 Calendar, $10 Agenda, $20 Paper, $20 TestOut, $100 Computer mouse, $30 Books, $150 $25 $5 $20 $100 $150 $30 $20 $10 $20 $50 Assignment 2: Excelling with Excel Due Week 8 and worth 175 points Overview Microsoft Excel is a great tool for presenting, organizing, and calculating data. It can be used to create budgets, track you 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 this (1) Microsoft Excel sheet that includes the following information an Steps: 1. Complete the steps listed in the WK8_A2_Instructions sheet. 2. Save your document with the following name – CIS105_Assignment2_FirstName_Last Name.xlsx 3. Submit your assignment in Week 8. Recommended TestOut Desktop Pro Skills Labs to review prior to completing this assignment are: 3.2.4 Skills Lab: Create and Manage Workbooks 3.3.5 Skills Lab: Organize and Enter Data 3.5.6 Skills Lab: Format Cells 3.6.4 Skills Lab: Enter Simple Formulas 3.8.4 Skills Lab: Analyze Data in Charts Recommended Lynda.com Videos to Watch Microsoft Excel 2013 Lynda.com Video: Excel 2013 Essential Training URL: https://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html Microsoft Excel 2016 Lynda.com Video: Excel 2016 Essential Training URL: https://www.lynda.com/Excel-tutorials/Excel-2016-Essential-Training/376985-2.html Excel for Mac 2011 Lynda.com Video: Excel for Mac 2011 Essential Training URL: https://www.lynda.com/Excel-2011-for-mac-tutorials/essential-training/71210-2.html Excel for Mac 2016 Lynda.com Video: Excel for Mac 2016 Essential Training URL: https://www.lynda.com/Excel-tutorials/Excel-Mac-2016-Essential-Training/159244-2.html create budgets, track your weekly spending, or create detailed t school supply purchases. e following information and formatting. Instructions for Saving a File You will be using this file to complete this assignment, so remember to save your changes as you go along. Hint: When saving this workbook for the first time, Microsoft Excel saves the document in a default location. To save another folder or location in the Save As dialog box. 1. Click File, and then click Save As. 2. Save using the file name - CIS105_Assignment2_FirstName_Last Name_Date.xlsx. 3. Click Save. Instructions to Complete Week 8 Assignment 2 Use this workbook to write down and calculate the costs of the school materials you purchased for this quarter. C needed for your course work (i.e., use the stated amounts below regardless of the actual items / costs you may h    First, in the Title Page worksheet, enter the following information. • Type your name in cell B1. • Type in the course section you are in cell B2. (For example: CIS105111) • Type your professor’s name in cell B3. • Type the title of the assignment in cell B4. (The title is “Excelling with Excel”) • Rename the worksheet to Overview. • Change the font type for this information to Century Gothic. • Change the font size for this information to 14 point. Open an Internet browser such as Mozilla Firefox or Google Chrome. Search for the school supplies you purchased at Amazon, Office Depot, Staples, or some other store • Amazon: www.amazon.com • Office Depot: www.officedepot.com • Staples: www.staples.com  Find ten supplies that you purchased. You can include textbooks, lab code fees, and paper supplies such as notepads, planners, pens, pencils, h  Go to Sheet 3. This will be where you add your list of school supplies.  Type a title in cell A1. (For example: “School Supply Costs” or “My School Purchases.”) •   Format cell A1, so the font type is Calibri Light (Headings), the font size is 20-point, and the font colo Enter the following labels in the cells specified. • Cell A2: School Supplies • Cell B2: Quantity • Cell C2: Price • Cell D2: Total Cost • Make the font size 16 point and bold these labels. Column A: School Supplies •     Make the font size 16 point and bold these labels. Column A: School Supplies • In cells A3 through A12, enter the names of the ten (10) school supplies that you purchased. (If you would have purchased or will purchase next term.) • Autofit the contents of column A so you can see the name of each supply item name. • Format cells A3 through A12 so the text is 16-point Calibri Light (Headings) and the font color is ora Column B: Quantity • In column B enter the Quantity for each of the supplies. For example, will you need four (4) noteboo • Set the width of column B to 11.5”. • Format cells B3 through B12 so the text is 16-point Calibri Light (Headings) and the font color is bro Column C: Price • Enter the price for each school supply item. For example, a single notebook costs $5. • Expand column C so you can see all of your costs. • Format cells C3 through C12 so the font is Arial, the font size is 14-point, and the font color is dark b Column D: Total costs • Use the multiplication function to determine the total cost for each item. • Hint (In D3, the formula would be =(B3*C3). • Fill in cells D4 through D12 to calculate the total cost of the other supplies. • Format cells D3 through D12 so the font is Arial Bold and the font size is 14-point, and the font colo  Now, rename Sheet 3 to “School Supplies.”  Create a pie chart  • In the School Supplies worksheet, select the range “School Supplies” and “Total Costs.” • Insert a pie chart that displays the school supply items and the total cost for each item. • Select the pie chart view that shows the dollar amounts for each item. • Add a title to your chart so the title is above the chart (can be found in “Chart Formatting”). • Add data labels to the pie chart that shows the total cost for each item. • Position the chart so it does not overlap with the data in column A, column B, and column C. • Review the assignment for accuracy. Note: Delete the WK8_A2_Overview and WK8_A2_Instructions sheet before you submit this assignment f to delete.) s you go along. default location. To save the document in a different location, click chased for this quarter. Consider the following materials you l items / costs you may have purchased / paid): or some other store. anners, pens, pencils, highlighters, etc. point, and the font color is one of your choosing. at you purchased. (If you didnt buy 10 supplies, list what you em name. and the font color is orange. ou need four (4) notebooks? and the font color is brown. k costs $5. nd the font color is dark blue. point, and the font color is dark blue. Total Costs.” each item. rt Formatting”). B, and column C. submit this assignment for grading. (Left click on each sheet Name: Course Section: Professor Name: Title of the Assignment: ... Purchase answer to see full attachment