Scribd
Upload
296 views2 pages

Microsoft Excel Practice Exam 3

The document provides instructions for a Microsoft Excel practice exam involving a student grade book spreadsheet. It instructs the user to download a practice exam file, open it, and complete the following tasks in separate sections: 1) format and enter formulas in the grade book worksheet, 2) insert a new student row and copy formulas, 3) format averages, 4) make a copy and sort the worksheet. Completing the tasks involves functions, formatting, sorting, and saving the spreadsheet file.

Uploaded by

Michael Bone-crusher Phiri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
296 views2 pages

Microsoft Excel Practice Exam 3

The document provides instructions for a Microsoft Excel practice exam involving a student grade book spreadsheet. It instructs the user to download a practice exam file, open it, and complete the following tasks in separate sections: 1) format and enter formulas in the grade book worksheet, 2) insert a new student row and copy formulas, 3) format averages, 4) make a copy and sort the worksheet. Completing the tasks involves functions, formatting, sorting, and saving the spreadsheet file.

Uploaded by

Michael Bone-crusher Phiri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Microsoft Excel Practice Exam 3

Instructions to download and unzip the file needed to perform this practice exam.

Go to the Practice Exam Files Download web page: http://cs12.cs.qc.cuny.edu/practice.html


on the CSCI 012 Lab Website to follow the instructions to obtain the practice exam files.

Open the file Practice_3 and save it with the name Practice_3_Solution.

Note: Each section in this exam corresponds to one of the worksheets in the spreadsheet file.
For example, Grade Book corresponds to the Grade Book worksheet in the spreadsheet file.

Grade Book:
1. Center and merge Professor’s Grade Book across cells A1 through J1. Change its font
size to 16 and font color to dark blue. Change the background color of the cell containing
Professor’s Grade Book to yellow and change the height of row one to 25.50.

2. Adjust column widths and use functions when necessary. Enter formulas to fill in cells
according to the following:

Semester Average is in cell I4: If the student’s homework is OK then the semester
average is the test average plus the homework bonus in cell H16; otherwise, the semester
average is just the test average. For example, John Adam’s semester average is 80.8.

Letter is in cell J4: Based on the student’s semester average, use VLOOKUP to assign
the student a letter grade according to the Grading Scheme found in the Grade Book
worksheet.

Copy the formulas in cells I4:J4 to the 10 rows below row 4, rows 5 to 14.

Class Average is in cell C16: The class average of test 1.

Highest Grade is in cell C17: The highest grade amongst all students for test 1.

Lowest Grade is in cell C18: The lowest grade amongst all students for test 1.

Copy the formulas in cells C16:C18 to the 3 columns to the right of column C, columns
D to F.

3. Format the class averages and semester averages to 2 decimal places.

1
4. Insert a row between the rows containing the names Carson, Kit and Coulter, Sara.
Type in your name as the student in this new row. Enter 123-45-6789 for the Student
ID, grades 80, 70, 100 and 90 for Tests 1 through 4, and OK for the Homework. Copy
(if needed) the appropriate formulas into Test Average, Semester Average, and Letter.

5. Press the Save button to save the spreadsheet file.

6. Make a copy of the Grade Book worksheet, placing the worksheet copy after the Grade
Book worksheet. Rename the copied worksheet with the new name Sorted.

Sorted:
Click the worksheet tab labeled Sorted.
Sort the entire list of students by sorting the Semester Averages in descending order.
Press the Save button to save the spreadsheet file.

Exit Microsoft Excel.

You might also like