Working with Google Sheets
68 min4 lessons8 quiz questions
Lessons
Practice file
Practice file coming soon.Module quiz (8)
1. getRange(3, 2, 5, 2) selects… a) C2:D6 b) B3:C7 c) B3:F4
B3:C7
2. What does getValues() return for A1:A3? a) ['a','b','c'] b) [['a'],['b'],['c']] c) 'a,b,c'
[['a'],['b'],['c']]
3. For 1,000 rows, how many sheet calls does the fast pattern need? a) 1,000 b) 2,000 c) About 2
About 2
4. What can go wrong when you setValues over a whole range? a) Nothing b) Formulas get replaced by values c) The sheet is deleted
Formulas get replaced by values
5. What does a custom function receive when you pass A2:A5? a) A string b) A 2D array c) Only A2
A 2D array
6. Which of these can a custom function do? a) Send an email b) Colour another cell c) Return a calculated value
Return a calculated value
7. Which function runs automatically when the spreadsheet opens? a) doGet b) onOpen c) main
onOpen
8. How does a sidebar's HTML call a server-side function? a) fetch() b) google.script.run c) SpreadsheetApp.call
google.script.run