Excel Quiz

What feature in Excel allows you to encrypt a workbook?

• Protect Sheet

• Track Changes

• Encrypt with Password

• Data Validation

Answer explanation

The feature 'Encrypt with Password' in Excel allows you to secure a workbook by requiring a password to open it. This is essential for protecting sensitive information, unlike the other options which serve different purposes.

Which Excel formula can be used to mask part of an email address?

• =REPLACE(A1, 1, LEN(A1), "*")

• =LEFT(A1,1) & REPT("*",LEN(A1)-5) & RIGHT(A1,3)

• =MID(A1, 2, LEN(A1))

• =SUBSTITUTE(A1,"@","****")

Answer explanation

The formula =LEFT(A1,1) & REPT("*",LEN(A1)-5) & RIGHT(A1,3) keeps the first character and the last three characters of the email, masking the rest with asterisks, effectively hiding most of the email address.

How can you generate unique IDs in Excel without duplicates?

• Use the RAND() function

• Use the RANDBETWEEN() function

• Use Power Query to generate GUIDs

• Manually type unique values

Answer explanation

Using Power Query to generate GUIDs is the most effective way to create unique IDs in Excel without duplicates, as GUIDs are designed to be globally unique. Other methods may lead to duplicates.

What does the 'Track Changes' feature in Excel help you monitor?

• Passwords

• Edits made to the workbook

• Data encryption

• User permissions

Answer explanation

The 'Track Changes' feature in Excel allows users to monitor edits made to the workbook, making it easier to review modifications and collaborate effectively. This is essential for maintaining version control.

Which of the following is a best practice for securing Excel workbooks?

• Sharing passwords via email

• Storing backups without encryption

• Changing passwords regularly

• Allowing unrestricted user access

Answer explanation

Changing passwords regularly is a best practice for securing Excel workbooks as it helps protect sensitive data from unauthorized access. The other options, like sharing passwords or allowing unrestricted access, compromise security.

What Excel feature allows you to restrict data entry to specific formats?

• Data Validation

• Protect Workbook

• Track Changes

• Conditional Formatting

Answer explanation

Data Validation is the Excel feature that allows you to restrict data entry to specific formats, ensuring that users input data in a consistent and valid manner.

Which function in Excel can be used to remove spaces from a text string?

• =SUBSTITUTE(A1, " ", "")

• =TRIM(A1)

• =CONCATENATE(A1)

• =CLEAN(A1)

Answer explanation

The =TRIM(A1) function in Excel is specifically designed to remove extra spaces from a text string, leaving only single spaces between words. The other options do not serve this purpose effectively.

How can you protect a specific worksheet in Excel from being edited?

• Track Changes

• Data Validation

• Protect Sheet

• Encrypt with Password

Answer explanation

To protect a specific worksheet in Excel from being edited, you should use the 'Protect Sheet' option. This feature allows you to restrict editing and set permissions for users, ensuring the integrity of your data.