# Excel - AVERAGE Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at