Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Cis 105 asu excel answers

16/10/2021 Client: muhammad11 Deadline: 2 Day

CIS 105 Assignement 2 Excelling With Excel

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 the document in a different location, click 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. 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):

cFirst, in the Title Page worksheet, enter the following information.

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 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 this (1) Microsoft Excel sheet that includes the following information and formatting. 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

WK8_A2_Instructions
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 the document in a different location, click 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. 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-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.)  Autofit the contents of column A so you can see the name of each supply item name.  Format cells A3-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 example, will you need four (4) notebooks?  Set the width of column B to 11.5”.  Format cells B3-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-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-D12 to calculate the total cost of the other supplies.  Format cells D3-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 price 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.)

http://www.staples.com
Title Page
Name:
Course Section:
Professor Name:
Title of the Assignment:

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Financial Solutions Provider
Accounting & Finance Mentor
Top Rated Expert
Accounting & Finance Specialist
Premium Solutions
Homework Tutor
Writer Writer Name Offer Chat
Financial Solutions Provider

ONLINE

Financial Solutions Provider

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$39 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$32 Chat With Writer
Top Rated Expert

ONLINE

Top Rated Expert

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$17 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$36 Chat With Writer
Premium Solutions

ONLINE

Premium Solutions

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$21 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$43 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Verify that the linear speed of an ultracentrifuge - Data communication and networking basics pdf - American justice susan smith - Finding nemo movie worksheet - Stratford career institute exam answers - Unit 1 Assessment - P.R.I.C.E. Model Applications - Katy perry firework song lyrics - Health point garden city - The magic of ipod case study - Discussion - Grandma and the elusive fifth crucifix - How to leave hialeah pdf - How venture capitalists evaluate potential opportunities - Ark of the covenant pyramid - List and discuss three prominent application areas for text mining - Jindal naturecure institute cost - In the blink of an eye pdf - RISK ANALYSIS (RISK MANAGEMENT PLAN) - Mcgraw hill american history answers - Density of water in lbm ft3 - Bloomberg businessweek b-school connection - Henry molaison case study - Kevin in tomorrow when the war began - 3-Pages - work - School by kyoko mori questions and answers - Nanda nursing diagnosis list 2020 - Language barriers in the workplace - 16 cooraminta street brunswick - Softest soap for carving - Realidades 2 2a vocabulary - Persuasive speech on donating to charity - Managers who advocate job enrichment focus on creating jobs with - Physics - Small gas engines fundamentals service troubleshooting repair applications - Order 2336844: Timbre/Sound Color: What is it? - Discussion - Cyber Security - Jane gave birth to a baby boy two weeks ago - 1.4 3 quiz communication strategies - Discussion-14 - Lord of the flies homework help - Tafe queensland learning management system - The arc of ambition defining the leadership journey pdf - How to measure the thickness of a book - Exam timetable release monash - Drafting materials and tools drawing instrument - What is a statement of environmental effects - Rogerian argument thesis statement examples - Sainsbury makers of the millennium medal collection - Continued work extend 3 more pages ... - Cmi calculation - Online reputation management process ppt - Turnaround at the preston plant - Seton hall email address - Help - Separation of photosynthetic pigments by paper chromatography lab report - Tangent ratio worksheet answer key - The will to win by vince lombardi - Just for feet inc - Question about Macroeconomics and GDP - Disaster Recovery Plan - Disadvantages of digital publishing - Weather map symbols and what they mean - Cultural authority was conveyed to the medical profession mainly through - Self reliance videos lds - Organisational behaviour buchanan and huczynski 8th edition - Proactiv magazine ad - Roof beam span tables australia - Budenberg gauge company ltd - Mr palermo spectroscopy lab answers - Law 8 dis - Hope gerund or infinitive - Children's shoe sizes by age - Vox tonelab le multi effects pedal - This egg is surrounded by mysterious reflective dust - Anyone can do my assignment? - Fp solutions financial planning software - Project Management complexity - Fiona summers flex n tone - Disability access certificate application - Vce eal listening task resources - Mat 300 midterm exam answers - Mass of empty 50 ml beaker - Ryan terry road to olympia ebook pdf - C++ program to convert decimal to binary using functions - The following information has been obtained for the gocker corporation - Mothers work inc case study - Target from expect more to pay less case study answers - What is summation of force - N 4 l 0 orbital - 32 amp junction box - Accounting - World cultures and geography western hemisphere and europe - Night chapter 9 summary - Extra points - Safe at work self assessment test - Create your own website google sites - The crucible and the dressmaker sample essay - Let's talk digital key answers - Does true altruism exist