MS Excel - Day 05

The four arguments used in the VLookUp function are: Name of Item, _______, column index number, look for approximate match.

• Range containing data

• Price of the item being looked for

• Vertical or horizontal search

• None of the mentioned

When using HLookUp, use _______ if you want to look for approximate matches rather than an exact match.

• TRUE

• FALSE

Which function is used to find the lowest grade?

• Average

• Sum

• Min

• Max

The function COUNT is specific for _______.

• Counting cells

• Counting numbers

• Counting text

• Counting tables

Which function returns the largest value amongst all values within the range H2:H30?

• MAX(H2:H30)

• MAXIMUM(H2:H30)

• LARGE(H2:H30,29)

• UPPER(H2:H30,1)

Which formula correctly counts the number of blank in both B4:E4 and G4:I4?

• COUNTBLANK(B4:E4&G4:I4)

• COUNT(B4:E4,G4:I4)

• COUNT(B4:E4 G4:I4)

• COUNTBLANK(B4:I4)

To discover how many cells in a range contain values that meet a single criterion, use the _ function.

• Count

• SUMIFS

• COUNTIF

• COUNTIFS

Which function returns the leftmost five characters in cell A1?

• FIND(A1,1,5)

• SEARCH(A1,5)

• LEFT(A1,5)

• A1-RIGHT(A1,LEN(A1)-5)

What does data validation allow you to do?

• check the accuracy of your unique Excel worksheet functions

• restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.)

• lock cells to prevent others from editing them

• All the mentioned

Which function returns the number of characters in a text string in cell A1?

• RIGHT(A1)-LEFT(A1)+1

• LEN(A1)

• EXACT(A1)

• CHARS(A1)