Question 1

What is the purpose of the command SpreadsheetApp?

Accepted Answer

Links the script with Google spreadsheets

Answer

To format text in a Google Document.

Answer

To send email notifications to a Google Calendar event.

Answer

To control the layout of a webpage in Google Sites.

Question 2

What is the purpose of the command getActiveSpreadsheet?

Accepted Answer

Retrieve the currently active spreadsheet in Google Sheets that is being worked on

Answer

To create a new Google Sheet from scratch.

Answer

To create a new Google Doc from scratch.

Answer

To send data from a spreadsheet to a Google Doc.

Question 3

The command getRange is for specifying the cells for the action

Accepted Answer

true

Answer

false

Question 4

Command getValue is for calculating the division in each cell

Accepted Answer

false

Answer

true

Question 5

To celect a sheet with a given name we use

Accepted Answer

getSheetByName

Question 6

Type the range from A1 to A13

Accepted Answer

A1:A13

Question 7

What command would you use to get an average?

Accepted Answer

getRange

Question 8

What is the command we use to add a new row to the sheets?

Accepted Answer

AppendingRow

Answer

AddingRows

Answer

goHome

Answer

SheetplusRow

Question 9

Which function is giving information about a book?

Accepted Answer

ss2.AppendRow([title, author, isbn, edition, language]);

Answer

ss2.AppendRow([name, age, grade, , studentID]);

Answer

ss2.AppendRow([title, director, genre, releaseYear, rating]);

Answer

ss2.AppendRow([address, bedrooms, bathrooms, price,]);

Question 10

What would be the items to include when creating a grocey store inventory?

Question 11

This code is correct: ss2.AppendRow(["title, director, genre, releaseYear"]){

Accepted Answer

false

Answer

true

Question 12

What is the purpose of data validation?

Accepted Answer

Ensure the integriyty and consistency of your data by restricting input inspecific cells

Answer

To create formulas that calculate totals and averages.

Answer

To change the color of cells based on their content

Answer

To automatically sort data in a spreadsheet.

Question 13

Name one main type of data validation in Google Sheets

Question 14

'Checkbox' is NOT one main type of data validation

Accepted Answer

false

Answer

true

Question 15

You can improve data quality and prevent mistakes by setting criteria

Accepted Answer

true

Answer

false

Question 16

How can you create a system in Google sheets?

Question 17

=QUERY(A1:B21, "SELECT * ORDER BY A ASC") is for...

Accepted Answer

Ordering a table alphabetically on ascending mode

Answer

Filtering out all empty rows and only displays non-empty values from columns A and B.

Answer

Deleting duplicates from columns A and B and then sorts them alphabetically

Answer

Selecting column B and sorts it in descending order.

Question 18

Name of the command we use to retrieve, filter, sort, and manipulate data

Accepted Answer

QUERY

Question 19

Select the code that mentions B and C from the range A1:C5. The results are then sorted in descending order

Accepted Answer

=QUERY(A1:C50, "SELECT B, C WHERE A > 100 ORDER BY C DESC")

Answer

Query(A1:C50, "SELECT B, C WHERE A > 100 ORDER BY C DESC")

Answer

=QUERY(A50:C1, "SELECT B, C WHERE A > 10 ORDER BY C DESC")

Answer

=query(A1:C50, "SELECT B, C WHERE A > 100 ORDER BY C ASC")

Question 20

What tool is being used in this image?

Accepted Answer

Data Validation

Answer

query

Answer

Inventory system

Answer

GetValueS

Related quizzes

Related quizzes