Font size
WorksheetsGoogle Workspace(Drive, Docs, Meet, Chat, Sheet Advanced))
Total questions: 66
Worksheet time: 33mins
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.
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 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
Câu 25: 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
Câu 26: 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
Câu 27: What is the name of Google's video software tool?
Google Spaces
Google View
Google Lens
Google Meet
Câu 28: 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
Câu 29: 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
Câu 30: 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
Câu 31: 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
Câu 32: 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
Câu 33: 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
Câu 34: 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
Câu 35: 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
Câu 36: 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
Câu 37: 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
Câu 38: 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
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 D
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, 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
Anthony Dylan has an On the Rise folder saved in his My Drive. He decides to invite Sherrie West and Seroja Malone to access the folder. Who now owns the content found in the folder?
Seroja Malone
Anthony Dylan
The group
Sherrie West
Sherrie West has On the Rise employee files saved in her My Drive. What can she as the owner do with these files? Select all that apply.
She can move the files
She can add collaborators
She can delete the files and restore them from the trash
She can share a file link
Seroja Malone gives her head baker access to the 'French baguette' file. She assigns the baker as an Editor. Which of the following can he do? Select all that apply.
He can edit the file
He can permanently delete the file
He can view the folder where the file is stored
He can view the file
Seroja Malone has just added the file 'French baguette' to her On the Rise recipes folder, stored in her My Drive. Sherrie West has Viewer permissions to the folder. What can she do to the 'French baguette' file?
She can move the file
She can delete the file
She can change permissions to the file
She can view the file
Kaina Gao is working on a new file called 'Bakery Trends', located in her My Drive 'OTR Marketing' folder. How can she add a shortcut back to her 'Conference Notes' folder in her My Drive?
She can select the file and press CTRL+S to create a shortcut
She can select New, then select Shortcut
She can right-click on the Bakery Trends file, select Organize, then Add shortcut. She can select the Conference Notes folder location when prompted, then select Add.
She can drag the file to the Conference Notes folder
Sherrie West needs to search for an On the Rise Google Sheet in her My Drive. Unfortunately, she can't remember the name of the file. What are some ways she can narrow her search? Select all that apply.
She can manually search by content type
She can manually search by recent collaborators
She can right-click on the folder where the file is stored, select Folder information, and then select Search within
She can select Advanced search and choose a date range
Kaina Gao wants to create a new folder in her My Drive to store all her conference handouts and personal notes. How does she do this? Select all that apply.
Open Drive, select the My Drive label, right-click on an open spot in the file list, and select New folder from the menu
Open Drive, select the My Drive label, then choose More, then choose New folder
Open Drive, select the My Drive label, then select New and choose Folder from the menu
Open Drive, select New, then choose My Drive
Why should Sherrie West move her file 'On the Rise employee onboarding' to the shared drive instead of keeping it in her My Drive? Select all that apply.
This way the file is owned by everyone in the shared drive
This way the file is available even if Sherrie leaves the company
It's necessary because the file can't be shared with the team from My Drive
How can Thomas Omar delete old files from the 'Conference material' folder in the shared drive? Select all that apply.
He can drag all the files to the Trash
He can select the files, and then select Move to trash
He can't delete files from a shared drive
How can Sherrie West set up her Google Drive to only see the shared drives she uses most often?
Select My Drive, then select Hide shared drive from the menu
Select Manage Drives, then select the shared drives she wishes to hide
Right-click on the shared drives she does not use and select Hide shared drive from the menu
How can Seroja Malone use the 'On the Rise' Google Docs template created by Sherrie West?
Select New, Google Docs, then From a Template, then choose the On the Rise template
Have Sherrie share the link to the original doc with her
Search Google Drive for 'templates' plus the name of the file Sherrie created
Type the address of the template in the browser address bar
How can Sherrie West create a reusable template for On the Rise job postings in Google Docs?
Create and edit a Google Doc called OTR Job Posting, then use the shared link to create a new version of the doc
Create a Google Doc OTR Job Posting to use as the template, then open the template gallery for Google Docs, select On the Rise, then choose Submit template
Email the template to the address templates@googledrive.com
Upload the file at drive.google.com/newtemplate
How can Seroja Malone make her 'Ingredient list' Google Sheet available for offline viewing?
She can open the file 'Ingredient list', then right-click and choose Available offline
She can select Tools, then select Available offline
She can right-click on 'Ingredient list' from the files list and select Available offline
She can go to her Google Drive settings, find the 'Ingredient list' file, and select Available offline
