2016 - MSITA Excel Vocats Test

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?

• Export

• Protect workbook

• Share workbook

• Tracking Changes

Which ribbon option opens a related dialog box?

• Drop-down Arrow

• Ellipse

• Launcher

• Slider

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?

• Formula

• Function

• Label

• Value

John's workbooks includes 3 worksheets. Which option should he choose to print them?

• Fit to one page

• Print active sheet

• Print entire workbook

• Print Selection

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

• Calculation

• Defined Names

• Formula Auditing

• Function Library

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?

• Center

• Merge and Center

• Orientation

• Wrap Text

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

• Insert

• Move

• Rename

• Tab Color

Jessica needs to capitalize the first letter in each word. Which function would she use?

• Lower

• Proper

• Trim

• Upper

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

• Share Workbook

• Tracking Changes

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 she use?

• Delete

• Edit Comment

• New

• Show Ink