Google GSuite G Suite Exam Practice Test

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.

Change the fill color of the cells in the Tuesday and Thursday columns to any color of your choosing.

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

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 Employee Shift Schedule for Kelvin Cars, add a border to all the cells in range A10:S24.

Overview

In the following tasks, you will demonstrate your ability to work in Google Docs. Dream Digital Design is a web design company known for building exceptional websites. You will be editing the job description for the new web designer role that will open shortly. Use the Dream Digital Design Job Description for all the tasks in this scenario.

Leave a comment for Monica, monica@dreamdigitaldesign.com, next to the word Benefits. The comment should say Please confirm the list of benefits.

You just started your new job and received an email with a Getting Started manual attached. After a few weeks, you want to remove this email from your Gmail inbox but preserve it for future reference. What should you do?

A new customer asks you to send a Google Docs document to them as a Microsoft Word document. From the File menu of your Google Docs document, what action should you take?

You want to send login instructions, such as URL, username, and password, to a new external user. You want to email to be automatically deleted from the user's inbox in two days. What should you do?