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

See similar textbooks

Related questions

Concept explainers

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

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.