Excel 1.10-1.11 (Part 2) Question Preview (ID: 41451)


Part 2. TEACHERS: click here for quick copy question ID numbers.

James wants his spreadsheet to return true when the logical value is false. What function should he use?
a) OR
b) IF
c) NOT
d) OR

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
a) SEARCH
b) VLOOKUP
c) LOOKUP
d) HLOOKUP

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?
a) NOT
b) IF
c) OR
d) AND

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
a) Tracking Changes
b) Share Workbook
c) Protect Workbook
d) Export

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?
a) TOTALIF
b) SUMIF
c) COUNTIF
d) AVERAGEIF

Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
a) HLOOKUP
b) SEARCH
c) LOOKUP
d) VLOOKUP

Jessica needs to capitalize the first letter in each word. Which function would she use?
a) Trim
b) Proper
c) Upper
d) Lower

Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?
a) TOTALIFS
b) AVERAGEIFS
c) COUNTIFS
d) SUMIFS

The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers?
a) RANDOM(1000,5000)
b) BETWEEN(1000,5000)
c) RAND()
d) RAND BETWEEN(1000,5000)

Tom wants to convert all text to lowercase. Which function she he use?
a) Trim
b) Proper
c) Upper
d) Lower

Which ribbon contains commands to add a comment about a selected cell in a worksheet?
a) Data
b) Home
c) Insert
d) Review

SUMIF and SUMIFS are in which category of functions?
a) Text
b) Logical
c) Lookup Reference
d) Math Trig

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 41451 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links