BOM - Group 5

What year was Google Sheets released?

• 2014

• 2015

• 2016

• 2017

What programming language does Google Sheets use?

• JavaScript

• VBA

• Python

• Lisp

What is not a useful feature of google sheets ?

• Easily enter data and set the calculation program

• Active support for teamwork

• Have to click "save" to store data

• Multiple people can work on a Google Sheet at the same time

What formats are not compatible with Google sheets?

• HTML

• Excel

• PDF

• Word

What should you do if you want to use more than 1000 rows in google sheet?

• You need to go and add it manually.

• To automatically update more rows

• Can't add any more rows

Which of the following features of google sheets can't be done by excel?

• Offline Editing

• Able to view the version history

• Build charts

• Spreadsheet editing and formatting

Google sheets is connected to any of the following tools:

• Excel

• Google Drive

• Word

• Microsoft Office

To collect useful data that helps us extract tables and lists from web pages, we can use syntax:

• Translate

• Split

• Concatenate

• Importhhtml

Can you use google sheet when offline?

• YES

• NO

To translate on google sheets, which of the following syntax should be used?

• GOOGLETRANSLATE (text; [source_languege])

• GOOGLETRANSLATE (text; [target_language])

• GOOGLETRANSLATE (text; [source_languege]; [target_language])

• GOOGLETRANSLATE (text; [target_language];  [source_languege])