Font size
WorksheetsGoogle Workspace (Gmail, Calendar, Sheet, Slide, Sheet advand)
Total questions: 66
Worksheet time: 33mins
Sherrie wants to email a very large file to her team. 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
Sherrie West is busy at work when she receives an email from a store owner. She doesn't have time to write back immediately, but she also doesn't want to forget to respond later. What can she do? Select all that apply.
Snooze the email
Apply her custom label "Follow Up"
Schedule a response
Star the email
Sherrie and her team are about to send out a survey to On the Rise store employees. Sherrie wants to keep their feedback organized in her Inbox by creating a project label named "OTR Survey Feedback." 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
Sherrie is active in numerous On the Rise Google groups. She often receives notification emails. Sherrie decides to enable categories to better manage her Inbox. In which category will she now find messages from her Google groups?
Social
Forums
Promotions
Updates
Thomas Omar wants to email a confidential financial statement to his head office team. The document is stored in his personal Google Drive. Thomas wants his team to be able to read the document, but otherwise not alter it in any way. Which of the following share settings should he select?
Comment
Edit
View
Turn on Link Sharing
On the Rise store owner, Yousef Amadi, is responsible for three separate bakery locations. In order to manage his workload, he uses a task list to keep track of what needs to get done. He adds the task "Email Anthony Dylan Wastage Report." 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
On the Rise store owner, Yousef Amadi, is piloting a new Point of Sale (POS) system at one of his locations. The system automatically sends him daily reports, yet these reports are automatically filtered as Spam. 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
Anthony Dylan is in negotiations with a new distributor. He sends the distributor an email using confidential mode and sets the email expiration date for one week's time. The next day, Seroja Malone asks Anthony to revoke the distributor's access to the email. 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
Sherrie West often intends to email Thomas Omar, yet when she starts to type, her "To:" field in Gmail automatically populates with the name "Thomas O'Malley". This name is only replaced by "Thomas Omar" once Sherrie reaches the fourth letter of his family name. Sherrie has accidentally sent Thomas O'Malley three emails meant for Thomas Omar. 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
Sherrie West is creating an onboarding package for new On the Rise hires. One of the important steps is getting staff set up with their Gmail account, which includes adding a personalized signature line. 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
Seroja Malone is traveling to Italy next week to meet with a new cinnamon distributor. She knows she will have limited access to her Gmail account and wants to set an Out-of-Office AutoReply while she is out of office. 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
Anthony Dylan occasionally receives emails from On the Rise partner owner, Seroja Malone. Anthony wants to ensure that Seroja's messages are automatically labeled as important in his Inbox. 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
Open message from Seroja Malone and click to enable the important marker to the left of the label
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"
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
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
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. 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
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
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
