Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For questions 4,5,6 needs formulas of financial functions or references functions I need just the solution please dont worry if you couldnt not type al

image text in transcribedFor questions 4,5,6 needs formulas of financial functions or references functions I need just the solution please dont worry if you couldnt not type al this stuff I now its a lot but I need just the formulas if can in Excel 2016 CSE2111.if you dont solve it please let me now because Im waiting and need to know dont ignore please I send it for time today and no answer to me
You have created the spreadsheet Grades! to keep tract of class scores. On worksheet Login you have imported the Login names of your students off of the CIS department's computer system. You have also set up your letter grading criteria on sheet Letter!. Now you will incorporate all of this Login! 21032 11:30 FAWC 1:30 ROSS 1566 5 2325 11:30 CLARK FACTO 8 4408 11:30 BUCHA 9 4755 11 30 GHIZZ GRANT 12 6453 1130 GRAN 4 8350 DUNLA 1:30 DECHR 18 8963 1130 B 19 9874 11:30 HANNA 4 POINTS GRADE 420 540 9 PERSON WITH LOWEST TOTAL SCORE DANA DANIEL 4. (3 points) Write an Excel formula in cell Grades!C2 to insert the login name for this student. Write the formulas so that it can be copied down. Students are uniquely identified by their id# on both the Grades! And Login! worksheets. 5. (5 points) Write an Excel formula in cell Grades!G2, which can be copied down the column, to insert the appropriate letter grade this student earned. Students earning less than 360 points receive an E, those received at least 360 points but less than 420 points receive a D etc. 6. (3 points) Write a formula in cell Letter!E9 to list the name of the student with the lowest point

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions