Font size
WorksheetsGoogle Workspace ( Sheets, Slides, Meet, Chat )
Total questions: 54
Worksheet time: 30mins
On the Rise store owner Yousef Amadi wants to create an inventory sheet for his employees. 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
Yousef has a series of spreadsheets that he has created in Microsoft Excel. 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
On the Rise partner owner Thomas Omar is reviewing a Google Sheet named "On the Rise Monthly Sales Figures." He'd like to better analyze the data by filtering the data. 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
Now, Thomas wants to add some data to the Sheet. 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
Thomas Omar is working on a Google Sheet with sales data from On the Rise stores in the Asia Pacific region. He'd like to see an average sale price. This data is found in cells J3 through J44. Which of the following formulas should he use?
=AVERAGE(J3:J44)
=SUM(J3:J44)
=AVERAGE(J3-J44)
AVERAGE(J3:J44)
Thomas wants to share a Google Sheets spreadsheet with On the Rise store owner Yousef Amadi. He'd like him to be able to download and print the file but not make any changes. What type of collaborator role should he assign to him?
Owner
Editor
Viewer
Suggestor
Seroja makes some changes in "On the Rise marketing data," but later decides she'd like to return to the version shared by Kaina Gao. 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
Kaina Gao would like to assign an action item to Anthony Dylan. 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
Thomas is reviewing a Google Sheet named "On the Rise forecast report." He'd like to leave a comment on cell A22. 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
Anthony is working on the Google Sheet when he notices that Sherrie is online as well. Anthony would like clarification regarding a few comments that Sherrie has left him. 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
On the Rise store owner Yousef Amadi wants to create a presentation for his employees. 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
Yousef wants his presentation to match other On the Rise files and documents. 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
On the Rise partner owner Thomas Omar will be taking a few days off and heading out of office. He is about to shut down his work computer, but wants to ensure the changes he has made in Google Slides have been saved. Choose the best answer.
Select File > Document details
Turn on offline
Select File > Save
Select See document status
Kaina Gao is preparing a Google Slides presentation that she will present to the On the Rise marketing team next week. She'd like to add speaker notes so she doesn't forget key points. 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
Kaina Gao has just inserted an image on-screen. She would now like to reposition it so it is in the middle of the page.
Kaina Gao has just inserted an image on-screen. 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
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
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
How can he quickly reference his speaker notes?
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
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
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
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
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
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
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
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
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
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
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
Fernando wishes to stay as connected as possible to his teammates while he works from home. He wishes to install Google Chat on as many devices in his home as possible. Which of the following devices does NOT support Google Chat?
His smart phone
His tablet
His desktop computer
His smart TV
Sherrie, head of HR and Employee Development sees Jaspar is currently online and wishes to message him quickly. She doesn't want to risk him not seeing his email until later. What should she do?
Click on his name in the Chat list in chat.google.com, type her message, and press Enter or click the Send message icon
Start a new meeting and invite him
Call his phone number, though he typically doesn't answer
Send an email containing the word 'URGENT' in the subject line
Sherrie is active in many direct conversations. She notes that one conversation with a colleague hasn't been active in six months and decides she wants to hide it from view. What does she need to do?
Unfollow the conversation
Select the name of the direct conversation, then select Hide Conversation
Remove the star from the conversation
Add the label Hidden to the conversation
Sherrie wishes to wish Kaina a happy birthday over chat. She wants to make the message extra special. Which of the following actions can Sherrie NOT take?
Use the formatting options to change the text color and formatting
Add a gif to the message by selecting the gif icon
Add emojis to her message
Select the option to have her text animate on the screen
Kaina is having a long conversation with Sherrie using Google Chat. She mentions a Google Meet may be easier than typing so much, and Sherrie agrees. What can Kaina do quickly to avoid interrupting the conversation's flow?
Type start meeting into the chat
Create a meeting invite in Google Calendar
Go to google.meet.com
Select Add video meeting in the reply area of their chat
Anthony starts a direct Google Chat with Sherrie. She mentions some technological improvements that the Head Office intends to implement at the store level. Anthony wants to retain a few of her messages for quick reference in the future. What should he do?
Click More actions then, Forward to inbox in Google Chat
Use Google Chat to take a screenshot
Click the message to save it in Google Chat
Star the Google Chat conversation
Dao wants to strengthen the culture of On the Rise by encouraging more dialogue for shared interests amongst the team. He doesn't want to add another recurring meeting to people's agenda and doesn't want people to feel pressure to engage, this should be fun. What can he do?
Create a weekly recurring meeting and include all teammates as optional attendees
Create a Google Doc that people can add to at their leisure
Create a space entitled 'Off the Clock' for teammates to discuss their passions and hobbies
Start a mass email chain with the subject: '[Optional] Team Icebreakers, Trivia, and Activities'
Yousef is an On the Rise store owner located in Fort Lauderdale, Florida. He and other On the Rise store owners like to frequently communicate in order to share and store their collective knowledge for later reference. What is the best way for them to communicate their shared learning?
An email message
A space in Google Chat
A Google Chat direct message
A Google Meet video conference
Kaina wants her team to be aware of current tasks being assigned amongst the group and when they finish. She would rather this be incorporated into everyone's current work tools than create a new process. How should she proceed?
Utilize the Tasks tab in the team Space
Assign projects in a weekly team meeting that isn't always fully attended
Send everyone a chat message individually
List current business items in a daily email and hope everyone sees them
Store owners use a space to discuss recipes. Yousef sees a thread about possible changes to cinnamon buns and wants to receive notifications whenever there is new activity. What does he need to do?
Turn on notifications in Gmail settings
Download the mobile app to his phone
Click the thread and select Follow
Click the thread and select Star
Roberto and his team at On the Rise Seattle are all members of the Cat Lovers space. He heard about an app that populates chats with cat photos via simple key commands. He wants to use it to delight his team. How can he search for the app?
Instruct everyone on his team to find and download the app
Type find cat app in the chat field
Ask the Space Manager, Celeste, to download the Google Chat app for the group
In the Start a chat submenu, search and add the app by selecting Find apps
