Please take into account the following points before starting
There will be several questions with increasing difficulty.
There is only one correct answer for each question.
You only have a few minutes to complete the test.
You can skip questions and answer them later.
Unanswered questions will count as errors.
Which function would you use to calculate the standard deviation of a dataset?
STDEV
AVERAGE
COUNT
1/10
What is the purpose of a pivot table?
Data analysis
Formatting
Chart creation
2/10
How do you create a named range?
Formulas tab
Define Name
Data Validation
3/10
What does the VLOOKUP function do?
Vertical lookup
Horizontal lookup
Conditional formatting
4/10
How do you create a macro?
Developer tab
Record Macro
Visual Basic Editor
5/10
What is the purpose of Power Query?
Data cleaning
Charting
Pivot tables
6/10
Which function would you use to count the number of cells that meet specific criteria?
COUNTIF
SUMIF
AVERAGEIF
7/10
How do you protect a worksheet?
Review tab
Protect Sheet
Format Cells
8/10
What is the purpose of conditional formatting?
Highlighting cells
Data validation
Sorting
9/10
How do you create a slicer?
Insert tab
Slicer
Table Tools
10/10
Are you sure you want to finish the test?"
Close
Confirm
