Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I complete these steps in Excel? I am confused about the whole project! Formatting Grades In this case study, you will format a

How do I complete these steps in Excel? I am confused about the whole project!

image text in transcribed

Formatting Grades In this case study, you will format a gradebook, opply a calculation, use the Vlookup and IF Functions. Professor Williams needs help in organizing his grade book. He would like your help in cleaning it up and making it easier to use. In Professor Williams' course, the maximum points a student can earn is 750. The following table displays the grade equivalent to the total points for this course: Calculated Grade Total Points 675 635 600 560 535 490 450 Case Focus: Help Professor Williams rework his grade book. Open the data file EX_AYK18_Data.xlsx and perform the following: 1. Reformat the workbook so it is readable, understandable, and consistent. Replace column labels, format and align the headings, and add borders and shading as appropriate. 2. Add a column in the grade book for the final grade next to the total points earned column. 3. Use the Vlookup Function to automatically assess final grades based on the total points column. 4. Using the IF Function, format the workbook so each student's grade shows a pass or fail-P for pass, F for fail-based on the total points. Formatting Grades In this case study, you will format a gradebook, opply a calculation, use the Vlookup and IF Functions. Professor Williams needs help in organizing his grade book. He would like your help in cleaning it up and making it easier to use. In Professor Williams' course, the maximum points a student can earn is 750. The following table displays the grade equivalent to the total points for this course: Calculated Grade Total Points 675 635 600 560 535 490 450 Case Focus: Help Professor Williams rework his grade book. Open the data file EX_AYK18_Data.xlsx and perform the following: 1. Reformat the workbook so it is readable, understandable, and consistent. Replace column labels, format and align the headings, and add borders and shading as appropriate. 2. Add a column in the grade book for the final grade next to the total points earned column. 3. Use the Vlookup Function to automatically assess final grades based on the total points column. 4. Using the IF Function, format the workbook so each student's grade shows a pass or fail-P for pass, F for fail-based on the

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions

Question

1. Discuss the four components of language.

Answered: 1 week ago

Question

f. What stereotypes were reinforced in the commercials?

Answered: 1 week ago