Reference no: EM131180104
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.
You will begin by opining the spreadsheet IT254 GradeAverage containing your grade percentages for each assignment in an Excel spreadsheet.
Additionally, you will create a formula to summarize the total average for each class you are currently taking and each assignment.
Finally, you will format your spreadsheet to make it visually appealing.
Instructions
Part 1: Opening the Spreadsheet
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
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.
The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...).
Arguments can be numbers, named ranges, cell references that contain numbers, or arrays.
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.
On the Class Average worksheet, apply the Number format with zero decimal points to the range B12:F12.
On the Class Average worksheet, change the page setup options so that the data is centered horizontally on the page.
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.
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.
Attachment:- it254_gradeaverage.rar
|
Advantages and disadvantages of this retailing strategy
: Where would be the best locations for the MooBella icecream vending machine? - What are the primary advantages and disadvantages of this retailing strategy?
|
|
Find the navier-stokes equations for a two-dimensional flow
: Do the Navier-Stokes equations apply for any type of flow? If not for what type of flow does it apply for? In a fluid mechanics textbook, find the Navier-Stokes equations for a two-dimensional flow in polar coordinates.
|
|
Some of product strategy options available to a small firm
: What are some of the product strategy options available to a small firm?- Which ones are most likely to be used?
|
|
What is the dynamic viscosity of an ideal fluid
: What is the definition of an ideal fluid? What is the dynamic viscosity of an ideal fluid? Can an ideal fluid flow be supersonic? Explain.
|
|
Create a header that will display your name in the center
: 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.
|
|
Firms need indirect channels of distribution for products
: Why do small firms need to consider indirect channels of distribution for their products? - Why involve intermediaries In distribution at all?
|
|
What is the nominal annual cost of the costly credit
: Jakob Industries buys materials from its suppliers on terms of 1/10, net 25. Thus, it receives 10 days of "free" trade credit, and it can obtain an additional 15 days of "costly" credit if it decides to forego discounts. What is the nominal annual co..
|
|
Prepare a coherently structured paper with an introduction
: Develop a coherently structured paper with an introduction, body, and conclusion. Provide a concluding paragraph to summarize the proposed solution, its advantages, possible disadvantages, and answers to the disadvantages.
|
|
Discuss how your selected strategy can be used in planning
: Discuss how your selected strategy can be used in the planning (what do we need to do?) and programming (how will we do it?) phases of budget preparation to identify less costly solutions for implementing technical, operational, and management con..
|