Microsoft Excel 2021365 - Beginner to Advanced - The IF Function

Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the purpose of using the IF function in Excel?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
Explain the difference between typing formulas directly into a cell and using the Functions dialog box.
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
3 mins • 1 pt
What calculation is performed for orders over $1500 according to the text?
Evaluate responses using AI:
OFF
4.
OPEN ENDED QUESTION
3 mins • 1 pt
Why is it beneficial to use cell references instead of hard-coded numbers in formulas?
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
3 mins • 1 pt
How can you ensure that your formulas update automatically when a referenced value changes?
Evaluate responses using AI:
OFF
6.
OPEN ENDED QUESTION
3 mins • 1 pt
What happens to the shipping charge if the total cost is under $1500?
Evaluate responses using AI:
OFF
7.
OPEN ENDED QUESTION
3 mins • 1 pt
Describe the process of copying a formula down in Excel.
Evaluate responses using AI:
OFF
Similar Resources on Wayground
6 questions
The Complete Excel Guide: Beginners to Advanced - Overview of Formulas

Interactive video
•
University
2 questions
The Complete Excel Guide: Beginners to Advanced - Functions - Part 2

Interactive video
•
University
6 questions
Excel: Common Excel Functions

Interactive video
•
KG - University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Using the SWITCH Function

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Finding the Last Occurrence of a Value

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Finding the Last Occurrence of a Value

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information with VLOOKUP

Interactive video
•
University
5 questions
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information with VLOOKUP

Interactive video
•
University
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade