Spreadsheet design and basic utilities

Be sure to download the companion resources using the link provided in the reading assignments.

Spreadsheet attached!

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.

  1. You will begin by opining the spreadsheet IT254_week1IP_GradeAverage containing your grade percentages for each assignment in an Excel spreadsheet.
  2. Additionally, you will create a formula to summarize the total average for each class you are currently taking and each assignment.
  3. Finally, you will format your spreadsheet to make it visually appealing.

Instructions

Part 1: Opening the Spreadsheet

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

  1. 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.
  2. 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.
  3. On the Class Average worksheet, apply the Number format with zero decimal points to the range B12:F12.
  4. On the Class Average worksheet, change the page setup options so that the data is centered horizontally on the page.
  5. 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.
  6. On the Class Average worksheet, create a footer that will display the Instructor’s name in the center section.
  7. Save the workbook. Close the workbook, and then exit Excel. Submit your Excel spreadsheet.

We offer the best custom writing services. We have done this question before; we can also do it for you…

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more