Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with 3-5. thank you Apply your creative thinking and problem-solving skills to design and implement a solution. Instructions: You are assigned to be

image text in transcribed
image text in transcribed Need help with 3-5. thank you
Apply your creative thinking and problem-solving skills to design and implement a solution. Instructions: You are assigned to be in charge of Scholarship Fund for your school. You are given a student databased table with their GPAs and the criterion table to assign them with a letter grade. Please use formulas to calculate if they should get scholarship based on the rule of GPA-4 they will get 55000, otherwise O. Please also use in their margrade for on the criterion table. Once you are done with your SS data, please perform the following tasks, sorting and query Scholarship Table GRADE TABLE Gender Age Scholarship Amount GPA Grade GPA Grad Student ID 452618 name Chucky Frame Kate 471829 491827 Trello Chan Len Suzy Counte Forkner Meg 521989 610298 638192 721890 756719 781020 121928 Lyn Julie 0.42 Delta Fritz Lopes Leone Frye Hector Sally Janice Total 23.1 Consider The Plan Ahead Guidelines Grading Notes Suggested Score Percent 1. Create worksheet table with correct data and formatted headings You should create an attractive worksheet that starts approximately in row 7. Headings should be formatted. Using a table style is best. Provide conditional format for GPA column 2. Use formula to complete the workbook table Please use IF function to complete the scholarship column (if GPA is greater and equal to 4.00 scholarship, then 5000, otherwise 0. Use Vlookup function to complete letter grade column based on the criterion given 3. Create criteria run nge should start in row and the headings should be identical to the 4. Create extract range Extract range should be to two rows below the criteria range. The headings should be identical to the table. 5. Individual Extractions You may copy the result of the query and sorting result to a separate electronic document I sort Student by LN in Ascending order 2 select all the scholarship recipients 3 select all the students whose GPA is greater than 4 4. Sort students by letter grade and age in descending order TOTALS Apply your creative thinking and problem-solving skills to design and implement a solution. Instructions: You are assigned to be in charge of Scholarship Fund for your school. You are given a student databased table with their GPAs and the criterion table to assign them with a letter grade. Please use formulas to calculate if they should get scholarship based on the rule of GPA-4 they will get 55000, otherwise O. Please also use in their margrade for on the criterion table. Once you are done with your SS data, please perform the following tasks, sorting and query Scholarship Table GRADE TABLE Gender Age Scholarship Amount GPA Grade GPA Grad Student ID 452618 name Chucky Frame Kate 471829 491827 Trello Chan Len Suzy Counte Forkner Meg 521989 610298 638192 721890 756719 781020 121928 Lyn Julie 0.42 Delta Fritz Lopes Leone Frye Hector Sally Janice Total 23.1 Consider The Plan Ahead Guidelines Grading Notes Suggested Score Percent 1. Create worksheet table with correct data and formatted headings You should create an attractive worksheet that starts approximately in row 7. Headings should be formatted. Using a table style is best. Provide conditional format for GPA column 2. Use formula to complete the workbook table Please use IF function to complete the scholarship column (if GPA is greater and equal to 4.00 scholarship, then 5000, otherwise 0. Use Vlookup function to complete letter grade column based on the criterion given 3. Create criteria run nge should start in row and the headings should be identical to the 4. Create extract range Extract range should be to two rows below the criteria range. The headings should be identical to the table. 5. Individual Extractions You may copy the result of the query and sorting result to a separate electronic document I sort Student by LN in Ascending order 2 select all the scholarship recipients 3 select all the students whose GPA is greater than 4 4. Sort students by letter grade and age in descending order TOTALS

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

The Principles Of Project Finance

Authors: Rod Morrison

1st Edition

1409439828, 9781409439820

More Books

Students also viewed these Finance questions

Question

=+how might their legitimacy be improved?

Answered: 1 week ago