
"If Function" Excel Quiz

Quiz
•
Computers, Professional Development, Education
•
6th Grade - Professional Development
•
Hard
Rotary RECB3190
Used 14+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is the correct formula for the IF function in Excel?
IF (logical_test, value_if_true, value_if_false)
=IF (logical_test, value_if_true, value_if_false)
=(logical_test, value_if_true, value_if_false)
None of the above
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')
Pass
Fail
68
None of the above
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"
=IF(B4>200,"High","Low")
=IF(B4>200"High","")
IF(B4>200,"High","Low")
=IF(B4<200,"High","Low")
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
In an IF function, what symbols need to be around text that you want to show up as the true or false of the condition
parenthesis ( )
quotation marks " "
nothing
Option 'A' and 'B'
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
AND
OR
IF
NOT
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following is correct syntax in Excel?
=IF(LogicalTest, TrueResult, FalseResult)
=IF(LogicalTest, (TrueResult, FalseResult))
=IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
=IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following statements are TRUE?
You use SUMIFs to count cells based on specified ranges and criteria.
You have to first use an IF statement in a worksheet before you can use SUMIFs or COUNTIFs.
You use COUNTIFs to count the number of cells specified by a given set of conditions or criteria.
None of the options listed above are correct.
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
2.11 Other Processing Methods 2

Quiz
•
9th Grade
10 questions
data verification and validations

Quiz
•
5th - 8th Grade
11 questions
Coding Basics in Swift

Quiz
•
7th Grade
10 questions
Grade 11 - Python Conditions

Quiz
•
11th Grade
7 questions
BÀI 12a. SỬ DỤNG HÀM IF

Quiz
•
9th Grade
15 questions
BASIC C PROGRAMMING

Quiz
•
University
15 questions
G-8-Python Basics Quiz

Quiz
•
8th Grade
10 questions
Excel

Quiz
•
8th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
8 questions
Time Management

Quiz
•
6th Grade
18 questions
Digital Footprint

Quiz
•
6th Grade
20 questions
typing

Quiz
•
6th Grade
18 questions
Company Logos

Quiz
•
6th - 8th Grade
20 questions
Analog vs Digital

Quiz
•
9th - 12th Grade
10 questions
CTEA Computer Vocab Terms #1

Quiz
•
12th Grade
10 questions
Exploring Cybersecurity Techniques and Threats

Interactive video
•
6th - 10th Grade