Google for Education Docs & Drive

When using OCR in Google Docs, only the first ______ pages of the PDF are scanned when searching for text to extract.

10 pages

When uploading an image for your computer into Drawings, what is the maximum file size?

2Mb

In the docs lists, type ___ when you're not in the search bar. and a window appear showing all available shortcuts.

?

Google Sheets can be exported to the following formats: a. .xls b. .rtf c. .csv d. A and B e. A and C

A and C

Which of the following is not saved in a document? A. Edits B. chats C. comments D none of the above

B. chats

You can send an email to the collaborators on a a document by going to: A. tools>preferences B. File> email as attachment C. File >email collaborators D, Publish >email collaborators

C. File >email collaborators

You can currently modify the layout of your form through a number of methods, except for the following.

Creating your own theme

There are three ways to use text in Google Drawings. Which of the following is not one of those ways? A. add text within shapes B. add word art C. insert text boxes D. add text using speech to text

D. Add text using speech-to-text

You can use the _______ to copy and paste from one presentation to another. A. notepad B. documents clipboard C. server clipboard D. web clipboard

D. web clipboard

Which of the following is not a category option for a pivot table in Google Spreadsheets.

Data

Google Spreadsheets can be exported to the following formats A. .xls B. .rtf C. .csv D A and B E. A and C

E Xls and .csv

Speaker notes are not allowed in presentations in Google Docs.

False

When uploading a folder with subfolders into Google Docs, the subfolder structure will not be maintained.

False

You can easily delete slides from your presentation, but they cannot be recovered in the revision history due to slide revision hierarchy.

False

You can explicitly share a doc or file with 300 viewers and editors (combined).

False

You must install the Google Docs app in Chrome before you can use Offline Docs.

False

You can send an email to the collaborators on a document by going to:

File > Email collaborators

In the Research tool, you can filter image results by?

Free to use, share or modify, even commercially

What is the name of the correct spreadsheet function for translating text from and into one of over 40 languages using Google Translate.

Google Translate

Which of the following is not a methods for creating a new form?

In a existing spreadsheet, click the Edit DROP-DOWN menu and select CREATE A FORM

There are the three ways to open the Animation pane. which of the following is not an option?

Right Click on a selected and select animate

There are the three ways to open the Animation pane. Which of the following is not an option?

Select a shape. Then, go to the insert menu and select Animations. The Animations pane will appear on the right side of your screen.

Simply hit the______keys to create a new text document in your Docs List.

Shift+T

Users have the ability to export Google Docs to a PDF.

True

When you share a document with a group email alias (a Google Apps group), they will need to first open the document before it will appear in their drive.

True

You must allow offline access for each individual computer where you'd like to view your documents and spreadsheets without an internet connection.

True

If you have a specific end date or time in mind for accepting responses- as you might for an application or assignment- you can set the end date/time.

True - with a script

Click the button next to this option if you'd like the pivot table report to update continuously as you make changes:

Update table on each change

You can browse the template gallery to preview and select any presentation template in two ways. Which of the following is a correct way to select a presentation template?

While in a document, go to the file menu, select new and click from template

In Google Slides, you can add or modify slide transitions and animations in the _________.

animations pane

Google Docs offers users the following tools, except ______.

audio editing

The maximum number of sheets a Google Spreadsheet workbook can contain is. A. 10 sheets B. 200 sheets C. 500 sheets D. unlimited E. none of the above

b. 200 sheets

In spreadsheets, the filter toolbar icon will change to _____ if a filter has been applied to any column in your spreadsheet.

bolded black

Google drawings allow users to import the following file formats: a. .png b. .svg c. .jpg d. all of the above e. none of the above

d. all of the above

To save a copy of a presentation to your computer, you can download it as a file. Which of the following is not a file option?

gif

To share from your mobile docs list, select one or more documents, press the ______ button.

share

While viewing the revision history of a document you can jump back to the latest version of the document by clicking Older until you find the latest version A. true B, false

B, false

Mr. Jamison is a teacher at a school that just switched to Google Apps. He wants to upload and convert his exiting documents into Google Drive. Which of the following file type(s) can he upload an convert into a document. A. .flv B. .doc C. .pages D. mp4

B. .doc

How many users may edit and view spreadsheet, document, or drawing at the same time? A. 25 B. 50 C. 75 D. 100

B. 50

If a student embeds his/her Google Slides presentation into a web page, s/he can use all of the following advanced features EXCEPT A. Autoplay B. Audio Voiceover C. Timing between slides D. Automatically restart the presentation (loop)

B. Audio Voiceover

_________ allows you to align objects with the drawings canvas and other objects.

Snap to guides

Google Drive can be accessed at a custom URL for your school. This needs to be set by a domain administrator.

True

Google Slides includes a number of transitions choices between slides?

True

Google presentation Includes a number of transition choices between slides.

True

If you add documents to a shared folder, the document is automatically shared with everyone who has access to the shared collection?

True

If you add someone to a comment who doesn't have viewing or editing rights to the presentation, they will not receive a comment notification in their email inbox.

True

If you are creating a form with your school Apps account, you can also choose to record the email addresses of members of your Apps domain who fill out your form.

True

In Drawings, if you're using the latest version of Chrome, Safari, or Firefox, you also have the option of dragging an image from your desktop and drop it directly in the drawings canvas?

True

In Google Forms, if you select the option "Allow users to edit responses", users can modify their responses as many times as they like.

True

In spreadsheets, it is possible to chart multiple ranges of data?

True

It is possible to create a new spreadsheet from the mobile version of Google Drive.

True

Once an animation is listed in the Animations pane, you can drag an animation up or down to change the order in which shapes appear or disappear on the screen

True

Once an animation is listed in the Animations pane, you can draw an animation up or down to change the order in which shapes appear or disappear on the screen.

True

There is a limit on the number of functions in a spreadsheet?

True

Upon form submission, responses are collected and displayed immediately in a corresponding Google Docs spreadsheet.

True

Upon form submission, responses can be collected and displayed immediately in a corresponding spreadsheet.

True

When you are using Apps mail, Google will automatically detect supported file types for your attachments and offer an option to open the attachment using Google Docs, either as a Google document, spreadsheet, or presentation.

True

When you copy and paste slides into a different presentation, the newly pasted slides will keep the theme of the original presentation.

True

When you create a master presentation with a theme, even a blank theme, any imported slides can be adapted to that theme.

True

When you create a new doc, you are automatically the owner.

True

When you create new doc, you are automatically the owner.

True

When you publish a document and view it as a web page, the comments will not be viewable on the web page.

True

When you remove a collaborator from a private document, the change is effective immediately and s/he will no longer have access to the document.

True

You are able to share docs from your mobile device?

True

You can apply formatting or conditional formatting rules you've used on one set of spreadsheet cells to another separate set of cells using the _______ tools.

paint format

Both indents and tab stops in a document can be changed at the ______ level.

paragraph

In Drawings, _______ are continuous lines composed of multiple segments.

polylines

To see who has edit or view access to your document at any time, simply click the __________ button in the top right corner of the doc.

share

To convert an excel email attachment in gmail to a google spreadsheet, click the ___ icon on the attachment.

show in drive

Forms allow you to set the frequency of notifications for form responses. Which of the following is not an option?

weekly digest

Which of the following video file formats will not play in Drive?

.swf

What is the limit for individual responses to a google form?

5000

a student wants to use Google Docs to edit some existing work on his hard drive. All of the following file formats an be converted into Google Docs EXCEPT A. .FLV B. .PPS C. .XLS D. .DOC

A. .FLV

Data validation in spreadsheet allows you to do all of the following except: A. validate formulas B. validate numbers, dates and text C. prevent users from entering text that doesn't match your criteria, or show them a comment on the cell when the data doesn't match the validation rule D. Add text to cells that have data validation which helps your collaborators enter the right type of data

D. Add text to cells that have data validation which helps your collaborators enter the right type of data

Students with the following role(s) can make a copy of any Google Doc, Sheet or Slide presentation A. Editors B. Owners C. Viewers D. All of the Above

D. All of the Above

_____ in spreadsheets are helpful way to leave notes to other collaborators about your spreadsheet data. A. Tasks B. Footnotes C. Messages D. Comments

D. Comments

The summary of responses generated by a form can be edited to exclude certain users or data

False

There is no limit to the number of people that can edit a spreadsheet at the same time.

False

Up to 150 students can edit a document at the same time?

False

When members are removed from a google app group, their access to a document shared to the group will not change?

False

When you create a new presentation slide, there is only one choice for a slide layout?

False

Which of the following is not a chart type available by default in a Google Docs spreadsheets?

Gantt Chart

Which of the following is not a method for freezing rows in a spreadsheet?

Hiding the adjacent columns

Which of the following web browsers does not currently support drag and drop upload from the desktop to a collection in Google Docs?

Internet Explorer

The following statements about publishing Google Docs are true, except for the following:

It's not necessary to publish documents in order to embed them on blogs or other websites and have them veiwable by anyone.

Which of the following is not a data type a spreadsheet cell may be?

Kcals

The Research tool within documents allows you to choose from which of the following citation methods?

MLA, APA, Chicago

When you add a footnote to your document, there will be a footnote marker within the actual document designated by a ________

Number (e.g. 1, 2, 3)

Bookmarks are highlighted sections with comments in a document.

False

You can print your Google documents and spreadsheets from your mobile device using Google Cloud Print A. true B. False

A. true

Images can be added directly to a Document by ________ from the desktop. A. drag and drop B. twist and slide C. drag and insert D. none of the above

A. drag and drop

Select ____ to combine all selected in a range into one cell A. merge all B. merge cells horizontally C. merge cells vertically D. none of the above

A. merge all

Google Apps for education has a template gallery within your school Apps domain that is separate from the public gallery A. true b. false

A. true

It is possible to upload images directly to a spreadsheet in Google sheets A. true B. false

A. true

Key compatibility advantages of Google Docs includes all, but the following:

Ability to convert Wordperfect files into Google Docs

The following document types can be printed from Google Drive: Drawings, Documents, Spreadsheets, Presentations, All of the above

All of the above

Once you submit a template to your domain's gallery, you cannot make changes or delete the template.

False

Once a comment has been resolved in Google Docs, it can no longer be viewed or edited. A. True B. False

B. False

Your colleagues want to have the entire 5th grade class (of 150 students) edit a document at the same time. This will work since up to 150 users can edit a document at the same time. A. True B. False

B. False

________ lets you convert images with text into text documents using automated computer algorithms. A. Optional Computer Reformatting (OCR) B. Optical Character Recognition (OCR) C. Portable Document Format (PDF) D. Conversion Adaptability Blueprint (CAB)

B. Optical Character Recognition (OCR)

___________ adds visual page breaks while you're editing your documents, so you can see how many pages of the report you've actually finished. A. tabbed break B. pagination C. compact view D. poly line

B. Pagination

The spell-check in Docs can be launched from ___ A. Edit>spelling B. Tools >spelling C. format >spelling D. none of the above

B. Tools >spelling

Which of the following is not a question type in forms? A. scale B. divergent C. Checkboxes D. choose from a list

B. divergent

Both the owner and editors of a document can delete the document A. true B. false

B. false

In the Sheets revisions history, changes are not color-coded based on each collaborator, but students can still tell what has been added or deleted A. true B. false

B. false

To allow responders to see the summary of responses to a form, you need to check which button? A. Show link to submit another response B. Publish and show a link to the results of this form to all respondents C. Allow responders to edit responses after submitting D. Show progress bar at the bottom of form pages

B. publish and show a link to the results of this form to all respondents

Once you submit a template to your domain's template gallery, you cannot make changes or delete the template

False

Sharing level access changes usually take about an hour to take effect.

False

Using the Research tool, an easy way to get pictures into your document is to simply A. hover over the picture and click insert B. click on the picture and click insert C. click and drag the picture into the document D. right click to download the image and then upload it into the document

C. click and drag the picture into the document

Which of the following is not a notification that can be set on a spreadsheet? A. when changes are made to forms B. when the spreadsheet is duplicated C. when collaborators are added or removed D. when changes are made to a specific sheet

C. when the spreadsheet is duplicated

The _____ feature in Google Sheets makes it easier to analyze and view your data by hiding the data that you temporarily want to take out of view A. sort B. lookup C. organize D. Filter

D. Filter

Teachers can specify which users see which pages of a form by using the option labeled A. Grid B. Scale C. Help Text D. Go to page based on answer

D. Go to page based on answer

When a student wants to add an image to a document, which of the following is NOT an option? A,. by URL B. import C. Google Drive D. Stock Images

D. Stock Images

In addition to YouTube, you can also embed videos from other providers such as Vimeo, SchoolTube, and other video sharing services into a presentation.

False

Offline access to Google Docs is available from any web browser:

False

Offline access to Google Drive is available from any web browser.

False

To add a doc to a collection, you can do the following:

Drag the doc from your Docs list to the collection. Select one or more items and select the Organize button. Check off the collections where you want to store items and click apply changes.

At this time, it is not possible to create a new presentation in Google Docs on your smartphone.

False

Collaborators can delete documents, spreadsheets, presentations, and drawings, and thereby remove access for other collaborators and those with viewing access.

False

Comment in spreadsheets only edited or deleted by the owner of a spreadsheet.

False

If a collaborator duplicates a protected sheet, copies the workbook, or uploads a new version, sheet protection settings will remain intact on the new copies of the document?

False

Comments in a spreadsheets can only be edited or deleted by the owner of a spreadsheet?

True

A new drawing can be created from within Docs, Sheets, or Slides?

True

Animations can be used to control the sequence in which objects appear on a slide in Google Slides.

True

Google Docs allows users to work on the same documents, at the same time.

True

Google Docs allows you to save any document, spread sheet, presentation, drawing, or form as a template for others to use.

True

Using the research tool, to cite a web source you

highlight the text to be cited, hover over the results and click cite

To view a comment after it's been inserted into a spreadsheet cell, _______ your mouse over the orange comment indicator.

hover

If you are using Google Sites, you can add documents, spreadsheets, presentations, and forms directly from the __________ menu.

insert

When adding a picture from the reasearch tool, a citation is added ______ .

as a footnote

Which of the following is NOT a source built into the Research tool? A. images B. scholar C. blogger D. quotes

c. Blogger

With the cell-presence indicator in spreadsheets, collaborators can avoid editing a cell at the same time. In the image below, which cell represents a cell that a collaborator is working in?

cell with the pink border

The ______of a document, spreadsheet, presentation , or drawing can always control exactly who has access to their document and how much access each person has. a. editor b. owner c. viewer d. a and b e. b and c

d. a and b

The following can be inserted into a document via the insert menu a. bookmark b. table of contents c. dictionary d. a and b

d. a and b

In Presentation, you can add a comment to which of the following: a. a table b. an image embedded in your google presentation c. a section of text d. all of the above

d. all of the above

Which of the following items can be added to a presentation? a. video b. images c. custom shapes d. all of the above e. none of the above

d. all of the above

Using the research tool, to insert a map from the results you can: a. click and drag the map into the document b. hover over the map and click insert c. double click the map d. either a or b

d. either a or b

To view your presentation with no browser toolbars as a distraction, which icon should be selected a. options b. play c. full screen d. none of the above

d. none of the above

How can you remove collaborators from a shared document? a. Move the document to a new folder b. Change the visibility option of the document c. remove the collaborators one at a time from the share settings. d. all of the above e. both b and c

e. both b and c

In order to remove a sheet from view in a spreadsheets workbook, you have to click on a sheet tab and select ___.

hide sheet

Templates can be submitted to your domain's template gallery from several locations.

From within a Collection

Which of the following statements about spreadsheets gadgets is not true.

Gadgets cannot be published for public view.

Google Docs will send you notification of any changes that you make to the spreadsheet.

False

If other people are editing a document simultaneously with you, you'll not be able to see their edits in real time.

False

If three teachers are editing a document simultaneously, they will need to wait a few minutes to see each other's edits.

False

Unlike Docs, Sheets, and Slides, it is not possible to have multiple editors in a Drawing in Google Drive.

False

Unlike Docs, Spreadsheets and presentations, it is not possible to have multiple editors in a drawing Google Docs.

False

An easy way to insert a web image is to drag it directly from the webpage into your presentation.

True

Documents, spreadsheets, and presentations have the same limit for the number of editors and viewers accessing a document at the same time.

True

Formatting rules in spreadsheets allow you to change the color of text or background of a cell based upon a value.

True

Google Docs can be accessed at a custom URL for your school. This needs to be set by the domain administrator.

True

Google Drive allows you to save any document, spreadsheet, presentation, drawing, or form as a template for others to use.

True

In Google Docs, people who can edit your document will also be able to share it with additional people unless you change the default settings.

True

To access your form response spreadsheet from the Edit Form page, click the _______ button at the top-right of the form and select Spreadsheet from the drop down menu.

view responses