This textbook is available Logo
New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive 1st Edition

New Perspectives Microsoft Office 365 & Excel 2019 Comprehensive (1st Edition)

Book Edition1st Edition
Author(s)Carey, Parsons
SubjectComputer Science
Section 7.1: Session 7.1 Visual Overview: Summary IF Functions and VLOOKUP
Section 7.2: Session 7.2 Visual Overview: PivotTables
Section 7.3: Session 7.3 Visual Overview: PivotCharts and Slicers
Chapter 7, Section 7.1, Quick Check , Exercise 1
Page EX 7-25

A school gives out grades in the following ranges: F: 0 - < 60; D: 60 - < 70; C: 70 - < 80; B: 80 - < 90; A: 90 - 100. Create a vertical lookup table for this grade scale with the range values in the first column and the letter grades in the second.


A lookup table, otherwise called LUT, is a cluster utilized in PC programming that holds esteems which would some way or another should be determined. The table might be physically populated when the program is composed, or the program may populate the table with values as it computes them.

Verified Answer

Steps to create the lookup table for the problem :

  • Go to Office365 and create an account there.
  • After setting up the whole thing, open Excel
  • Go to one cell and give the name as Grade Scale
  • Go to its subsequent scale and give the name as Letter Grades
  • Accordingly give the inputs for the grade scale column
  • Do the same thing for Letter Grades column
How would you rate this answer and explanation?
Did you like this example?
Subscribe for full access
Page EX 7-25