**Question description:**

*This user has given permission to use the problem statement for this blog.*

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

Solved by Z. A. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
21/06/2018 - 06:05

Hi

Excelchat Expert
21/06/2018 - 06:05

Can you attach the file here?

User
21/06/2018 - 06:06

one sec let me try or I can send the link

User
21/06/2018 - 06:06

http://class.coloradotech.edu/CbFileShareCommon/ctu/IT254/Assignment_Assets/IT254_week1IP_GradeAverage.xlsx

Excelchat Expert
21/06/2018 - 06:07

thanks, downloading

User
21/06/2018 - 06:07

Thanks my computer is not allowing me to upload the file

User
21/06/2018 - 06:08

I need assitance with the following items if possible

User
21/06/2018 - 06:08

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

Excelchat Expert
21/06/2018 - 06:08

copy that

User
21/06/2018 - 06:09

Thanks I have been working on it all night but I really need some help

Excelchat Expert
21/06/2018 - 06:10

Hehe this is easy

Excelchat Expert
21/06/2018 - 06:11

here you go

[Uploaded an Excel file]

User
21/06/2018 - 06:11

thanks can you assist me with a little more

User
21/06/2018 - 06:12

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.

Excelchat Expert
21/06/2018 - 06:12

if it is still related to this then i can

User
21/06/2018 - 06:12

yes it is

User
21/06/2018 - 06:12

same docment

User
21/06/2018 - 06:13

this is my second part

Excelchat Expert
21/06/2018 - 06:14

hold on

User
21/06/2018 - 06:14

Thank you I guess seeing it compared to what I have done is amazing

User
21/06/2018 - 06:17

hi are you still there

Excelchat Expert
21/06/2018 - 06:17

yes

User
21/06/2018 - 06:17

okay thanks I thought I had lost you

Excelchat Expert
21/06/2018 - 06:17

i cannot seem to find out how to center the data

Excelchat Expert
21/06/2018 - 06:19

what's your name?

User
21/06/2018 - 06:19

thats okay are you able to send me the new document and tell me where to add a footer

User
21/06/2018 - 06:19

Tempestt

Excelchat Expert
21/06/2018 - 06:19

your instructor?

User
21/06/2018 - 06:20

Daniel Berman

Excelchat Expert
21/06/2018 - 06:21

you go to PAGE LAYOUT>PAGE SET UP GROUP and go to Header/Footer Section

Excelchat Expert
21/06/2018 - 06:21

You can edit/Customize the footer and header

User
21/06/2018 - 06:21

found it thanks

User
21/06/2018 - 06:22

where you able to complete the second part ecept the center

User
21/06/2018 - 06:23

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

User
21/06/2018 - 06:25

Is anyone there

Excelchat Expert
21/06/2018 - 06:26

can i make it go to the center by inserting new columns beside column B?

User
21/06/2018 - 06:27

no I think I am supposed to change the alignment to horizontal does this sound correct?

Excelchat Expert
21/06/2018 - 06:28

if horizontal only, then it is easy. You just have to select the orientation to landscape

Excelchat Expert
21/06/2018 - 06:28

but to center, i do not know

User
21/06/2018 - 06:29

on can you show me how to center it horizontal?

Excelchat Expert
21/06/2018 - 06:31

i do not know how to center it

User
21/06/2018 - 06:32

is the info currently horizontal?

Excelchat Expert
21/06/2018 - 06:32

but let me check

Excelchat Expert
21/06/2018 - 06:33

i know now

User
21/06/2018 - 06:33

okay thank you this is the part I am most confused on

Excelchat Expert
21/06/2018 - 06:33

go to Page Layout>Page Set Up>Margins Tab

Excelchat Expert
21/06/2018 - 06:33

then select horizontal

Excelchat Expert
21/06/2018 - 06:34

below on the Center on Page option

User
21/06/2018 - 06:34

can you please do this for me i AM SO CONFUSED

User
21/06/2018 - 06:37

Thank you for all you help I have been working this for days I had no idea a service like this existed

Excelchat Expert
21/06/2018 - 06:37

here you go

[Uploaded an Excel file]

Excelchat Expert
21/06/2018 - 06:38

please do not hesitate to continue use our service if you encounter excel problems like this :)

User
21/06/2018 - 06:39

Thank you

Excelchat Expert
21/06/2018 - 06:40

do you still have questions?

Excelchat Expert
21/06/2018 - 06:40

please do not forget to rate our session when it ends

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*