Unit4

What type of error occurs when there is a mistake in the structure or syntax of your VBA code?

• Runtime Error

• Logic Error

• Compile-Time Error

• None of the above

When you attempt to divide a number by zero in VBA, which type of error is raised?

• Object Not Found Error

• Null Reference Error

• Type Mismatch Error

• Division by Zero Error

Which Excel VBA statement turns off error handling and allows errors to be raised as usual?

• On Error Resume Next

• On Error GoTo Label

• On Error GoTo 0

• On Error GoTo ErrorHandler

What is the purpose of the "Err" object in Excel VBA?

• To raise custom errors

• To store the last error number that occurred.

• To define error-handling labels.

• To turn off error handling.

What does real-time collaboration in Google Sheets mean?

• Editing Google Sheets one after another

• Collaborating with people around the world simultaneously

• Editing spreadsheets at different times of the day

• Editing spreadsheets with a delay of 24 hours

Which file formats can be exported from Google Sheets?

• PDF

• CSV

• Excel

• HTML

In terms of accessibility, which statement is true?

• Excel is only accessible offline

• Google Sheets is only accessible offline

• Both Excel and Google Sheets are accessible online

• Both Excel and Google Sheets are only accessible through mobile apps.

Which statement is true regarding cost and licensing?

• Excel is free to use.

• Google Sheets requires a one-time purchase.

• Google Sheets is free to use.

• Both Excel and Google Sheets have the same pricing model.

What Does It Mean If Someone Has "Edit" Permissions?

• They Can Only View The Document

• They Can Make Changes To The Document

• They Can Share The Document With Others

• They Can Only Print The Document

What is the primary purpose of custom errors in VBA Excel?

• To prevent compile-time errors

• To generate runtime errors

• To handle specific situations gracefully and provide meaningful error messages

• To hide all errors from the user