Google Sheets for Beginners

Data Analytics for Beginner

Word Cloud

Write down with 1 - 2 words about data analytics?

Directions:

Watch the video, then advance the slide to answer a question about it!

Multiple Choice

B1 is called

• Row

• Cell

• Column

• Sheet

Multiple Choice

A Sheets document is called a?

• Work page

• Work paper

• Spreadsheet

• Slide

Multiple Choice

What is the name of a vertical section of a spreadsheet as selected in the image?

• Row

• Cell

• Column

• Format

Multiple Choice

What is the name of this cell?

• B10

• 5B

• B5

• You cannot know the name from this picture

Multiple Choice

You can not adjust a row height or column width.

• True

• False

Multiple Choice

All formulas in Google sheets begin with the following symbol:

• +

• -

• =

• %

Multiple Choice

If I want to make a cell a particular color, which button would I click on?

• Format tab

• Font style

• Text color

• Fill color

Multiple Choice

It is possible to insert images in Google Sheets

• True

• False

Multiple Choice

Which of the following is a correctly named cell?

• 8B
• B8
• 8-B
• BB-8

Multiple Choice

Rows are labeled by __________.

• numbers
• letters
• symbols
• colors

Multiple Choice

Columns are labeled by ______________.

• numbers
• letters
• symbols
• colors

Multiple Choice

Text wrapping in Sheets means the text will be on more than 1 line within the same cell.

• True

• False

Multiple Choice

If I want to add a Chart, one way is to select the ____________ tab.

• Home

• Insert

• Page

• Data

Multiple Select

Google Sheets is used to?

• Add numbers.

• Make charts (graphs).

• Put information in columns and rows.

• Collect Data

Congratulations!

You have finished the Google Sheet Crash Course:)

Open Ended

Your assignment right now is

1. 1. Open your google spreadsheet.

2. 2. Share your google spreadsheet

3. "Share -> General Access (Anyone with the link -- Editor) -> Copy link

3. 3. Paste the link in this response box

"Learn this tutorial for create dashboard, it can be used for visualization your data"

CLICK THIS BUTTON