Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
V Lookup
100
Tom wants to convert all text to lowercase. Which function should he use?
Lower
100
James wants his spreadsheet to return true when the logical value is false. What function should he use?
NOT
100
What command limits structural changes, such as adding, deleting, or moving sheets that can be made in a workbook?
Protect Workbook
100
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?
RAND BETWEEN
200
James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
Find
200
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
H Lookup
200
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?
AVGIFS
200
All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet?
Change History
200
Lilly is making changes to a spreadsheet for FBLA advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the commands group should she use?
NEW
300
In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?
Convert Text to Column Wizard
300
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
Upper
300
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 she use?
COUNTIF
300
Lilly is making changes to a spreadsheet her FBLA advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?
Edit Comment
300
Where is the spellchecker located?
Ribbon
400
IF, AND, OR and NOT are all part of which category of functions?
Logical
400
SUMIF and SUMIFS are in which category of functions?
Math and Trig
400
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
Substitute
400
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?
Tracking Changes
400
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
500
Jessica needs to capitalize the first letter in each word. Which function would she use?
Proper
500
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?
SUMIF
500
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?
AND
500
Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?