excel
quilanPart 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. Highlight B7:G7, center, and bold.
- 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 Accounting 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 the text 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.
- 9 years ago
- 10
Answer(5)
Purchase the answer to view it
- a_smith_gradeaverage.xlsx_..xlsx
Purchase the answer to view it
NOT RATED
- psy_315_r4_week_two_practice_problems_.docx
Purchase the answer to view it
NOT RATED
- a_smith_gradeaverage.xlsx_..xlsx
Purchase the answer to view it
NOT RATED
- it_254_week_1ip_grade_average.xlsx
Purchase the answer to view it
NOT RATED
- it_254_week_1_ip_grade_average.xlsx
- it_254_week_1_ip.xlsx
Bids(1)
other Questions(10)
- COM 172 Rough Draft
- (Mberiah Only) LOG302: Inventory Management
- I have Business resarch methods course assingment
- Multiple Choice Questions Employment Law
- 20 MCQ's
- 20 MCQ's
- Describe the anatomy (structure) and physiology (function) of a plant. Is the structure of your plant a modification from the standard root, stem, leaf, or flower?
- discussion 8
- ACC 557
- See Description