How to Use the 'AND' Function in Microsoft Excel

How to Use the 'AND' Function in Microsoft Excel

Assessment

Interactive Video

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

KG - University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how to use the AND function in Microsoft Excel to determine if students pass based on their grades. It covers setting up a scenario where students need at least 60% in two exams to pass, building a formula using the IF and AND functions, and applying it to check grades. The tutorial also discusses the logic behind the formula and its flexibility for different checks.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF