最新的Microsoft Excel Expert - Microsoft 365 Apps - MO-211免費考試真題
Which function allows you to calculate the number of workdays between two dates?
正確答案: A
What symbol is used in custom number formats to represent currency?
正確答案: D
If you want to highlight cells that are not equal to 20 using conditional formatting, which formula would you use?
正確答案: D
How can you quickly calculate the total for a column of numbers?
正確答案: D
What action does protecting the workbook structure restrict?
Changing cell formats
Adding or deleting worksheets
Changing cell formats
Adding or deleting worksheets
正確答案: C
When might you need to enable macros in a workbook that you received via email?
正確答案: B
Which of these is NOT a type of data validation in Excel?
正確答案: C
How can you make a cell turn green if the value is greater than 100 using conditional formatting?
正確答案: C
Which function should you use to ensure that a date falls on a weekday, not a weekend, when performing date arithmetic?
正確答案: D
Which formulas can be used to look up data in Excel?
(Choose two)
(Choose two)
正確答案: B,C
Which advanced chart types can you create in Excel?
(Choose two)
(Choose two)
正確答案: C,D