Font size
WorksheetsGoogle Workspace ( Gmail, Calendar, Meet, Chat, Sheet Advanced )
Total questions: 64
Worksheet time: 35mins
Thomas Omar has two lists of calendars - his primary calendar and a secondary calendar known as his "other calendar." Which of the following would appear in his primary calendar? Select all that apply.
Calendars listing sports events
Calendars he has subscribed to off the Internet
Calendar events that he has been invited to attend
Calendar events he has created personally
Seroja Malone wants to set up a Google Meet event with Anthony Dylan for next Friday. Which of the following buttons should she select in her Google Calendar?
Support
Mini calendar
Create
Search
Seroja Malone wants to set up an event with Anthony Dylan and Sherrie West. The group will meet every 6 weeks for an hour to discuss a new project. The duration of the project is yet to be finalized. Which of the following should Seroja do? Select all that apply.
Choose the meeting start and end time
Select Create > Event
Select Task to add Anthony and Sherrie as guests to the event
Select Custom recurrence and specify 6 occurrences
Anthony Dylan uses a Public visibility Google Calendar. His sharing permission is set to "See Only Free/Busy." Thomas Omar wants to schedule a meeting with Anthony. What will he see when he checks Anthony's Google calendar?
Thomas Omar will need to request permission to view Anthony's Google calendar
None of Anthony's events will be visible
Thomas Omar will be able to see all Anthony's event details
Anthony's events will show as "busy"
Seroja Malone sends Sherrie West a Google Calendar event invitation for next Thursday at 2pm. Sherrie accepts, but later realizes she has a conflict and that next Friday at 9am would be more convenient. What is the easiest way she can reschedule?
Sherrie can change her RSVP response to "No", then send an email so Seroja can create a new event next Friday at 9am
Sherrie can change her response to "No", select Propose a new time and select next Friday at 9am
Sherrie can delete the event from her Google Calendar and create a new Google Calendar event for next Friday at 9am
Sherrie can open her RSVP response, select Add a Note and write that next Friday at 9am works better
On the Rise store owner Yousef Amadi recently planned a team meeting on Google Meet, but then decided to delete the event. He has now changed his mind and wants to hold the meeting. How can he restore the event?
Right-click on the calendar grid and select View deleted events
Select the Settings menu, then Trash, then select the event, and choose Restore all selected
Select Options for the calendar, select Settings and sharing, and scroll to Trash
Select Settings for my calendars, then select Deleted, and choose Restore all selected
Kaina Gao will be out of office next week but has new marketing assets that she needs to distribute during the head office meeting the following Monday. What is the most effective way to ensure that she completes this task?
She can set her calendar notifications for every hour
She can set her Out of Office until when she needs to complete the task
She can set her event notification for every 12 hours
She can create a Task for Monday
As head of Product Distribution and Operations, Anthony Dylan frequently spends time meeting with On the Rise suppliers and distributors. How can Anthony set up his Google Calendar so suppliers can easily reserve blocks of time in which to meet with him?
Anthony can create an Appointment schedule
Anthony can enable Working location
Anthony can enable Events
Anthony can enable Tasks
Thomas Omar frequently holds meetings with the On the Rise team. To simplify the scheduling process, he'd like to share his work calendar with everyone at the company. Which permission option should he select?
Find a Time
Share with specific people
Access permissions
See all event details
In order to share his work with everyone at On the Rise, Thomas realizes he needs to modify his Google Calendar sharing permissions. What are some ways he can do this? Select all that apply.
He can copy the calendar URL from his browser and email it to his coworkers
He can go to the Settings menu, select Settings, ensure his work calendar is selected and scroll to Access Permissions
He can select his work calendar, select Options next to the calendar list, then select Settings and sharing from the menu
He can add a new calendar called "Shared", copy events from his primary calendar to it, and give his coworkers access
Seroja Malone wants to share her work calendar exclusively with Anthony Dylan. What does she need to do?
Select Access permissions and type anthony.dylan@ontherise.com
Select Subscribe to calendar and type anthony.dylan@ontherise.com
Select Add calendar and type anthony.dylan@ontherise.com
Select + Add people and type anthony.dylan@ontherise.com
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? Select the correct response.
How can she automatically apply the same formatting every time she creates a new monthly reporting spreadsheet? Select the correct response.
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? Select two options.
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? Select the correct response.
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? Select the correct response.
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? Select the correct response.
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? Select the correct response.
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? Select the correct response.
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? Select the correct response.
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? Select the correct response.
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? Select two correct responses.
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? Select the correct response.
The pivot table will make analysis of the data more challenging
The pivot table will help in summarizing and analyzing large datasets
suggested she use a pivot table to summarize the data. Why would this be beneficial? Select the correct response.
The pivot table will make analysis of the data more challenging
The pivot table will make it easy to display different data summaries
The pivot table will automatically show the most important data
The pivot table will make it easy to use conditional formatting
Yousef and Kaina are working together to update a Google Sheet that is used by the On the Rise marketing team. They want to automate repetitive tasks like bolding header texts. Which of the following should they do? Select the correct response.
Open the Insert menu, hover over Macros, and then click Record macro
Open the Extensions menu, hover over Macros, and click Record macro
Open the Format menu, click Theme, select a theme, and then click Customize
Open the Format menu, click Text, and then click Bold
Yousef wants to share the chart on a website that is accessible to the On the Rise team. What are some of his options? Select two correct responses.
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
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 smartphone
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
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
What is the best option?
Select Attach files from her Gmail
Select Insert files using Drive from Gmail
Update her sharing settings to accommodate larger files
What can she do? Select all that apply.
Snooze the email
Apply her custom label "Follow Up"
Schedule a response
Star the email
How can she create this label?
Rename the Starred label "OTR Survey Feedback"
Select More in the label list, then Create new label
Perform a search using "OTR Survey Feedback"
Drag the survey message to the label list
In which category will she now find messages from her Google groups?
Social
Forums
Promotions
Updates
Which of the following share settings should he select?
Comment
Edit
View
Turn on Link Sharing
What does he need to select to make this task repeat on a weekly basis?
Select Task, then Edit Details, then select the Weekly button
Select Task, then Edit Details, then choose the time and date details
Use the Task app
Open Google Calendar, then select Edit Task Details
What steps can Yousef take to ensure future messages make it to his Inbox? Select TWO correct answers.
Set up confidential mode
Add the system sender email "inventory@pos.com" to his contact list
Go into his Spam folder, select one of the messages incorrectly marked as spam, then select Not spam
Select Unsubscribe at the bottom of one of the emails
What does Anthony need to do?
Nothing. Access to the email is fixed for one week
He can select Confidential mode, then Remove access
He can open the sent message, and select Remove access
He can open Google Calendar, select the Expiration date, then select Remove access
What can Sherrie do to fix this problem?
Remove Thomas O'Malley from her directory contacts
Hide Thomas O'Malley from her directory contacts
Export Thomas O'Malley as a contact
Add Thomas Omar to her personal contacts
Which of the following instruction lines should she include?
Create a Google Doc with the name "Gmail signature"
Select the Advanced tab
From Settings, scroll to Signature, select Create new, add your name and the On the Rise logo, then select Save
Email your signature file to the IT help desk
What does Seroja need to do?
From Settings, select Out-of-Office AutoReply, type her subject and message, then select Out of Office AutoReply on
From Settings, select Out of office responder, type her subject and message, then select Out of office responder on
From Settings, select Forwarding and POP/IMAP, then select Vacation responder on
From Settings, select Vacation responder, then select Save
What does he need to do? Select TWO correct answers.
Create a new filter and select the action Always mark it as important
Create a filter and select enable automatic forwarding to messages received from Seroja Malone
Add Seroja Malone as an important personal contact
Kaina Gao wants to search for a message she sent to Anthony Dylan last May. She remembers the email related to a new store in Manila and included an attachment named "New Opportunities.pdf." What are some ways she can narrow her search in order to quickly find this email?
She can search for "sender: Anthony Dylan"
She can search for "Manila"
She can search for "New Opportunities.png"
She can search for "last May"
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
