Microsoft Excel Expert Exam with
correct answers 100% 2026
Create a formula that will return TRUE if a value in cell B5 is between 90 and 100 - Correct
Answers AND(B5>=90,B5<=100)
- AND Function requires all arguments to be true in order for it to return a TRUE value
What formula would you use in order to get a TRUE value if cell C3 is greater than 14 or equal to
3 - Correct Answers OR(C3>14,C3=3)
The OR function requires one of its arguments to be true in order for it to return a TRUE value
Where are macros stored ? - Correct Answers Modules
What sign do references to cells in other workbooks start with? - Correct Answers Equal Sign
Where are the macro settings located? - Correct Answers Trust Center Settings
What is the first step in protecting a worksheet? - Correct Answers Unlock the cells that should
be editable
Through the _____ drop-down button on the formulas tab, one can set workbook formulas to
calculate manually or automatically - Correct Answers Calculation Options
Which tab is the Protect Workbook button under? - Correct Answers Review
Where is the option to set or remove a password to protect an entire workbook located ? -
Correct Answers File tab and through protect workbook drop-down button
correct answers 100% 2026
Create a formula that will return TRUE if a value in cell B5 is between 90 and 100 - Correct
Answers AND(B5>=90,B5<=100)
- AND Function requires all arguments to be true in order for it to return a TRUE value
What formula would you use in order to get a TRUE value if cell C3 is greater than 14 or equal to
3 - Correct Answers OR(C3>14,C3=3)
The OR function requires one of its arguments to be true in order for it to return a TRUE value
Where are macros stored ? - Correct Answers Modules
What sign do references to cells in other workbooks start with? - Correct Answers Equal Sign
Where are the macro settings located? - Correct Answers Trust Center Settings
What is the first step in protecting a worksheet? - Correct Answers Unlock the cells that should
be editable
Through the _____ drop-down button on the formulas tab, one can set workbook formulas to
calculate manually or automatically - Correct Answers Calculation Options
Which tab is the Protect Workbook button under? - Correct Answers Review
Where is the option to set or remove a password to protect an entire workbook located ? -
Correct Answers File tab and through protect workbook drop-down button
