최신 MO-211 무료덤프 - Microsoft Excel Expert - Microsoft 365 Apps
Which chart type is best for visualizing the distribution of a dataset?
정답: A
Which option should you use to prevent other users from adding or deleting sheets in a shared workbook?
정답: A
If you want to highlight cells that are not equal to 20 using conditional formatting, which formula would you use?
정답: B
What does protecting worksheet and cell ranges NOT prevent?
정답: B
You need to restrict users from adding or deleting worksheets but allow them to edit cell contents. What should you do?
정답: A
To calculate the number of payment periods for a loan based on a constant payment and interest rate, use the ____ function.
정답: C
The formula =RANDARRAY(5) generates ______ of random numbers.
정답: A
What is the best use of the LET() function in Excel formulas?
정답: D
Which Excel feature allows you to drill down into the details of a PivotChart?
정답: B
For which scenario is the LET() function most useful?
정답: A