Office Scripts Quiz

What is the new feature released by the office scripts team?

• Ability to play music

• Ability to print documents

• Ability to run scripts with parameters

• Ability to create animations

What example is used to illustrate creating reusable scripts?

• Unprotecting worksheets

• Sorting data

• Creating charts

• Formatting text

What method is used to unprotect a single worksheet?

• Unlock Sheet

• Secure Sheet

• Unprotect Sheet

• Protect Sheet

What statement is used to handle errors in the script?

• If-Else statement

• Try-Catch statement

• For Loop

• Switch statement

What is the purpose of making the password parameter optional?

• To increase security

• To allow flexibility

• To restrict access

• To confuse users

Where can the shared scripts be saved to make them available to the entire team?

• OneDrive

• SharePoint

• Google Drive

• Dropbox

What happens when a script is associated with a workbook?

• It can be executed from the workbook

• It runs automatically

• It gets deleted

• It becomes read-only

What functionality allows passing parameters into the function declaration?

• New Feature

• Optional Parameters

• Shared Scripts

• Try-Catch Statement

What is the purpose of the 'add without button' option?

• To associate the script with the workbook

• To avoid cluttering the worksheet

• To run the script automatically

• To hide the script

How can reusable scripts be made more flexible?

• By passing parameters

• By saving on OneDrive

• By removing parameters

• By adding more errors