Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
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?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
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?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
IF, AND, OR and NOT are all part of which category of functions?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
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?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
Where is the spellchecker located?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
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?
Protect Workbook
Upper
Logical
Share Workbook
Review Ribbon
COUNTIF
Convert Text to Column Wizard
Edit Comment
Check it!