Excel IF and IF nested Functions/Formulas

Excel IF and IF nested Functions/Formulas

9th Grade

27 Qs

quiz-placeholder

Similar activities

Ôn tập excel 2010

Ôn tập excel 2010

7th - 11th Grade

25 Qs

OFİS PROGRAMLARI EXCEL

OFİS PROGRAMLARI EXCEL

9th Grade

25 Qs

Excel functions and formulas assessment

Excel functions and formulas assessment

9th - 11th Grade

25 Qs

TIN HỌC 7

TIN HỌC 7

9th Grade - University

22 Qs

Tin học 9 - Bài 10a, 11a, 12a

Tin học 9 - Bài 10a, 11a, 12a

9th Grade

25 Qs

ÔN TẬP TIN 7- GIỮA KI 1

ÔN TẬP TIN 7- GIỮA KI 1

8th - 12th Grade

25 Qs

Ôn tập lớp 7 - Phần 6 (Đề Cương Word Nghề)

Ôn tập lớp 7 - Phần 6 (Đề Cương Word Nghề)

KG - 12th Grade

25 Qs

Ms. Excel 2013

Ms. Excel 2013

7th - 10th Grade

25 Qs

Excel IF and IF nested Functions/Formulas

Excel IF and IF nested Functions/Formulas

Assessment

Quiz

Computers

9th Grade

Hard

Created by

Alex vZ

Used 5+ times

FREE Resource

27 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, what does the IF function allow you to do?
Perform calculations
Make conditional decisions
Create charts
Sort data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the basic syntax of the IF function in Excel?
IF(logical_test,value_if_true,value_if_false)
IF(logical_condition,value_if_true,value_if_false)
IF(condition,then_value,else_value)
IF(test,do_this,otherwise_do_that)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to check if a cell A1 is greater than 10 in Excel, which formula would you use?
=IF(A1>10,"Yes","No")
=IF(A1<10,"Yes","No")
=IF(A1=10,"Yes","No")
=IF(A1>=10,"Yes","No")

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the value_if_false argument in the IF function represent?
The action if the condition is true
The action if the condition is false
The logical test
The cell reference to check

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, if you want to nest multiple IF functions, what is the maximum number of IF functions you can nest?
5
10
15
20

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you express "If A1 is equal to B1 and B1 is equal to C1, then 'Yes'" using the IF function in Excel?
=IF(A1=B1=C1,"Yes","No")
=IF(A1=B1 AND B1=C1,"Yes","No")
=IF(A1=B1, B1=C1, "Yes","No")
=IF(A1=B1,"Yes",IF(B1=C1,"Yes","No"))

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the "value_if_true" argument in the IF function?
It specifies what to do if the condition is true
It specifies what to do if the condition is false
It specifies the logical test
It specifies the cell to check

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?