Online Access Free MO-211 Practice Test

Which features are available when protecting a workbook?
(Choose two)

• A.Preventing the renaming of worksheets
• B.Preventing the deletion of worksheets
• C.Hiding cells with data
• D.Restricting data entry to specific values

Arrange the steps to create a formula using nested IF functions.
1. Enter =IF in the formula bar
2. Specify the output for TRUE and FALSE results
3. Set the first logical test
4. Add the second logical test inside the first IF function

• A.3, 1, 2, 4
• B.1, 2, 3, 4
• C.1, 3, 2, 4
• D.2, 4, 1, 3

Which lookup functions can be used to find data horizontally and vertically in a table?
(Choose two)

• A.SUMIF()
• B.HLOOKUP()
• C.XLOOKUP()
• D.VLOOKUP()

What is the first step to copy a macro from one workbook to another?

• A.Open the VBA Editor
• B.Open the source workbook
• C.Open the destination workbook
• D.Enable macros in both workbooks

Data Validation can be used to create a dropdown list of valid inputs, which enhances ______.

• A.formatting
• B.speed
• C.complexity
• D.usability