Creating Multi-Line Graphs in Google Sheets

Creating Multi-Line Graphs in Google Sheets

Assessment

Interactive Video

Computers

9th - 10th Grade

Hard

Created by

Jennifer Brown

FREE Resource

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step in setting up the spreadsheet for creating a multi-line graph?

Create a new Google Sheet

Copy data from the internet

Replace placeholder company names with actual ones

Insert a chart

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which option should you select to ensure the correct data is transferred when pasting?

Paste Values Only

Paste Special

Paste

Paste Format

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What should you do if the inserted chart is not the type you want?

Delete the chart and start over

Save and refresh the page

Change the chart type to a multi-line graph

Adjust the data range

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you change the title of the graph?

Double-click on the title

Use the 'Format' menu

Select 'Chart Options'

Right-click and select 'Edit Title'

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of creating a second graph in the tutorial?

To compare different chart types

To show the return on investment for the companies

To practice inserting charts

To display data in a pie chart