1.
How do you create a drop-down list in Excel?
2.
What is the purpose of the Data Validation feature?
3.
How can ChatGPT assist in creating dynamic dashboards in Excel?
4.
What does the "Clean Up" tool in Outlook do?
5.
Which function checks if a condition is met and returns a value?
6.
How do you remove duplicate rows in Excel?
7.
Which function is used to return the current date and time?
8.
Which function is used to find the largest value in a dataset?
9.
How can ChatGPT assist in creating Excel formulas?
10.
What is the default file format for responses collected through Google Forms?
11.
What does the IFERROR function do?
12.
How do you apply conditional formatting in Google Sheets?
13.
Which option allows you to customize the look of a Google Form?
14.
Which function finds the first match in a dataset?
15.
What is the purpose of the Solver tool in Excel?
16.
Which shortcut key is used to open the "Go To" dialog box?
17.
What does the CONCATENATE function do?
18.
How can you share a Google Form with others?
19.
How can ChatGPT help with Excel automation?
20.
Which of the following formulas will give you the average value from a range of cells that meet specific criteria?
21.
Which Excel feature is used to summarize data dynamically?
22.
Which chart type is best for showing trends over time?
23.
How can ChatGPT help with data analysis in Excel?
24.
How do you protect a worksheet with a password?
25.
Which shortcut is used to open the "Find and Replace" dialog box?
26.
Which symbol is used to anchor a cell reference?
27.
What is the maximum number of rows in an Excel worksheet? (Excel 2016 and later)
28.
What does the VLOOKUP function do in Excel?
29.
What is the shortcut to freeze the first row in Google Sheets?
30.
Which of the following can you NOT do in Google Forms?
31.
Which function converts rows into columns?
32.
What is the maximum attachment size for sending an email in Outlook (by default)?
33.
What is the maximum number of columns a Google Sheet can have?
34.
Which formula extracts the year from a date?
35.
Which formula is used to calculate the total number of cells containing numbers in a range?
36.
Which function is used to calculate monthly loan payments?
37.
What does the POWER function do?
38.
Which of the following is NOT a valid Excel data type?
39.
How can you freeze rows and columns in Excel?
40.
Which of the following can you NOT create in Outlook?
