Deck 109: Spreadsheets Part 2

Question 1

Google Drawings allows you to create free-hand drawings including custom shapes and labels,and insert them into a spreadsheet.

Answer 1

True

Question 2

On the Revision history toolbar,you want to work with an older version of a shared spreadsheet.Click ____ to accomplish your goal.

A) Use this version
B) Select this revision
C) Open this version
D) Restore this revision

Answer 2

D

Question 3

Clicking "Newer" in the Revision history toolbar moves you back in time to a previous view of the spreadsheet.

Answer 3

False

Question 4

Google gadgets can be created by Google employees and those who purchase the software to do so.

Question 5

You clicked the Revision history toolbar to move to a prior version of the spreadsheet.Changes to the spreadsheet are highlighted in ____.

A) brown
B) the cell by pointing to a red triangle in the cell's upper-left corner
C) yellow
D) green

Question 6

A spreadsheet form can only be accessed and completed via a Web browser.

Question 7

To review changes made to a Google Docs spreadsheet,click ____ to get started.

A) File->See revision history
B) Edit->History
C) Format->History
D) Tools->View revision history

Question 8

A spreadsheet form can be formatted with a theme.

Question 9

When creating a spreadsheet form,you cannot use multiple-choice questions.

Question 10

Gadgets inserted into a spreadsheet can ____.

A) allow access to your personal computer
B) help you present spreadsheet data as a slide show
C) automate the process of logging in to Google Docs
D) interact with data from the Web

Question 11

Every time a spreadsheet autosaves,the copy is archived to its revision history.

Question 12

Gadgets inserted into a spreadsheet cannot be resized.

Question 13

A Google Docs gadget interacts with a spreadsheet in a way similar to how a chart does.

Question 14

When a new menu item appears in the toolbar after installing a script,this indicates that the script installed properly.

Question 15

Adding a Table gadget allows you to filter data,similar to Microsoft Excel's functionality.

Question 16

Google ____ is an application that allows you to add circles and other shapes to a spreadsheet.

A) Shapes
B) Images
C) Drawings
D) Gadgets

Question 17

To use a Google Apps Script,you need to create your own code.

Question 18

The Share menu is used to publish your spreadsheet to YouTube.

Question 19

Google Spreadsheets works together with Google Forms to create Web forms.

Question 20

The Script Manager provides you with the ability to create a new script for personal use.

Question 21

How are you made aware by Google Docs that another user is viewing a spreadsheet you have open in your browser?

A) A popup displays the other person's user name.
B) The spreadsheet's URL turns red.
C) The cell changes color as the other user types.
D) none of the above

Question 22

When creating a spreadsheet form,questions can be ____.

A) required
B) optional
C) multiple choice
D) all of the above

Question 23

When you use a form in Google Spreadsheets,____ and the collected data is stored in your spreadsheet.

A) you provide your own server
B) the spreadsheet is on your server
C) Google Docs is your server
D) there is no server

Question 24

Google Apps ____ can help you automate repetitive tasks.

A) Drawings
B) Script
C) AutoTask
D) VB.Net

Question 25

You need users to enter data in a form so you can use the data in Google Docs.You should use Google ____ to create the form.

A) Drawings
B) Forms
C) Scripts Manager
D) Java

Question 26

To run a script,you need to authorize it.What does this indicate?

A) You know the person who created the script and have paid to use it.
B) You are solely responsible for what the script might do to your spreadsheet.
C) Your e-mail address will be sent to the script's creator.
D) both A and B

Question 27

When you create a spreadsheet form,form questions are used to ____.

A) create row names
B) create an e-mail question form
C) assist in selecting a form layout
D) create column headings

Question 28

When you collaborate with others on a common spreadsheet,this means that ____.

A) only one person can edit the spreadsheet at any given moment
B) anyone can work on the spreadsheet at any time
C) only the spreadsheet creator can make changes on behalf of the whole team
D) either A or C

Question 29

To utilize a script from the Script Gallery,you need to ____.

A) install the script
B) purchase it
C) first purchase Google Docs Spreadsheets
D) both A and B