13 Nov Part 2 DiscussionThis week, you will be creating t
Part 2 DiscussionThis week, you will be creating two Excel spreadsheets in one Excel workbook (file). Save the file as W4DQ_YourLastName (Excel will add the default of .xlsx to this name) and then Save often so you dont lose any work! Name each worksheet descriptively.Sheet 1 (which you will rename).Create an itemized list of at least ten (10) items that you will need for your graduation party.Lay out your Excel spreadsheet following the example below. Make your columns as wide as you need to show all the information for that column by double clicking on the line between the columns or dragging the line between the columns. Cell B2 had the Wrap Text on the Home ribbon in the Alignment group turned on due to the length of the description. Only include numbers in the Cost per Unit, Quantity, and Cost columns so your calculations will work.When you have entered your data, Sort your information by Item.Share any questions about this or anything else in the Discussion Area.Sheet 2 (which you will rename).MS Excel is a great help with calculations which are completed using formulas. Remember, by typing an equal sign (=) into a cell, you are preparing MicrosoftExcel to do a formula calculation. Refresh your memory on the use of formulas from this weeks assigned reading and the online lectures. For Sheet 2, think of a situation at home, work, or even a hobby or sport for which you could use a calculation and create a formula to solve a problem.Open a spreadsheet in MS Excel and create your formula. Make sure you label components of your spreadsheet.In the Discussion Area when you attach your file, describe the purpose of your formula and how it will help solve the problem it was designed to address. Share any challenges you had as well as tips for others.Delete the unused worksheets by right clicking on them one at a time and choosing Delete.By the due date assigned, make your initial post to the Discussion Area. By the end of the week, respond to at least two of your classmates.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Do you need help with this question?
Get assignment help from Aqhomework.com Paper Writing Website and forget about your problems.
Aqhomework provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Click Order now to access our order form, fill your paper details correctly, select your paper deadline and wait for our writers to send a perfectly written assignment.
Chat with us today! We are always waiting to answer all your questions.