Google 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?

You received an email request that you want to respond to next week. For you to remember about this request, you need to have this email on top of your inbox next Monday at 9:30 AM. What should you do?

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?