menu-iconExamlexExamLexServices

Discover

Ask a Question
  1. All Topics
  2. Topic
    Computing
  3. Study Set
    Your Office Microsoft Excel
  4. Exam
    Exam 3: Cell References, named Ranges, and Functions
  5. Question
    Using the Information in the Format Shown Below and Given
Solved

Using the Information in the Format Shown Below and Given

Question 28

Question 28

Multiple Choice

Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?
Using the information in the format shown below and given a student's numerical average,which Excel function would be used to determine the student's letter grade?   A) VLOOKUP B) HLOOKUP C) INDEX D) MATCH


A) VLOOKUP
B) HLOOKUP
C) INDEX
D) MATCH

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q24: There are how many different cell references?<br>A)2<br>B)3<br>C)4<br>D)5

Q26: You are likely to see the #NAME?

Q29: You create a named range by using

Q31: When cell C3 containing the formula =B4*C6

Q32: Excel's DAY function returns the day of

Q33: The inputs used by an Excel function

Q35: A(n)_ is a named calculation which Excel

Q42: A named range is a group of

Q61: The result of =ROUNDDOWN(98.765,0)is 98.

Q77: Excel's RANDBETWEEN function returns a random number

Examlex

ExamLex

About UsContact UsPerks CenterHomeschoolingTest Prep

Work With Us

Campus RepresentativeInfluencers

Links

FaqPricingChrome Extension

Download The App

Get App StoreGet Google Play

Policies

Privacy PolicyTerms of ServiceHonor CodeCommunity Guidelines

Scan To Download

qr-code

Copyright © (2025) ExamLex LLC.

Privacy PolicyTerms Of ServiceHonor CodeCommunity Guidelines