Free Printable Just Excel!

Worksheets

Just Excel!

Total questions: 10

Worksheet time: 4mins

Name

Class

Date

Lookup, Index, Match, Choose, Offset, Indirect are functions under Lookup & References family.

True

False

Don't Know

Maybe

Which of this is CORRECT about database formula?

=database(sum)

=Sum(database,field,criteria)

=DAverage(database,field,criteria)

None of the above

To combine between two text, we use ____________ or ________________

(a)

PROPER function converts string to

lower case

upper case

first letter of a word to lower and others to upper case

first letter of a word to upper and others to lower case

What function can be used to summarize pivot table data?

Count

Sum

Average

Len

Min

The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup

table array containing data

Price of the item being looked for

The LookUp function has 3 arguments. First ___________ then table array and finally, results column

Value to Look Up

Value to Calculate

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

SUMIF

AVERAGEIF

TOTALIF

COUNTIF

What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?

Count

CountA

Fill Series

10.

The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred?

=IF(D7<40),1.5*E7

=IF(D7>40,D7-40)

=MAX(D1:D7)*1.5

=OVERTIME(D7*E7)

Reset

Just Excel!

Total questions: 10

Worksheet time: 4mins

Similar Resources on Wayground