In this project you will create a spreadsheet averaging the


Unit 1 - Discussion Board

Primary Task Response: Within the Discussion Board area, write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.In the Mercantile period, from the 16th through the end of the 18th centuries, trade was driven by a need to accumulate gold and silver. Nations worked to restrict imports and drive exports. With the advent of the Industrial Age, classical economists began to look at trade and international commerce in a different light. In his seminal work The Wealth of Nations, Adam Smith discussed the idea that the basis of trade could be seen in light of what he called absolute advantage. His contemporary, David Ricardo, took a different and modified approach and laid out a framework called comparative advantage. This latter theory is the basis for all modern views of international trade. For this Discussion Board, complete the following:Define absolute and comparative advantage. Compare the two views on trade. How does the concept of opportunity cost factor into comparative advantage? Discuss why you think comparative advantage has become the fundamental and accepted theory of trade. Provide concrete examples.

Spreadsheet


Imagine that you are currently enrolled in three CTU classes: UNIV104, IT254, and MATH102. In this project, you will create a spreadsheet averaging the list of CTU classes that you are currently enrolled in.

1. You will begin by opining the spreadsheet IT254_week1IP_GradeAverage containing your grade percentages for each assignment in an Excel spreadsheet.

2. Additionally, you will create a formula to summarize the total average for each class you are currently taking and each assignment.

3. Finally, you will format your spreadsheet to make it visually appealing.

Instructions

Part 1: Opening the Spreadsheet

1. Open the Excel workbook titled IT254_week1IP_GradeAverage and save the worksheet as "FirstInital_LastName_GradeAverage.xlsx."

Part 2: Entering Data and Formulas into the Spreadsheet

1. On the Grade Average worksheet, select G7 and type "Average." In cell G8, use a formula to generate the average of the contents in Cells B8:F8. Use the fill handle to populate your results through G10.

o The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...).
o Arguments can be numbers, named ranges, cell references that contain numbers, or arrays.

2. Select Cell A12, and enter "Class Average." Use a formula to generate the average of IP Assignment 1 in cell B12. Use the fill across handle to populate your results of averaging the other assignments to F12.

3. On the Class Average worksheet, apply the Number format with zero decimal points to the range B12:F12.

4. On the Class Average worksheet, change the page setup options so that the data is centered horizontally on the page.

5. On the Class Average worksheet, create a header that will display your name in the center section of the header area. To preview your Class Average worksheet, click Print Preview. Return to Normal view to continue working on the document.

6. On the Class Average worksheet, create a footer that will display the Instructor's name in the center section.

7. Save the workbook. Close the workbook, and then exit Excel.

Finally, submit your saved workbook by clicking the "Edit" button on this submission node.

Here are some tips if you have problems to submit your Word document:

1. Try to save as Excel 97-2003 Workbook (*.xls) and re-submit.
2. Try to submit with a different Web browser.
3. Try to submit from a different computer.

Solution Preview :

Prepared by a verified Expert
Financial Accounting: In this project you will create a spreadsheet averaging the
Reference No:- TGS02520965

Now Priced at $15 (50% Discount)

Recommended (93%)

Rated (4.5/5)