Platform Banner

Forms - "Answers" tab – process the responses collected through your form or quiz Tutorial

Unlock the power of your data with our guide on the 'answers' tab in Microsoft Forms! Discover how to view and analyze responses in real-time with Excel integration. Learn to navigate participant results and streamline data management. Perfect for anyone looking to enhance their data discovery skills! Don't miss out on this essential tool to optimize your forms!

01:54
77 views

Available in Microsoft365

00:00:06

all the responses collected through your Microsoft Forms forms

00:00:11

and how to use real-time synchronization with Excel

00:00:14

to analyze your data more easily.

00:00:17

Click on view responses

00:00:19

at the top of your form.

00:00:21

This tab provides an overview of the responses collected.

00:00:24

In this tab you can view

00:00:26

number of responses,

00:00:28

how many people responded.

00:00:30

Average duration,

00:00:32

average time to complete the form.

00:00:35

Form status

00:00:37

active or not indicating whether new responses are possible.

00:00:41

To examine a participant,

00:00:43

click on check individual results,

00:00:46

navigate between the answers with the arrows.

00:00:49

You'll see

00:00:51

respondent's name,

00:00:52

if enabled,

00:00:53

time taken to respond.

00:00:55

summary of responses

00:00:57

in the three dots you can

00:01:00

delete,

00:01:00

reply,

00:01:02

or print it.

00:01:03

From the previous menu select open results in Excel.

00:01:08

This creates an Excel file in OneDrive

00:01:10

with all the answers in a table format.

00:01:13

New answers are automatically added to the Excel file on the web.

00:01:18

This feature simplifies the analysis and automatic processing of data.

00:01:24

In the three dots you can

00:01:26

delete all answers,

00:01:28

start from scratch if necessary,

00:01:30

print summary,

00:01:32

printable document of the answers,

00:01:34

share a link to results,

00:01:37

view by others without editing.

00:01:39

Now you know how to view and process

00:01:41

the responses collected for your Microsoft Forms forms.

00:01:46

With real-time synchronization with Excel,

00:01:49

you can analyze and manage your data more efficiently.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

53 Views

E-learning Débutant

Video Training Microsoft Forms - Discovery

Easily create online forms and questionnaires with Microsoft Forms to collect, analyze, and share responses with ease.

ALL COURSES