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.