Google Apps Script Quiz 3

Google Apps Script Quiz 3

Which of the following is a data type in Google Apps Script?
Which method is used to create a new sheet in a Google Sheets document using Apps Script?
Which operator is used to concatenate strings in Apps Script?
Which method is used to retrieve the value of a cell in Google Sheets using Apps Script?
Which method is used to delete a row in a Google Sheets document using Apps Script?
Which method is used to create a new file in Google Drive using Apps Script?
Which method is used to send an email using Apps Script?
Which method is used to get the current date and time in Apps Script?
Which method is used to get the user’s email address in Apps Script?
Which method is used to create a menu in a Google Sheets document using Apps Script?

Test your knowledge Google Apps Script – Free QUIZ

#GoogleAppsScript #GAS #automation #scripting #GoogleSheets #GoogleDocs #GoogleForms #add-ons #customfunctions #spreadsheetautomation #documentautomation #formautomation #appscript #productivitytools #coding #programming #google #workspace #gsuite

Which of the following is a data type in Google Apps Script?

a) Integer

b) String

c) Boolean

d) All of the above

Solution: d) All of the above

Which method is used to create a new sheet in a Google Sheets document using Apps Script?

a) createSheet()

b) addSheet()

c) newSheet()

d) sheetCreate()

Solution: b) addSheet()

Which operator is used to concatenate strings in Apps Script?

a) +

b) *

c) /

d) –

Solution: a) +

Which method is used to retrieve the value of a cell in Google Sheets using Apps Script?

a) getCellValue()

b) getCell()

c) getValue()

d) retrieveCellValue()

Solution: c) getValue()

Which method is used to delete a row in a Google Sheets document using Apps Script?

a) deleteRow()

b) removeRow()

c) eraseRow()

d) eliminateRow()

Solution: a) deleteRow()

Which method is used to create a new file in Google Drive using Apps Script?

a) createFile()

b) newFile()

c) addFile()

d) makeFile()

Solution: a) createFile()

Which method is used to send an email using Apps Script?

a) sendEmail()

b) emailSend()

c) mailSend()

d) send()

Solution: a) sendEmail()

Which method is used to get the current date and time in Apps Script?

a) getCurrentTime()

b) getCurrentDate()

c) new Date()

d) getDateAndTime()

Solution: c) new Date()

Which method is used to get the user’s email address in Apps Script?

a) getUserEmail()

b) getEmail()

c) getCurrentUserEmail()

d) Session.getActiveUser().getEmail()

Solution: d) Session.getActiveUser().getEmail()

Which method is used to create a menu in a Google Sheets document using Apps Script?

a) createMenu()

b) addMenu()

c) newMenu()

d) insertMenu()

Solution: b) addMenu()