GSuite G Suite Certification Questions and Answers

Overview

In the following tasks, you will demonstrate your ability to work in Google Sheets. You are organizing and analyzing the schedule of employee shifts. Use the Employee Shift Schedule for Kelvin Cars sheet for all the tasks in this scenario.

In the Total Shifts column, calculate the total number of shifts for each employee. Use a formula to perform the calculations.

Overview

Your company is offering a new summer discount for its customers. In the following questions, take actions to update the New Summer Sales Discount that your sale representatives will share with customers.

You are editing a document with information on this summer’s discounts. Open the New Summer Sales Discount document and change the line spacing in the Details section to single-spaced.

You need to find an audio file on Google Drive that your manager shared with you recently. You know that the type of file you are looking for is audio, and the owner of the file is lisa@kelvincars.com. What should you do to quickly find the file on Google Drive?

Overview

In the following tasks, you will demonstrate your ability to work in Google Docs. Cascara is a furniture wholesaler with warehouses located in Europe. You will be filling out a form to ship a load of goods to one of the warehouses. Use the Carriage of Goods by Road (CGR) for all the tasks in this scenario.

Insert the electronic signature, carrier_signature.png, in the cell titled, 17 Signature or stamp of the carrier.

Overview

As the new regional sales manager at Cuppa Coffee Company, your manager has asked you to review, update, and add to two existing Google Slides presentations. In the following questions, you will be editing presentations.

You need to edit an existing presentation all about your company, Cuppa Coffee Company. On the first slide of the Cuppa Coffee Company presentation, italicize the Consistently Quality Coffee text.

Overview

You have negotiated a new deal with a customer. You now want to finalize their contract with your company for an annual supply of coffee beans.

You want to add a table of contents to the Contract document that automatically updates when changes are made to the different section headers. Add a table of contents with page numbers to the beginning of the contract documents, directly under the title header Cuppa Coffee Company – Supplier Contract.

Overview

Your company is offering a new summer discount for its customers. In the following questions, take actions to update the New Summer Sales Discount that your sale representatives will share with customers.

You want to get feedback from two people on your team. In the New Summer Sales Discount document, give comment access to Sunanda Vaideesh and Jennifer Tollar.

Overview

In the following tasks, you will demonstrate your ability to work in Google Sheets. You are organizing and analyzing the schedule of employee shifts. Use the Employee Shift Schedule for Kelvin Cars sheet for all the tasks in this scenario.

Filter the table so that only shifts with “brakes” assignments are viewable.

Your Team Drive has over 7,000 images and PDF files. For a meeting you have in 10 minutes, your manager asks you for all the JPG and PDF marketing flyer files the company has created. You need to find these files before your meeting. What should you do?

Overview

In the following tasks, you will demonstrate your ability to work in Google Docs. Lodge Majestique is a prominent vacation destination known for its great customer service. You will be finalizing a training guide for the Lodge Majestique Front Desk. Use the Front Desk: Training Guide | Module 1 for all the tasks in this scenario.

On page 2 of the training guide, make the Training Objectives title bold.

Your manager is working from a different office today during your regularly scheduled weekly meeting. You want to schedule a Google Hangouts video call to meet virtually. What should you do?