Excel Practical - Exercise 6 IF and NESTED IF Statements

User Generated

znegr25

Computer Science

Introduction to information Technology

Description

I don't know how to find the formula if and nested if statements.

In struggling with this

1.Use an IF Function to create the Grade Values.Use the NOTE:Grade Values to help you. You will need to use a NESTED IF statement.

Condition:IF Current Grade = “A”, then 4.0, else IF Current Grade = “B”, then 3.0, else IF Current Grade = “C”, then 2.0, else IF Current Grade = “D”, then 1.0, else IF

Current Grade = “F”, then 0.0, else 0.0


Unformatted Attachment Preview

Excel Practical - Exercise 6 IF and NESTED IF Statements You will be constructing a spreadsheet that you can use to calculate your current Grade Point Average. (GPA) 1. Copy the data from the table below into an Excel Spreadsheet. data as indicated on the columns and rows. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A Subject Math Science English PE Health Computers Social Studies B Current Grade Keep the C Grade Values Total Values = My GPA = Note: Grade Values A = 4.0 B = 3.0 C = 2.0 D = 1.0 F = 0.0 2. Save the document as yourname_P6 3. Add 2 rows at the top of the table 4. Enter the title: GPA Calculator a. Center the title across the table 5. In the column titled, Current Grade, enter grades that you currently have. a. Here are some examples of grades you can try: i. Math: A Science: B English: A PE: C Health: B Computers: B Social Studies: B ii. Math: C Science: B English: C PE: C Health: A Computers: A Social Studies: B iii. Math: A Science: C English: A PE: B Health: A Computers: C Social Studies: C iv. Math: A Science: A English: A PE: D Health: C Computers: B Social Studies: C 6. Use an IF Function to create the Grade Values. Use the NOTE: Grade Values to help you. You will need to use a NESTED IF statement. Condition: IF Current Grade = “A”, then 4.0, else IF Current Grade = “B”, then 3.0, else IF Current Grade = “C”, then 2.0, else IF Current Grade = “D”, then 1.0, else IF Current Grade = “F”, then 0.0, else 0.0 7. At cell B12, insert a formula that calculates the Total of all individual letter grade values found in the Grade Values Column. 8. In the MY GPA= cell, insert a formula that calculates the AVERAGE of all the individual Grade Values. a. Make the values to 2 decimal places 9. Under the cell that calculates MY GPA, Insert an IF Statement for the following condition: If a student's GPA is greater than or equal to a 3.50, then have the cell display HONOR ROLL! If the student's GPA is less than the 3.50, have the cell display, Keep Trying! (Use a Nested IF statement) 10. Format the table to your liking 11. Complete the document properties with your name, subject and tags (minimum of 3 separated by commas) Excel Practical - Exercise 6 IF and NESTED IF Statements You will be constructing a spreadsheet that you can use to calculate your current Grade Point Average. (GPA) 1. Copy the data from the table below into an Excel Spreadsheet. data as indicated on the columns and rows. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A Subject Math Science English PE Health Computers Social Studies B Current Grade Keep the C Grade Values Total Values = My GPA = Note: Grade Values A = 4.0 B = 3.0 C = 2.0 D = 1.0 F = 0.0 2. Save the document as yourname_P6 3. Add 2 rows at the top of the table 4. Enter the title: GPA Calculator a. Center the title across the table 5. In the column titled, Current Grade, enter grades that you currently have. a. Here are some examples of grades you can try: i. Math: A Science: B English: A PE: C Health: B Computers: B Social Studies: B ii. Math: C Science: B English: C PE: C Health: A Computers: A Social Studies: B iii. Math: A Science: C English: A PE: B Health: A Computers: C Social Studies: C iv. Math: A Science: A English: A PE: D Health: C Computers: B Social Studies: C 6. Use an IF Function to create the Grade Values. Use the NOTE: Grade Values to help you. You will need to use a NESTED IF statement. Condition: IF Current Grade = “A”, then 4.0, else IF Current Grade = “B”, then 3.0, else IF Current Grade = “C”, then 2.0, else IF Current Grade = “D”, then 1.0, else IF Current Grade = “F”, then 0.0, else 0.0 7. At cell B12, insert a formula that calculates the Total of all individual letter grade values found in the Grade Values Column. 8. In the MY GPA= cell, insert a formula that calculates the AVERAGE of all the individual Grade Values. a. Make the values to 2 decimal places 9. Under the cell that calculates MY GPA, Insert an IF Statement for the following condition: If a student's GPA is greater than or equal to a 3.50, then have the cell display HONOR ROLL! If the student's GPA is less than the 3.50, have the cell display, Keep Trying! (Use a Nested IF statement) 10. Format the table to your liking 11. Complete the document properties with your name, subject and tags (minimum of 3 separated by commas)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

HelloPFA the solution. Please add your name as studentName or please let me kno...


Anonymous
I use Studypool every time I need help studying, and it never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags