Excelling with Excel | Due Week 8 and worth 175 points

Excelling with Excel | Due Week 8 and worth 175 points.

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 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 the Microsoft Excel template that includes the required information and formatting.

Steps:

  1. Review this Assignment 2 Sample to see a completed version of this assignment for reference. Note: You may not copy any information from this sample into your own assignment. Select the “Read-Only” option when the password window appears as you open this sample.
  2. Download the Assignment 2 Directions and Template workbook here.
  3. Follow the directions that are listed in the template.
  4. Save your document with the following name: CIS105_Assignment2_FirstName_Last Name_Date.xlsx
  5. Submit your assignment through the submission button.

Use the template to record and calculate the costs of the school materials you purchased for this quarter.

  • 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.
    • Type the title (“Excelling with Excel“) of the assignment in cell B4.
    • 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.
  • Search for the school supplies you purchased at Amazon, Office Depot, Staples, or some other store.
  • 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
    • CellC2: 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 didn’t buy 10 supplies, list what you would have purchased or will purchase next term.)
    • Auto fit 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, 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.)

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using this rubric.

Recommended TestOut Desktop Pro Skills Labs to review prior to completing this assignment:

  • 3.2.5 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 video to review prior to completing this assignment: Different options are listed based on the version of Microsoft Excel you are using (2016 vs. 2013, PC vs. Mac). Note: The Strayer student laptops come with Microsoft Excel 2016 PC version. Note: Review at a minimum the Introduction and Getting Started chapters of the video.

Helpful Videos on How to Create Charts in Excel:

Excelling with Excel | Due Week 8 and worth 175 points

Get a Quick Quote

Approximately 250 words
Total price (USD) $: 10.99

Let us do the hard and easy stuff in nursing for you

Find an experts in Nursing Papers and kickstart your grades today with NursingPapersLib.com

Best nursing assignment writers

It is easy to promise the availability of help with nursing assignments but without the best nursing assignment writers in the industry, such promises can turn out to be hot air. Our expert nursing writing services feature seasoned professionals who have been providing nursing writing help and consultation services for a long time. Irrespective of the year of study or practice students are involved in, the best nursing assignment writers know the nuances of nursing student’s needs. There is no better way to assure you of the best nursing writing services than providing nursing writing help from peers who are ahead of you and have only the best interests at heart. Only the best nursing assignment writers will handle your request for the best nursing writing service because your communication can get through to them. Knowing the potential nursing writing help that you seek from the way you frame your request is the hallmark of a writer who provides expert nursing writing services. This is because, with their knowledge, there is likely less room for misunderstood requests when you are seeking the best nursing writing service you need.

How it Works

Place an Order

Provide your contact information, select an order type, and describe your requirements. This isn’t going to take long!

Image showing step 1 of making an order
Image showing how to make payment for your order

Select an Appropriate Writer

We’ll match your specifications with our available authors after we have all of the relevant information concerning your order.

Image showing how to download your completed results

Enjoy the End Product

One of our specialists will fulfill your purchase according to your specifications so that you are happy with the end result.

Why Choose us?

Free Revisions

We understand that not always out tutors could catch all details required which arises a s a result of miscommunication or inadequate information provided. However, we are always eager to provide you with free revisions till we get it right with your Nursing Papers.

Quality Non-plagiarized Nursing Papers

Our Professional Team of Nursing Writers always adhere to quality standards and plagiarism policy. Furthermore, we employ Quality Control Tools to ensure you get Custom Written Nursing Paper. Every paper is reviewed by an independent editor for syntax errors before submission

Professional Nursing Writers

At NursingPapersLib.com, we specialize in Nursing Homework Help Services only. Thus, this allows us to cater to our nursing students and get high qualified nursing tutors who will deliver exceptional results in nursing papers

Flexible Pricing

We always endear to provide best prices that matches our quality and your budget. This is why we provide a pricing mechanism based off several factors such as length, level of education and type of assignment. our pricing are highly competitive across the industry standard prices.