User Account

All Pages

Create a footer that will display the instructors name

Assignment Help Business Management
Reference no: EM131264740

Be sure to download the companion resources using the link provided in the reading assignments.

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." Use a formula to generate the average of the contents in Cells B8:F8 in cell G8. 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. Submit your Excel spreadsheet.

Attachment:- IT254_week1IP_GradeAverage.xlsx

Reference no: EM131264740

Questions Cloud

Should you pay as a means of accomplishing your business : If such payments are not considered wrong in those countries, should you pay them as a means of accomplishing your business?
What we can learn when things go wrong : Describe several broad principles that could be applied in helping the individuals involved understand what went wrong in the following events. What suggestions could you make for remedying the problems involved?
Provide your thoughts on the given topic : Provide your thoughts on the topic for this week in a minimum 2 paragraph response. What information did you find interesting or useful in your communication experiences?
Is lego engaged in socially responsible behavior : Which external environmental factor in this case is least important to LEGO's success? Which external environmental factor, in this case, is most important to LEGO's continuing success? Is LEGO engaged in socially responsible behavior
Create a footer that will display the instructors name : On the Class Average worksheet, create a footer that will display the Instructor's name in the center section. Save the workbook. Close the workbook, and then exit Excel. Submit your Excel spreadsheet.
What does the abbreviation utc indicate : What does the abbreviation UTC indicate?- How is a 12-hour clock different from a 24-hour clock? With which are you most familiar?
Calculate the threshold voltage for the circuit : Calculate the threshold voltage for the circuit. Assume the maximum output voltage swing of the op-amp is ± 3 V for when the supply is ± 5 V.
How self-serving reasoning could play a part in the decision : Discuss how self-serving reasoning could play a part in these decisions? How motivation influenced people to make such terrible decisions. Had exponential discounting played a part in the decision(s) that you had researched. If so, how?
Discuss strengths and weaknesses of your selected theory : Select either Kohlberg's theory of moral development, Gilligan's theory of moral development, or Fowler's theory of faith development - Discuss the strengths and weaknesses of your selected theory.

Reviews

Write a Review

Business Management Questions & Answers

  Show the cultural dimensions in virtual teams

Why is it important to understand the cultural dimensions of a virtual team and how does this affect group communication?

  Pros and cons of the six capital budgeting methods

Summarize the pros and cons of the six capital budgeting methods. In what types of situations would capital budgeting decisions be made solely on the basis of project's Net Present Value (NPV)?

  Discuss the data modeling guidelines which have been develop

Data modeling is neither simple nor inexpensive to conduct. Discuss the data modeling guidelines which have been developed to deal with the concerns of time, organizational commitment, and human resource needs.

  What are some of the considerations that might be taken

Should the advertising message that has been effective in the U.S. be used in Argentina? Why or why not? What are some of the considerations that might be taken into account regarding product attributes?

  Research commercial data repositories

Research commercial data repositories. Be sure to understand this business model, including the services, benefits.

  Explain the current situation of the organization

Your paper must be eight to ten pages in length (excluding the title and reference pages) and formatted according to APA style guidelines as outlined in the Ashford Writing Center. In addition, you must use at least three scholarly sources, in add..

  Find the rawlesian location on a utility graph

How do you find the Rawlesian location on a utility graph (with three different utility lines)?

  Examine selected companys specific practices or policies

Examine the selected company's specific practices or policies. Speculate on the major influences that these practices or policies have on individual and organizational outcomes.

  Classify the pros and cons for five different types of oral

Classify the pros and cons for five different types of oral communication delivery methods. Explain which five methods you feel would best fit your particular style for making oral presentations.

  How individual investors make investment decisions in

how individual investors make investment decisions in practice rather than in theorythis assignment is concerned with

  Examine messages using the communication process

Examine these messages using the communication process. The examination should include the following:

  Question regading the overall productivity

For each cashier, compute his or her overall productivity (in orders per hour) over Monday-Friday (including these two days). You should have one number per cashier.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd