WorksheetsGoogle Workspace ( Docs, Sheets, Slides, Meet, Sheet Advanced )
Total questions: 71
Worksheet time: 38mins
Seroja Malone has just created a Google Doc featuring a new cinnamon bun recipe. She shares this Doc with On the Rise store owner Yousef Amadi. She'd like him to be able to download and print the file, but not make any changes. What type of collaborator role should she assign him?
Owner
Editor
Viewer
Suggester
Sherrie West has just completed a Google Doc that will serve as a new hire training manual. She would now like to transfer Doc ownership to On the Rise partner-owner Thomas Omar who is already an editor of the document. What does she need to do?
Email Thomas the link to the Doc
Edit the link to the Doc by adding /owner=Tomar
Select Share and remove herself as an Editor
Select Share, and choose Editor to the right of Thomas Omar, then Make owner
Thomas Omar makes some changes in the new hire training document, but later decides he'd like to return to the version shared by Sherrie. What does he need to do?
Check his email for the older version
Ask his IT person to restore a backup of the Doc
Select File, then Version history, then See version history, choose the version from the correct point in time, and then select Restore this version
Go to Trash and restore the older version
Sherrie West has been speaking with the On the Rise Leadership Team and would like to draft a project proposal. She knows similar company docs already exist. What should she do?
Go to docs.google.com and select Blank
Type docs.new into the browser and select New
Start a new document from a template and select a proposal template from her organization
Seroja Malone has a series of recipes that she'd like to share with the On the Rise team. These files are currently Microsoft Word documents. What is one way for Seroja to turn them into Google Docs?
Upload the Word docs to her Google Drive, select Open with Google Docs, select File, and Save as Google Docs
Re-type the content in Google Docs
Open Google Docs, then select Insert, then select From Word Doc
Sherrie West has recently received a new version of the OTR new hire training manual from Thomas Omar. Unfortunately, rather than updating the original, Thomas has made his updates directly in a new Google Doc. How can Sherrie easily compare this new version with the version she sent him last week?
She can use the Compare documents feature
She can use the Restore version feature
She can browse the File version history
She can use the Suggestion feature
Sherrie West is head of HR and Employee Development at On the Rise. She is developing a Google Doc training manual for new employees. Sherrie would like to make this Doc easy to navigate by adding a table of contents. What two things must she do to set this up?
Use heading styles in her document
User footers in her document
Insert a table of contents in her document
Sherrie wants to make sure readers can easily move around the training document. She decides to add bookmarks to key sections. How does she create her bookmarks?
She needs to select the text she wishes to bookmark and select Add link
She needs to select the text she wishes to bookmark and select Insert, then Bookmark
She needs to select the text she wishes to bookmark and select Bookmark
She needs to select the text she wishes to bookmark and select Insert, then Add link
Sherrie decides to add a Chart that is linked to a survey she has recently shared with the On the Rise team via Google Forms. How can Sherrie ensure the chart in the Google Doc stays up to date as team members complete the survey?
The chart in Google Docs is integrated with Google Sheets and will automatically update
Insert the chart again after each major update
Copy the data from the Sheet to a table in the Doc
Share the Doc with each team member for updates
On the Rise partner owner Seroja Malone is traveling to Italy to meet with a new cinnamon supplier. Seroja wants to ensure she can work on her Google Doc for the duration of her flight. How can she check that the file is available for offline access?
She can select See document status
She can select Page Setup
She can select the Format menu
She can select Always on from the document's preferences
On the Rise partner owner Thomas Omar has completed a Google Doc and would now like to move it from his personal drive to the team shared drive. What's one way he can move the Doc?
Select the Move icon
Drag the Doc to the edge of the screen
Email to the shared drive address
Select File > Make a copy
Sherrie West is working on an important Google Doc. She decides she'd like to make it easily available by adding it to her starred label. What does she need to do?
Select the Star icon next to the Share button
Select the Star icon next to Google Chat
Select the Star icon in the top right corner
Select the Star icon next to the document title
Anthony is working on the Google Doc when he notices that Kaina Gao is online as well. Anthony would like clarification regarding a few comments that Kaina Gao has left him. What is the best way for Anthony to collaborate with Kaina Gao?
Send Kaina Gao a Gmail message with his question
Send Kaina Gao a dynamic email using Gmail
Use Google Chat to message her directly in the Google Doc
Reply to each comment directly in the Google Doc
Kaina Gao would like to assign an action item to Anthony Dylan. What does she need to do? Select all that apply.
+Anthony.Dylan@Ontherisebakery.store, then check Assign to Anthony Dylan
@AnthonyDylan@Ontherisebakery.store, then check Assign to Anthony Dylan
%AnthonyDylan, then check Assign to Anthony Dylan
Send Anthony Dylan the Google Doc link, then check Assign to Anthony Dylan
Kaina Gao is working on a Google Doc about new bakery trends. She'd like to leave a comment on a chart found on Page 2 of the document. What does she need to do?
Place her cursor on the chart, select Add a comment, type her comment, and select Comment
Place her cursor on Page 2, s
What does she need to do?
Place her cursor on the chart, select Add a comment, type her comment, and select Comment
Place her cursor on Page 2, select Add a comment, type her comment, and select Comment
Place her cursor on the chart, select Link to comment, type her comment, and select Comment
Select Share, select Add a comment, type her comment, and select Comment
How does he create a new Google Sheets spreadsheet? Select all that apply.
Go to Google Drive, select New, then select Google Sheets
Type sheets.new in the browser address bar
Go to googlesheets.com
Which of the following statements are true? Select all that apply.
Yousef can upload Microsoft Excel spreadsheets to Google Drive
Yousef must save his Microsoft Excel spreadsheets as Google Sheets in order to edit them
Yousef can view Microsoft Excel spreadsheets using Google Sheets
Yousef cannot convert a Google Sheet spreadsheet to a Microsoft Excel file
What does he need to do?
Select one or more cells, open the Data menu, hover over Filter views, then select Create a new filter view
Select the Data menu and choose Filter views
Select the Filter menu, choose a range of cells, then select Create a filter
Open the data menu, select Sort cells, then select Create a filter
What are some of his options? Select all that apply.
Copy and paste it from another spreadsheet
Paste it from within the same Google Sheet
Manually add the data
Import it from a Microsoft Excel file
Which of the following formulas should he use?
=AVERAGE(J3:J44)
=SUM(J3:J44)
=AVERAGE(J3-J44)
AVERAGE(J3:J44)
What type of collaborator role should he assign to him?
Owner
Editor
Viewer
Suggestor
What does she need to do?
Check her email for the older version
Ask her IT person to restore a backup of the Sheet
Select File, then See Version History, choose the version from the correct point in time, and then select Restore this version
Go to Trash and restore the older version
What does she need to do? Select all that apply.
Send Anthony Dylan the Google Sheet link, then check Assign to Anthony Dylan
%AnthonyDylan, then check Assign to Anthony Dylan
+Anthony.Dylan@Ontherisebakery.com, then check Assign to Anthony Dylan
@AnthonyDylan@Ontherisebakery.com, then check Assign to Anthony Dylan
What does he need to do?
Select More options, select Add a comment, type his comment, and select Comment
Place his cursor on cell A22, select Insert comment, type his comment, and select Comment
Place his cursor on cell A22, select Link to comment, type his comment, and select Comment
Select Share, select Add a comment, type his comment, and select Comment
What is the best way for Anthony to collaborate with Sherrie?
Send Sherrie a Gmail message with his question
Use Google Chat to message her directly in the Google Sheet
Send Sherrie a dynamic email using Gmail
Reply to each comment directly in the Google Sheet
How does he create a new Google Slides presentation? Select all that apply.
Go to google.slides.com
Go to web address slides.new
Go to Google Drive, select New, then select Google Slides
How can he access his organization's available Google Slide templates?
He can do a Google Search for Slides templates
He can go to docs.google.com and choose a template
He can search Google Drive for presentations and copy one
From Google Drive, select New, then Google Slides, then select From a template
What is the best answer?
Select File > Document details
Turn on offline
Select File > Save
Select See document status
What does she need to do?
Right click the slide, then select Add speaker notes
Select Tools, then Script editor, then Add speaker notes
Select the File menu, then Add, then Add speaker notes
At the bottom of the slide in the 'Speaker notes' section, click Click to add speaker notes
What are some of the ways she can move the image? Select all that apply.
She would now like to reposition it so it is in the middle of the page. What are some of the ways she can move the image? Select all that apply.
She can select the border lines of the image and drag it with her mouse
She can select the image and use the arrow keys
She can select the image and use the Arrange menu
She can select the Apply layout menu
Anthony is working on a slide and decides he'd like to change the slide background from the default white to an image on his desktop. How does he do this? Select all that apply.
He can right-click an empty area of the slide, select Change background, and then Choose image
He can right-click on the image from his desktop, then select Add to Google Slides
He can select Tools, then Change background, and then Choose image
He can open the Slide menu, select Change background, and then Choose image
Anthony Dylan is designing a Google Slides presentation for the On the Rise head office team. He'd like to add a chart so that data dynamically changes when updates are made in Google Sheets. How does he do this?
Go to Insert, then Diagram, then From Sheets
Go to Insert, then Chart, then From Sheets
Go to Insert, then Chart, then Dynamic Updates, then From Sheets
Go to Chart, then From Sheets, then Update
Anthony is working on a slide that includes numerous elements, such as photos, charts, and text. He'd like to set up object animations. What are some of the customizations from which he can choose? Select all that apply.
Animation speed (from slow to fast)
When the animation occurs (on click, after previous, with previous)
Animation per object or per group
Animation order
Thomas would like to import a single slide from a previous presentation he has stored on his Google Drive. What does he need to do?
Open the File menu, select the presentation, then the specific slide, then choose Upload to import slides
Open the File menu, select Upload, then the presentation, then the specific slide, then choose Upload to import slides
Open the Slide menu, select the presentation, then the specific slide, then choose Upload to import slides
Open the File menu, select Import slides, select the presentation, select the specific slide, then select Import slides
Thomas Omar is working on a Google Slides presentation that he intends to present at the weekly On the Rise head office Google Meet. He adds a slide named "On the Rise News." in the middle of the presentation. Later, he decides he'd like to have this slide appear at the end of the presentation. What does he need to do? Select all that apply.
Select and drag the slide down in the preview panel
Right-click on the slide preview and select "Move slide to end" in the menu
Right-click on the last slide and select "Replace this slide" in the menu
Thomas reviews his Google Slides presentation and determines that Slide 3 is not relevant for the head office meeting. How can he skip that slide while in presentation mode? Select all that apply.
He can select Tools, then select Skip, then select Slide 3
He can right-click on Slide 3 in the preview panel and select Skip slide
He can go to Slide 3, right-click on the slide, and select Skip in the menu
He can go to Slide 3, select the Slide menu, and select Skip slide
On the Rise store owner Yousef Amadi has recently been added to a Google Slides presentation as a viewer. What can he do in View Mode? Select all that apply.
Make changes to the document, as long as the owner allows it
Download it, as long as the owner allows it
Print and copy it, as long as the owner allows it
Respond to suggestions, as long as the owner allows it
Seroja assigns Sherrie West as an editor. Seroja would like Sherrie to make content updates, but does not want her to share the file with additional collaborators. How can she set this up?
Change Sherrie to a viewer
Open the "Share with people" settings and disable editor sharing permissions
Disable link sharing
Change Sherrie to a commenter
Seroja would like to review all the comments that have been added, edited, and resolved within the presentation. What does she need to do?
Select Open comment history
Select View named versions
Select Share, then View named versions
Select View, then Open comment history
Anthony Dylan is working on a Google Slides presentation in which he and Seroja are both editors. He leaves a comment for @SerojaMalone, asking for her feedback. How does Seroja reply to Anthony's comment?
She must open the Insert menu, select Reply, type her response, and hit Enter
Select Open comment history, type her response, and hit Enter
Select the Comment card, type her response, and select Reply
She can select Comment, type her response, and hit Enter
Anthony decides he wants to edit the comment he has left for Seroja. How can he do this?
He must select More options, then Edit
He cannot edit the comment, but he can delete it and leave the comment again
He can select Comment, then Edit
He can right-click, then select Edit
It's Wednesday morning, and the On the Rise head office team is gathered for Thomas Omar's Google Slides presentation. Thomas wants to move his slide deck into presentation mode. What does he need to do?
Right-click, then select Present
Select Slide, then select Present
Select Slideshow, then select From beginning
Click the Present button
Thomas begins his presentation but decides the deck is advancing too quickly. How does he update his settings so that the slide deck auto-advances every minute?
He can select Q&A, then Auto-advance (when played), and choose Every minute
He can select Tips, then Auto-advance (when played), and choose Every minute
He can select Presenter tools, then Auto-advance (when played), and choose Every minute
He can select Options, then Auto-advance (when played), and choose Every minute
During the presentation, Thomas wants to quickly reference his speaker notes. How can he do this?
He can select Transcript
He can select Audience tools
He can select Notes
He can select Q&A
What is the name of Google's video software tool?
Google Spaces
Google View
Google Lens
Google Meet
Kaina has decided on some recipe changes to the current menu. She needs to create a video meeting to discuss these changes with Seroja. Which option will NOT achieve this?
Type Start Meeting in the Chrome browser
Click the Meet Icon in the App Launcher
Use the New meeting button in Gmail
Type go.meet in your web browser
Seroja has scheduled a video conference to take place next week to check in with her team. She realizes she forgot to include Kaina. What should she do?
Take notes to pass to Kaina after the meeting
Type Kaina's email address into the meeting chat
Cancel the meeting and create a new one that includes Kaina
Edit the event in Google Calendar to add Kaina as a guest
Yousef Amadi is a store owner located in Fort Lauderdale, Florida. He receives a Google Meet video invitation from Anthony, but knows he will be out of office. He decides he will still try to join by dialing in. Which option below will NOT achieve this?
Enter the PIN
Dial in using the Google Meet phone number
In Gmail, click Join a meeting
Open Google Calendar to see the Google Meet event information
While the Google Meet video conference is in progress, Thomas wants to invite his wife, Seroja. Which is NOT a way he can add her to the call?
Click Add people, type her email address, and click Send email
Click Add people, enter Seroja's phone number and click the Telephone icon
Type her email address into the Google Meet chat
Click Meeting details, copy the joining info, and email it to Seroja
Kaina Gao is head of Global Marketing at On the Rise. She organizes a Google Meet video call but realizes her audio isn't working. What steps should she take to investigate this issue? (Select two.)
Restart her computer
Use CTRL/CMD+M to unmute her mic
Speak into her microphone and ensure that three green bars appear in response to her voice
Plug her phone into her computer
Click More options, select Settings and check if her microphone is set to her device's defaults
There are many people in the meeting and Kaina is having trouble identifying who is speaking. She wishes to modify her settings to better see the current speaker. What should she do?
Adjust the Change layout setting in the More options menu to Tiled
Adjust the Change layout setting in the More options menu to Spotlight
Ask everyone to turn off their video feed when not speaking
Turn on Captions
During the video conference, Yousef Amadi wants to access some marketing resources that are attached to the meeting's calendar event. What should he do? (Select two.)
Create a meeting notes document in Google Calendar
Click Meeting details, to view attachments
Open the Google Meet link in Google Drive
Select the link in the chat panel
Open the attachments in the Google Calendar invite in her Inbox
Later during the meeting, Kaina wants to share a supplier's webpage to Yousef for him to review prices on his own after the meeting. How can she do this using Google Meet?
Email him a link
Instruct Yousef to write down the name of the webpage as she spells it out
Paste a link to the webpage in the meeting chat box for Yousef to retrieve
Present her tab so that Yousef may see the page
Kaina wishes to brainstorm new menu ideas with the group but is concerned that certain people will speak so much that others may stay quiet. She wishes to separate the team into small working groups momentarily, to have a better chance of everyone getting involved. What should she do?
Use the Activities function to split the call into smaller discussion groups
Create a list of names and times during the call for people to join and leave the meeting by
Create new meeting invites for the smaller groups to leave the current call and attend
Ask everyone to speak once
Dao was invited to the meeting, but Kaina sees that he is not present and noticed he left a note in the Calendar invite saying he had a doctor appointment. Karina wants him to review important information being discussed. What should she do?
Ask everyone to email their items to Dao to review at his convenience
Ask everyone present for their permission and select Record meeting from the More options menu. The recording will be sent to all invited.
Cancel the meeting and reschedule for a date that Dao can attend
Take notes to pass to Dao later
Kaina wants to see what everyone in the call thinks about some marketing campaigns she's presented. She'd like a way to take a vote. What can she do?
Ask everyone to raise their hand when an option they like is presented
Ask them to type +1 in the chat when an option they like is presented
Start a poll using the Activities panel
Ask everyone to email her their selection
Yousef is reviewing his store inventory. He wants his Google Sheet to visually identify cells where the store's flour inventory fell below 100 bags. What does he need to do in order for Google Sheets to do this automatically? Select the correct response.
He can highlight the cells with flour inventory, open the Format menu, then select Alternating colors
He can highlight the cells with flour inventory, open the Data menu, then select Named ranges
He can highlight the range with the flour inventory, open the Format menu, then select Conditional formatting
He can highlight the column with flour inventory, open the Data menu, then select Create a filter
Seroja wants to ensure consistency when preparing sales and inventory reports. How can she automatically apply the same formatting every time she creates a new monthly reporting spreadsheet?
She can select a cell range, click the Paint format button, then select a different range in order to copy the formatting
She can open the Data menu, select Data validation, then create rules that set the colors of each cell in the sheet. Each month, she can run the Data validation on her new sheet
She can open the Format menu, select Theme, then choose an option from the panel. Each month, she can use the same Theme
She can select the cell range, open the Data menu, then select Protected sheets and ranges. Each month, she can copy the Protect range to her new spreadsheet
Thomas sends "South America forecast report" to On the Rise partner owner Seroja Malone. Seroja wants to create a data validation rule to ensure that Column C only includes sales from the month of June. What does she need to do?
She can open the Insert menu, select Data validation, choose Column C, and add the criteria Text | equals | June. Then, select Save
She can ask Thomas to apply a custom filter to Column C
She can create a custom formula that includes the range "June sales"
She can open the Data menu, select Data validation, choose Column C, and add the criteria Text | equals | June. Then, select Save
She can right-click on Column C, select Data validation, and add the criteria Text | equals | June. Then, select Save
Seroja selects the cell H30. It contains the following formula: =H1+H8. She copies the contents from H30 to cell I30. What happens to the formula?
You cannot copy a formula, only numeric values
The formula stays as =H1+H8
The formula automatically updates to =$H1+$H8
The formula automatically updates to =I1+I8
Seroja determines that she does not want the formula in cell H30 to change from =H1+H8 when she copies it to cell I30. What does she need to do to keep the formula constant when copy-pasting?
You cannot copy a formula, only numeric values
She can turn it into an absolute reference by changing the formula to =$H1+$H8
She can make it auto-update by selecting absolute reference in the reference panel
She can select the freeze pane
On the Rise store owner Yousef Amadi is analyzing monthly sales data from his Fort Lauderdale store. He'd like to see the data visually by converting it into a bar chart. What does he need to do?
He needs to open the Data menu, click Create Chart, and follow the instructions to select a range and configure the chart
He needs to select the range of cells to include, open the Insert menu, select Chart, then choose Bar Chart
He needs to select the range of cells to include, open the Tables and Charts menu, select Chart, then choose Bar Chart
He needs to select More Options, then select Chart, then choose Bar Chart
Yousef creates a bar chart. Next, he wants to move the chart to the top left of the screen. What does he need to do?
He should open the Insert menu and select Move
He should click and drag the chart
He cannot move the chart once it's been inserted
He should select Move chart and insert the final screen coordinates
Yousef realizes there is an error in the data and wishes to edit the chart. How does he do this?
He should select Tools, then choose Edit chart
He should correct the data and the chart will update automatically
He should select the More options button in the right corner of the chart, then choose Edit chart
He should select Charts, then select Edit chart
Sherrie is working on a Google Sheet named "On the Rise Hiring Questionnaire". She wants to turn the Sheet into a Google Form. How does she do this?
She can open the Google Sheet "On the Rise Hiring Questionnaire", then open the Tools menu, then click Create a Form
She can open Google Forms, select Import, then choose "On the Rise Hiring Questionnaire"
She can open the Google Sheet "On the Rise Hiring Questionnaire", then select Export, then select to Google Sheets
She can download the Google Sheet, then open it in Google Forms
Sherrie has converted her content into a Google Form. She would like to add a new question. What does she need to do?
Choose Add question from the floating toolbar to the right of the question card
Type a ? followed by the question text
Right-click anywhere in the form and select Add question
Click the Options button and select Add a new question
Sherrie wants to distribute the form so applicants can easily respond. What are some of her options?
She can embed the form on Twitter
She can select the Collect email addresses option in the form settings
She can use the Add editor option when sending the form to applicants
She can embed the form on Ontherise.store
She can share the form by email
Many applicants have completed and submitted the Form. Sherrie wants to review their responses and choose top candidates to interview. How can she view the responses of each applicant, one at a time?
She can select the Responses tab, then the Question tab
She can select the Responses tab, then the Summary tab
She can select the Responses tab, then the Individual tab
She can select the Responses tab, then the Data tab
Kaina Gao is reviewing a Google Sheet with thousands of cells of data from the On the Rise marketing team. It's suggested she use a pivot table to summarize the data. Why would this be beneficial?
He can embed the form on Twitter
He can select the Collect email addresses option in the form settings
He can use the Add editor option when sending the form to applicants
He can embed the form on Ontherise.store
He can share the form by email
