Creating a People Graph in Microsoft Excel

Creating a People Graph in Microsoft Excel

Assessment

Interactive Video

Other, Social Studies, Information Technology (IT), Architecture

KG - University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial demonstrates how to create a People Graph in Microsoft Excel. It covers the necessary data setup, inserting the graph, configuring data and titles, customizing the graph's appearance, and exporting it as an image for use in other applications like Word or PowerPoint.

Read more

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the two columns of data needed to create a people graph in Excel?

Titles and descriptions

Categories and numbers

Names and dates

Labels and values

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where can you find the option to insert a people graph in Excel?

Within the Home tab

Inside the View tab

Under the Data menu

In the Insert menu

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step after inserting a people graph template?

Add a new column

Adjust the graph's size

Select the data for the graph

Change the graph's color

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following can you change in the graph's settings?

The graph's type, theme, and shape

The graph's title, axis, and legend

The graph's border, alignment, and spacing

The graph's font, size, and color

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you use the completed graph in other applications?

By saving it as a PDF

By exporting it as a CSV file

By copying and pasting it as an image

By embedding it as a link