Microsoft Excel 2021365 - Beginner to Advanced - The IF Function

Microsoft Excel 2021365 - Beginner to Advanced - The IF Function

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial explains how to use the IF function in Excel, both by typing directly into cells and using the Functions dialog box. It covers setting up a data set of furniture sales, creating an IF formula to calculate shipping charges based on total cost, and ensuring efficiency by using cell references. The tutorial emphasizes the importance of avoiding hard coding numbers and demonstrates how to apply and copy formulas efficiently.

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