Google Apps Script & Spreadsheet Automation
QUESTION PAPER Google Apps Script & Spreadsheet Automation Time: 2 Hours Maximum Marks: 80 Instructions: All questions are compulsory. Read each question carefully before answering. Write neat and clean answers. _______________________________________________ SECTION A: MULTIPLE CHOICE QUESTIONS (10 × 1 = 10 Marks) 1. Which object is used to access the active spreadsheet in Google Apps Script? a) Sheet.getActiveSpreadsheet() b) SpreadsheetApp.getActiveSpreadsheet() c) Google.getActiveSpreadsheet() d) Apps.getActiveSpreadsheet() 2. The getSheetByName() method returns: a) Sheet object if found, null if not found b) Always returns a sheet object c) Returns ...