Google Sheets Coursera Quiz Answers – Networking Funda

Get All Weeks Google Sheets Coursera Quiz Answers

In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace.

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.

You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types.

Enroll on Coursera

Week 01: Google Sheets Coursera Quiz Answers

Quiz 01 : Introduction to Google Sheets

Q1. On the Rise store owner Yousef Amadi wants to create an inventory sheet for his employees. How does he create a new Google Sheets spreadsheet? Select all that apply.

  • Go to Google Drive, select New, then select Google Sheets
  • Type sheets.new in the browser address bar
  • Go to googlesheets.com

Q2. Yousef has a series of spreadsheets that he has created in Microsoft Excel. Which of the following statements are true? Select all that apply.

  • Yousef can upload Microsoft Excel spreadsheets to Google Drive
  • Yousef must save his Microsoft Excel spreadsheets as Google Sheets in order to edit them
  • Yousef can view Microsoft Excel spreadsheets using Google Sheets

Quiz 02 : Manage data using Google Sheets

Q1. On the Rise partner owner Thomas Omar is reviewing a Google Sheet named “On the Rise Monthly Sales Figures.” He’d like to better analyze the data by filtering the data. What does he need to do?

  • Select one or more cells, open the Data menu, hover over Filter views, then select Create a new filter view
  • Select the Filter menu, choose a range of cells, then select Create a filter.
  • Open the Data menu, select Sort cells, then select Create a filter

Q2. Now, Thomas wants to add some data to the Sheet. What are some of his options? Select all that apply.

  • Copy and paste it from another spreadsheet
  • Paste it from within the same Google Sheet
  • Manually add the data
  • Import it from a Microsoft Excel file

Quiz 03 : Format a Google Sheets spreadsheet

Q1. Anthony Dylan is working on a Google Sheet that includes many long text strings. He notices that the text keeps overflowing onto the adjacent cell. How can he format his Sheet in order to fix this issue?

  • He can select Rotate text
  • He can select Merge cells
  • He can select Text wrapping
  • He can select Text alignment

Q2. Seroja wants her Sheet to include a header row that does not move when viewers scroll through the spreadsheet. How does she set this up?

  • She can select the row she wants, open the View menu, then choose Text wrapping
  • She can select the row she wants, then select Conditional Formatting, then make a rule Except this row
  • She can select the row she wants, open the View menu, the choose Except certain cells
  • She can select the row she wants, open the View menu, then choose Freeze and 1 row

Quiz 04 : Basic formulas, functions, and charts

Q1. Thomas Omar is working on a Google Sheet with sales data from On the Rise stores in the Asia Pacific region. He’d like to see an average sale price. This data is found in cells J3 through J44. Which of the following formulas should he use?

  • =AVERAGE(J3:J44)
  • =SUM(J3:J44)
  • =AVERAGE(J3-J44)
  • AVERAGE(J3:J44)

Quiz 05 : Share your Google Sheets spreadsheets

Q1. Thomas wants to share a Google Sheets spreadsheet with On the Rise store owner Yousef Amadi. He’d like him to be able to download and print the file but not make any changes. What type of collaborator role should he assign to him?

  • Owner
  • Editor
  • Viewer
  • Suggester

Q2. Seroja makes some changes in “On the Rise marketing data,” but later decides she’d like to return to the version shared by Kaina Gao. What does she need to do?

  • Check her email for the older version
  • Ask her IT person to restore a backup of the Sheet
  • Select File, Version history, then See version history, choose the version from the correct point in time, and then select Restore this version
  • Go to Trash and restore the older version

Quiz 06 : Collaborate with Google Sheets

Q1. Kaina Gao would like to assign an action item to Anthony Dylan. What does she need to do? Select all that apply.

  • [email protected], then check Assign to Anthony Dylan
  • @[email protected], then check Assign to Anthony Dylan
  • %AnthonyDylan, then check Assign to Anthony Dylan
  • Send Anthony Dylan the Google Sheet link, then check Assign to Anthony Dylan

Q2. Thomas is reviewing a Google Sheet named “On the Rise forecast report.” He’d like to leave a comment on cell A22. What does he need to do?

  • Place his cursor on cell A22, select Add a comment, type his comment, and select Comment
  • Select More options, select Add a comment, type his comment, and select Comment
  • Place his cursor on cell A22, select Link to comment, type his comment, and select Comment
  • Select Share, select Add a comment, type his comment, and select Comment

Q3. Anthony is working on the Google Sheet when he notices that Sherrie is online as well. Anthony would like clarification regarding a few comments that Sherrie has left him. What is the best way for Anthony to collaborate with Sherrie?

  • Send Sherrie a Gmail message with his question
  • Send Sherrie a dynamic email using Gmail
  • Use Google Chat to message her directly in the Google Sheet
  • Reply to each comment directly in the Google Sheet
Conclusion:

I hope this Google Sheets Coursera Quiz Answers would be useful for you to learn something new from the Course. If it helped you, don’t forget to bookmark our site for more Quiz Answers.

This course is intended for audiences of all experiences who are interested in learning about new skills in a business context; there are no prerequisite courses.

Keep Learning!

Get All Course Quiz Answers of Getting started with Google Workspace Specialization

Gmail Coursera Quiz Answers

Google Calendar Coursera Quiz Answers

Google Drive Coursera Quiz Answers

Google Docs Coursera Quiz Answers

Google Sheets Coursera Quiz Answers

Google Slides Coursera Quiz Answers

Google Meet and Google Chat Coursera Quiz Answers

Google Sheets – Advanced Topics Coursera Quiz Answers

Leave a Reply

Your email address will not be published.

error: Content is protected !!