Question No : 1
Which of these is NOT a type of data validation in Excel?
정답:
Question No : 2
Which function is best suited for retrieving a value in a table based on a row and column position?
정답:
Question No : 3
Which of the following statements best describes the use of calculated fields in PivotTables?
정답:
Question No : 4
When might you need to enable macros in a workbook that you received via email?
정답:
Question No : 5
______ is used to dynamically filter rows in Excel based on a set of criteria.
정답:
Question No : 6
Managing multiple conditional formatting rules is done in the ______ dialog box.
정답:
Question No : 7
Which function would you use to perform a lookup for data that matches multiple criteria?
정답:
Question No : 8
You need to protect certain worksheets and cell ranges in your workbook.
Which option would you use to achieve this?
정답:
Question No : 9
Which functions can be used to fill cells based on patterns or sequences in Excel? (Choose two)
정답:
Question No : 10
What is the main advantage of using a Box & Whisker chart in data analysis?
정답:
Question No : 11
Which actions can you perform using advanced Conditional Formatting rules? (Choose two)
정답:
Question No : 12
Which option allows you to restrict editing in certain parts of a workbook?
정답:
Question No : 13
Enter the format code: 0.00%
정답:
Question No : 14
Which of the following charts are useful for comparing multiple variables in a dataset? (Choose Two)
정답:
Question No : 15
Format the chart as needed
정답:
