Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - apply logical functions

Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - apply logical functions

Assessment

Interactive Video

Information Technology (IT), Architecture, Physical Ed

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial covers logical functions, focusing on nested Ifs and the IFS function to calculate prize money. It also explores COUNTIF and SUMIF functions to analyze data based on various criteria. The tutorial provides step-by-step solutions for exercises, demonstrating how to lock cell references and use multiple criteria in formulas.

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