The Certification Challenge

Scenario 1 -Sheets

In this task you will demonstrate your ability to work in Google Sheets

Use the Scenario 1 Sheet for this scenario

Tasks

1. Make the information in the table more readable by applying alternating colors to the rows. Use any default style of your choosing.

2. Merge the cells in the top row of the table, in the B1:I1 cell range.

3. You want to know how expensive, on average, online courses are per person. Use a formula and values in cells E6:E14 to calculate the average cost of online courses per person. Add your formula to cell E15.

4. Format all the numbers in column H, Total Cost, as currency rounded to the nearest dollar.

5. You want to know the total cost of customer support training per year. Calculate the total cost of training using a formula. Add your formula to cell H15.

6. It is important for at least 100 agents to take online modules. In the I6:I14 cell range, set a warning message if the number in the range is different from 100.

Scenario 2 - Docs

In this task you will demonstrate your ability to work in Google Docs

Use the Scenario 2 document for this scenario.

Tasks

1. Change the orientation of the page from landscape to portrait.

2. Change the background color of the page to white.

3. Change the heading text "Call Assist Plus offers" to the Heading 1 style

4. Format the text under "Call Assist Plus offers" to a bulleted list.

5. Merge the 2 cells in the first row of the table containing the following text: Call Assist Plus software summarizes the customer issue.

6. Remove the border from the table in the document.

7. Add this image to the cell that contains the following text: “Refer to a relevant article on Knowledge Base”.

Scenario 3 - Slides

In this task you will demonstrate your ability to work in Google Slides

Use the Scenario 3 document for this scenario

Tasks

1. Make this Slides presentation available offline

2. Share this file with lisa@gafe.me, as a commenter

3. Add a new slide (slide 4) based on the layout of slides 2 and 3

4. Add information to this new slide about koalas

5. Insert a picture of a koala by searching the web

6. On the Wombat slide, crop the image to remove the empty grass area on the right. Resize the cropped image to better fit the space.

7. Change the background on all slides to a light yellow linear gradient

8. Delete the "Australian Animals" text on the Title slide and replace it with a WordArt version instead. Make the WordArt text light green with a 3pt black outline, using Anton font.

9. Change the slide transition to Fade and apply to all slides

10. Download a copy of the presentation as a PDF file

11. Publish the finished slide presentation to the web. Set the slides to automatically advance every 5 seconds, start the slide show as soon as the player loads, and restart after the last slide

Scenario 4 - Drive

In this task you will demonstrate your ability to work in Google Drive

Tasks

1. Open your own Google Drive

2. Create a new folder titled "Skill test". Open that folder

3. Create a new Google Drawing in this folder, with the filename "Flowchart". Once you create the file, close it. No need to actually add content to it.

4. Create a new folder inside "Skill test", called "Samples". Move the Flowchart file into this new folder.

5. Change the share setting on the Samples folder to "Anyone with the link can view"

6. Change the colour of the Skill Test folder to light green and add a Star. Change the colour of the Samples folder to red

7. Change your Drive settings so that any new file that gets added is automaticlly converted to Google Docs format

Scenario 5 - Gmail

Coming soon!