Count Cells Function 6
Get Sheet Names Function 6
Count Rows in Sheet 7
Get values from Columns 7
Get Column Values by Letter 8
Sending Email Reminders 9
Send Google Form Confirmations 10
Generate Unique ID values 11
Deleting Specific Rows 11
Sort Sheet Data 12
How to send a reminder email 13
Add to Sheet new email data 14
How to create a PDF from Sheet 15
Add new Calendar event 15
How to create a new doc 16
Adding a UI menu option 18
How to create a new sheet 18
Sending Custom emails from data 19
Add image button to Doc 20
Creating calendar events and trigger 20
Imports data from CSV file 22
Create a New Form 23
Create a PDF from Doc 23
Send customized Emails 24
What is the output of the following code snippet? 27
What is the output of the following code snippet? 28
What does the following code snippet do? 28
What is the output of the following code snippet? 29
What is the output of the following code snippet? 30
What does the following code snippet do? 30
What is the output of the following code snippet? 31
What is the correct way to create a new sheet in Google Sheets using Google Apps Script? 31
What does the following code snippet do? 32
Which method is used to read the value of a cell in Google Sheets? 34
Which object is used to create a new file in Google Drive? 34
Which method is used to send an email in Google Apps Script? 35
Which method is used to get the current date and time in Google Apps Script? 35
Which method is used to add a new row to a Google Sheets spreadsheet? 36
Which method is used to get the value of a URL parameter in Google Apps Script? 36
Which method is used to get the current user’s email address in Google Apps Script? 36
Which method is used to create a new calendar event in Google Apps Script? 37
Which object is used to access the user’s Google Contacts in Google Apps Script? 37
Which method is used to get the value of a checkbox in a Google Sheets cell? 38
Which of the following is a data type in Google Apps Script? 39
Which method is used to create a new sheet in a Google Sheets document using Apps Script? 40
Which operator is used to concatenate strings in Apps Script? 40
Which method is used to retrieve the value of a cell in Google Sheets using Apps Script? 41
Which method is used to delete a row in a Google Sheets document using Apps Script? 41
Which method is used to create a new file in Google Drive using Apps Script? 41
Which method is used to send an email using Apps Script? 42
Which method is used to get the current date and time in Apps Script? 42
Which method is used to get the user’s email address in Apps Script? 43
Which method is used to create a menu in a Google Sheets document using Apps Script? 43
Question 1: Which of the following is not a data type in Google Apps Script? 45
Question 2: What is the output of the following code? 45
Question 3: What is the correct syntax for defining a function in Google Apps Script? 46
Question 4: Which of the following is not a valid loop structure in Google Apps Script? 46
Question 5: What is the output of the following code? 47
Question 6: Which of the following methods can be used to convert a string to a number in Google Apps Script? 47
Question 7: What is the output of the following code? 48
Question 8: Which of the following is not a valid comparison operator in Google Apps Script? 49
Question 9: What is the output of the following code? 49
Question 10: Which of the following is not a valid way to declare an array in Google Apps Script? 50
Which of the following is not a data type in Google Sheets? 51
What function can be used to count the number of cells in a range that meet a specific condition? 52
What is the syntax for a FOR loop in Apps Script? 53
Which of the following methods can be used to add a new sheet to a Google Sheets spreadsheet? 53
Which of the following methods can be used to get the value of a cell in a Google Sheets spreadsheet? 54
What does the following code do? var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Sheet1”); 55
What is Apps Script? 57
Which of the following is not a trigger type in Apps Script? 57
Which method can be used to create a new menu in a Google Sheets spreadsheet? 58
What does the following code do? var sheet = SpreadsheetApp.getActiveSheet(); 58
Which method can be used to insert a row into a Google Sheets spreadsheet? 59
What function can be used to concatenate two strings in Apps Script? 59
Which method can be used to copy a range of cells in a Google Sheets spreadsheet? 60
Send Email using Gmail API 61
Get Data from Google Sheets 62
Data From Sheets as Email Table 63
Add a Custom Menu to Google Sheets 65
Create a Google Calendar Event 66
Access the Google Drive API 67
Folder files listed to Sheet and creating new files into a folder 68
dataFolder() function 70
newFiles() function 70
newFiles2() function 70
Sending Emails From Google Sheets: 71
Sheet Data Custom Emails 72
Creating Google Calendar Events: 75
Accessing and Modifying Google Sheets: 75
Update Sheet Access Sheet Data with Apps Script 76
Accessing and Modifying Google Docs: 78
Update Styling of element with specific text in the contents 79
Creating Google Forms: 82
Create and view form with code 84
Creating and Updating Google Slides: 86
Accessing and Modifying Google Forms: 87
Select and update the form choices 88
Using Google Sheets as a Database: 90
Sheet Data as JSON output in WebApp 91
Sending Emails With Attachments: 94
File as an attachment in email 95
Creating and Modifying Google Calendar Events: 96