Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please put Excel forms Professor Streterstein is a bit absentminded. His instructor's grade book is a mess, and he would like your help cleaning it

Please put Excel forms image text in transcribed
image text in transcribed
Professor Streterstein is a bit absentminded. His instructor's grade book is a mess, and he would like your help cleaning it up and making it easier to use. In Professor Streterstein's course, the maximum possible points a student can earn is 750 . The following table displays the grade equivalent to total points for the course. Help Professor Streterstein rework his grade book. Open the data file 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 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

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

2 What supply is and what affects it.

Answered: 1 week ago

Question

3 How supply and demand together determine market equilibrium.

Answered: 1 week ago