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
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
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 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
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 Docs, people who can edit your document will also be able to share it with additional people unless you change the default settings.
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
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
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
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.
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
Google Docs will send you notification of any changes that you make to the 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
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
Comments in a spreadsheets can only be edited or deleted by the owner of a spreadsheet?
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
A new drawing can be created from within Docs, Sheets, or Slides?
True
An easy way to insert a web image is to drag it directly from the webpage into your presentation.
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