Excel assigment | Computer Science homework help



Excel 2013 Assignment 2 – Self-Paced Option

(complete following Tutorial #’s 13 – 19)

For this assignment, you will work with a workbook of a class roster with various grades and student records. You’ll practice writing formulas, as well as sorting and filtering data.

Download the File

Download and save the file Excel 2013 Assignment 2 from the course Moodle site.. For more instructions on how to download files, review How To Download a File.

Edit the File

Open the file you just saved. (You may have to click Enable Editing in order to start editing the document.) 


Select row 3 and then use the Freeze Panes command on the View tab to freeze rows 1 and 2 in place.

HINT: When you’re done, rows 1 and 2 will stay in place as you scroll through the worksheet.

Select cell G3. Next, insert a formula or a function to add up the values in cell range B3:F3.

HINT: Remember to begin your formula with the equal sign ( = ).

HINT: When you’re done, the calculated value should be 86.

Select cell G3 and then drag the fill handle all the way to cell G18. When you’re done, the formula will be copied to cell range G4:G18 and calculated values should appear in those cells.

Select cell D9 and change the value from 0 to 14. Notice how the formula re-calculates the value in cell G9.

Select cell G19 and edit the function to include the cell range G3:G18 in the argument.

HINT: When you’re done, the calculated value should be 75.06

Select cell H3. Next, insert a formula that will subtract the value in cell G19 from cell G3. When writing your formula, make anabsolute reference to cell G19.

HINT: G3 should not be an absolute reference in the formula.

HINT: When you’re done, the calculated value should be 10.94.

Select cell H3 and then drag the fill handle all the way to to cell H18. When you’re done, the formula will be copied to cell range H4:H18 and calculated values should appear in those cells.

HINT: When you’re done, the value of cell H4 will be 11.94. If this is incorrect, check the absolute reference in your formula, then repeat steps 6-7.

Select cell M3. Next, Insert a formula that will first add the values in cells G3 and L3, and then divide that value by 4.

HINT: Use the order of operations to ensure that the values in G3 and L3 are added together before dividing by 4.

HINT: When you’re done, the calculated value should be 92.25.

Select cell M3 and then drag the fill handle all the way to cell M18. When you’re done, the formula will be copied to cell range M4:M18 and calculated values should appear in those cells.

Select cell range A2:M18. Next, use the Sort command on the Data tab to sort the range by Name from A-Z.

HINT: When you’re done, Angela Alston should be the first student listed in the workbook.

With the same cell range selected, click the Filter command on the Data tab. A drop-down arrow should appear in the header cell for each column.

Click the drop-down arrow for column M and apply a number filter that will filter between two values.

In the dialog box that appears, set the filter to show values greater than or equal to 80, and less than or equal to 90. This will display values in the 80-90 range.

HINT: When you’re done, only 4 students should be visible in the workbook.

Before submitting, double-check your assignment:

The data in G18 should read 81.

The data in H18 should read 5.94.

The data in M18 should read 82.50.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Good work.
Customer 463053, June 20th, 2022
Good work on the spreadsheet.
Customer 459155, May 31st, 2022
Business and administrative studies
Customer 458115, May 16th, 2022
Always edit in Grammarly.
Customer 462635, April 8th, 2022
Customer 463463, November 1st, 2022
Healthcare & Medical
Good content and organization.
Customer 452441, April 13th, 2022
English 101
Good job.
Customer 462537, April 4th, 2022
All instructions well followed.
Customer 463813, March 8th, 2023
Well done. I just needed to rephrase a few things, but overall good.
Customer 458067, January 29th, 2022
Business Studies
Excellent as always!
Customer 454647, June 26th, 2020
Well researched
Customer 463679, April 15th, 2023
Computer science
Even though I received the paper on time, the person that I received the paper from kept telling that did submit the paper to me and there no link available to me to download and revise the paper until excessive close to the deadline. This is not good business, considering that there at least a week to write not to mention the support kept telling me that I was submitted when it wasnt...
Customer 452515, April 9th, 2020
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat