Create an itemized list of at least ten items

Assignment Help Other Subject

Reference no: EM132189564

Question: For this discussion, you will need to address all of the questions below and be sure to participate fully by responding to your classmates as well. Citations should be used to support your analysis and references should be included in APA format. Be sure to review the Discussion Question Guidelines before you begin!

This 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 don't lose any work! Name each worksheet descriptively.

Sheet 1 (which you will rename).

1. 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.

2. When you have entered your data, Sort your information by Item.

3. 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 Microsoft Excel to do a formula calculation. Refresh your memory on the use of formulas from this week's 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.

1. Open a spreadsheet in MS Excel and create your formula. Make sure you label components of your spreadsheet.

2. 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.

3. Delete the unused worksheets by right clicking on them one at a time and choosing Delete.

Reference no: EM132189564

Questions Cloud

Explain the differences between blood and certain disorders : Explain the differences between blood, as well as blood-forming organs, and certain disorders involving the immune mechanism.

How can they overcome these challenges : What three management challenges faces apple company and how can they overcome these challenges

How people are motivate and lead in samsung company : How people are motivate and lead in samsung company? And which motivational thoery they use?

What factors could be generalized to others or to other : Try to identify what it is that accounts for that extraordinary performance. What factors could be generalized to others or to other settings?

Create an itemized list of at least ten items : 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.

Analyse the benefits south africa appears to be gaining : MGT101: The new factories have had the benefit of generating thousands of new jobs and forcing hundreds of small and medium-sized local suppliers.

Explain the basic steps in the planning process : Describe the steps in the decision making process and predict how the personal attributes of the manager influence decision making.

Calculate the transaction price allocated to equipment : Estimated standalone fair values of the equipment, installation, and training are $75,000, $50,000, and $25,000. Calculate the transaction price

Demonstrate a mastery of the complex skills : ECM40IS: IS/IT Strategy - Discuss in detail the strategies adopted in the case Study mentioned and critically analyze the same

User Account

All Pages