2016 - MSITA Excel - Lesson 11 Vocats Test

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature of Excel allows others to view who made changes to the spreadsheet, when the changes were made, and what was changed?

• Track Changes

• Change History

• History

• Names Manager

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?

• Protect Workbook

• Protect Sheet

• Share

• Protection

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?

• New

• Delete

• Edit Comment

• Show Ink

The FBLA Advisor at Hilltop High School would like to create random ID numbers for FBLA members. Which function would be used to have Excel pick a random number between 1,000 and 5,000 for the new member ID numbers.

• RAND ( )

• RAND BETWEEN (1000, 5000)

• BETWEEN (1000, 5000)

• RANDOM (1000, 5000)

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?

• Share Workbook

• Protect Workbook

• Tracking Changes

• Export

Where is the spell checker feature located in Microsoft Excel?

• Home Ribbon

• Page Layout Ribbon

• Review Ribbon

• View Ribbon

Lilly is making changes to a spreadsheet her FBLA Advisor created . She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should be used?

• New

• Delete

• Edit Comment

• Show Ink

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

• Export

• Protect Workbook

• Tracking Changes

• Share Workbook

Which ribbon contains commands to addd a comment about a selected cell in a worksheet?

• Home

• Insert

• Data

• Review