Go to Sheet1. In cell C11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. Use absolute references for the table array parameter (A4 to B8). Use FALSE for the range lookup parameter. Copy the formula in C11 to C12:C15 Notice this formula only works correctly in C11 and C15. That is because you used FALSE for the range lookup parameter. FALSE means search for an exact match. The only scores in C11:C15 that exactly match values in the table array are 80 and 90. In cell D11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. The table array parameter is the same as in C11. Do not type anything for the range lookup parameter. Copy the formula in D11 to D12:D15 Notice this formula works correctly for all cells. The default value for the range lookup parameter is TRUE. (You could have typed TRUE and it would work the same way, However, why type when you don't need to?) TRUE means search for an approximate match - the last value in the table array that is not larger than the lookup value. In cell B18 type a VLOOKUP function to find the corresponding letter grade (from column D) for the name in A18. Use absolute references for the table array parameter (A11 to D15). Do not type anything for the range lookup parameter. Copy the formula in B18 to B19:B22 Notice this formula only works correctly for B21. When searching for an approximate match (range lookup blank or TRUE) the table array MUST be sorted by its first column. A11:A15 is NOT sorted.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Go to Sheet1. In cell C11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. Use absolute references for the table array parameter (A4 to B8). Use FALSE for the range lookup parameter. Copy the formula in C11 to C12:C15

Notice this formula only works correctly in C11 and C15. That is because you used FALSE for the range lookup parameter. FALSE means search for an exact match. The only scores in C11:C15 that exactly match values in the table array are 80 and 90.

In cell D11 type a VLOOKUP function to find the corresponding letter grade for the score in B11. The table array parameter is the same as in C11. Do not type anything for the range lookup parameter. Copy the formula in D11 to D12:D15

Notice this formula works correctly for all cells. The default value for the range lookup parameter is TRUE. (You could have typed TRUE and it would work the same way, However, why type when you don't need to?) TRUE means search for an approximate match - the last value in the table array that is not larger than the lookup value.

In cell B18 type a VLOOKUP function to find the corresponding letter grade (from column D) for the name in A18. Use absolute references for the table array parameter (A11 to D15). Do not type anything for the range lookup parameter. Copy the formula in B18 to B19:B22

Notice this formula only works correctly for B21. When searching for an approximate match (range lookup blank or TRUE) the table array MUST be sorted by its first column. A11:A15 is NOT sorted.

In cell C18 type a VLOOKUP function to find the corresponding letter grade (from column D) for the name in A18. The table array parameter is the same as in B18. Type FALSE for the range lookup parameter. Copy the formula in C18 to C19:C22

Notice this formula works correctly for all cells. Range lookup of FALSE means do an exact match on the lookup value whether or not the table array is sorted by its first column.

In cell E11, type an IF function that compares the score in B11 with the minimum score to pass in A5. If the comparison value is true, display Pass. Otherwise, display Fail. Copy the formula in E11 to E12:E15.

In cell F11, type an IF function that compares the grade in D11 with the letter F (type F). If these two are not equal, display Pass. Otherwise, display Fail. Copy the formula in F11 to F12:F15

Go to Sheet2. In cell C7 type a PMT function to calculate the monthly payment for the loan amount in B7 and the rate and number of payments determined by B2 and B3. Notice you are to calculate a monthly payment but B2 and B3 are annual values. Place a minus sign between = and PMT to convert the payment to a positive number. Copy the formula in C7 to C8. 

In cell D7, multiply the monthly payment for the loan by the number of payments to get the total amount paid. Copy the formula to D8

In cell E7, subtract the amount financed from the total amount paid to compute the total interest for the loan. Copy the formula in E7 to E8

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Array
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education