Google GSuite GSUITE Questions & Answers

• Question 21:

  SIMULATION 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.

  A. See explanation below.

  Correct Answer: A

• Question 22:

  

  SIMULATION

  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.

  A. See explanation below.

  Correct Answer: A

  

  

  

• Question 23:

  SIMULATION

  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.

  

  

  In the table in section 2D ORDER DETAILS of the Contract document, add a new column titled Total Price. Leave the cells below the title blank.

  A. See explanation below.

  Correct Answer: A

  

  

• Question 24:

  SIMULATION 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.

  

  

  In the table in section 2D ORDER DETAILS of the Contract document, all of the content is center-aligned. Update the alignment of all content in the table to be left-aligned.

  A. See explanation below.

  Correct Answer: A

  

  

  

• Question 25:

  SIMULATION 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.

  A. See explanation below.

  Correct Answer: A

  

  

• Question 26:

  SIMULATION 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 before you present an update to your managers. Open the Sales Update presentation and add the Company Logo.jpg image to the first slide. You may place the logo anywhere you like on the slide and leave it any size.

  A. See explanation below.

  Correct Answer: A

  

• Question 27:

  SIMULATION

  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 want to show the percentage of new customers by location. Open the Sales Update presentation. On the Customers by Location slide, add a pie chart using the data below.

  Data:

  Region 1:25%

  Region 2:5%

  Region 3:20%

  Region 4:20%

  Region 5:30%

  A. See explanation below.

  Correct Answer: A

  

  

• Question 28:

  SIMULATION

  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.

  

  Change the line spacing of the Dream Digital Design Job Description from 1.5 to single spacing.

  A. See explanation below.

  Correct Answer: A

  

• Question 29:

  SIMULATION

  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.

  A. See explanation below.

  Correct Answer: A

  

  

• Question 30:

  SIMULATION 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.

  

  

  On the Contract document, change the top and bottom margins to 0.5 inches.

  A. See explanation below.

  Correct Answer: A