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