Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
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?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
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?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
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?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
Where is the spellchecker located?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
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?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
Upper
COUNTIF
Edit Comment
Protect Workbook
Share Workbook
Convert Text to Column Wizard
Review Ribbon
SUBSTITUTE
Check it!