wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Functions Quiz

Total questions: 50

Worksheet time: 30mins

Name
Class
Date
1.

Which function returns TRUE only if all conditions are TRUE?

a)

IF

b)

AND

c)

OR

d)

NOT

2.

Which function returns TRUE if at least one condition is TRUE?

a)

AND

b)

OR

c)

IF

d)

NOT

3.

Which function reverses TRUE to FALSE?

a)

AND

b)

OR

c)

NOT

d)

IF

4.

Which function converts text to uppercase?

a)

LOWER

b)

PROPER

c)

UPPER

d)

TEXT

5.

Which function converts text to lowercase?

a)

LOWER

b)

UPPER

c)

PROPER

d)

TEXT

6.

Which function capitalizes the first letter of each word?

a)

UPPER

b)

LOWER

c)

PROPER

d)

CAPITAL

7.

Which function joins text from multiple cells?

a)

JOIN

b)

MERGE

c)

CONCATENATE

d)

LINK

8.

What does ISNUMBER return if a cell contains a number?

a)

TRUE

b)

FALSE

c)

TEXT

d)

ERROR

9.

Which function checks if a cell contains text?

a)

ISNUMBER

b)

ISTEXT

c)

TEXT

d)

CHECK

10.

Which function returns TRUE for even numbers?

a)

ISODD

b)

ISEVEN

c)

MOD

d)

ROUND

11.

Which function returns TRUE for odd numbers?

a)

ISEVEN

b)

ISODD

c)

MOD

d)

INT

12.

IF(A1>50,"Pass","Fail") returns Pass when:

a)

A150

b)

A1 is text

13.

AND(TRUE,FALSE) returns:

a)

TRUE

b)

FALSE

c)

0

d)

1

14.

OR(FALSE,FALSE) returns:

a)

TRUE

b)

FALSE

c)

0

d)

ERROR

15.

NOT(TRUE) returns:

a)

TRUE

b)

FALSE

c)

1

d)

0

16.

UPPER("excel") returns:

a)

Excel

b)

EXCEL

c)

excel

d)

ExCeL

17.

LOWER("Excel") returns:

a)

EXCEL

b)

excel

c)

ExCeL

d)

ERROR

18.

PROPER("data science") returns:

a)

Data science

b)

Data Science

c)

DATA SCIENCE

d)

data Science

19.

ISNUMBER("100") returns:

a)

TRUE

b)

FALSE

c)

ERROR

d)

TEXT

20.

ISTEXT(100) returns:

a)

TRUE

b)

FALSE

c)

ERROR

d)

0

21.

Which function returns TRUE only if all conditions are TRUE?

a)

IF

b)

AND

c)

OR

d)

NOT

22.

Which function returns TRUE if at least one condition is TRUE?

a)

AND

b)

OR

c)

IF

d)

NOT

23.

Which function reverses TRUE to FALSE?

a)

AND

b)

OR

c)

NOT

d)

IF

24.

Which function converts text to uppercase?

a)

LOWER

b)

PROPER

c)

UPPER

d)

TEXT

25.

Which function converts text to lowercase?

a)

LOWER

b)

UPPER

c)

PROPER

d)

TEXT

26.

Which function capitalizes the first letter of each word?

a)

UPPER

b)

LOWER

c)

PROPER

d)

CAPITAL

27.

Which function joins text from multiple cells?

a)

JOIN

b)

MERGE

c)

CONCATENATE

d)

LINK

28.

What does ISNUMBER return if a cell contains a number?

a)

TRUE

b)

FALSE

c)

TEXT

d)

ERROR

29.

Which function checks if a cell contains text?

a)

ISNUMBER

b)

ISTEXT

c)

TEXT

d)

CHECK

30.

Which function returns TRUE for even numbers?

a)

ISODD

b)

ISEVEN

c)

MOD

d)

ROUND

31.

Which function returns TRUE for odd numbers?

a)

ISEVEN

b)

ISODD

c)

MOD

d)

INT

32.

IF(A1>50,"Pass","Fail") returns Pass when:

a)

A150

b)

A1 is text

33.

AND(TRUE,FALSE) returns:

a)

TRUE

b)

FALSE

c)

0

d)

1

34.

OR(FALSE,FALSE) returns:

a)

TRUE

b)

FALSE

c)

0

d)

ERROR

35.

NOT(TRUE) returns:

a)

TRUE

b)

FALSE

c)

1

d)

0

36.

UPPER("excel") returns:

a)

Excel

b)

EXCEL

c)

excel

d)

ExCeL

37.

LOWER("Excel") returns:

a)

EXCEL

b)

excel

c)

ExCeL

d)

ERROR

38.

PROPER("data science") returns:

a)

Data science

b)

Data Science

c)

DATA SCIENCE

d)

data Science

39.

ISNUMBER("100") returns:

a)

TRUE

b)

FALSE

c)

ERROR

d)

TEXT

40.

ISTEXT(100) returns:

a)

TRUE

b)

FALSE

c)

ERROR

d)

0

41.

Write an Excel function that returns TRUE if A1 > 100, otherwise FALSE.

4 lines
42.

Complete the function to check if A1 > 50 AND B1 < 20.

4 lines
43.

Complete the function to convert the text in A1 to uppercase.

4 lines
44.

Complete the function to convert the text in A1 to lowercase.

4 lines
45.

Complete the function to capitalize the first letter of each word in A1.

4 lines
46.

Complete the function to join text in A1 and B1.

4 lines
47.

Complete the function to check if the value in A1 is a number.

4 lines
48.

Complete the function to check if the value in A1 is text.

4 lines
49.

Complete the function to check if the value in A1 is an even number.

4 lines
50.

Complete the function to check if the value in A1 is an odd number.

4 lines

Similar Resources on Wayground

Year 11 January Recap

50 questions

Year 11 January Recap

quiz

Worksheet

•

University

แบบทดสอบกลางภาค access

52 questions

แบบทดสอบกลางภาค access

quiz

Worksheet

•

KG - University

COMBINATIONAL DIGITAL CIRCUITS

55 questions

COMBINATIONAL DIGITAL CIRCUITS

quiz

Worksheet

•

University

LATIHAN UNBK TKJ 2020

50 questions

LATIHAN UNBK TKJ 2020

quiz

Worksheet

•

University

LATIHAN SOAL

50 questions

LATIHAN SOAL

quiz

Worksheet

•

10th Grade - University

Presentaciones de Google

48 questions

Presentaciones de Google

quiz

Worksheet

•

KG - Professional Dev...

Midterm Exam for AST 122

50 questions

Midterm Exam for AST 122

quiz

Worksheet

•

University

CCNA 2 Module 1-4

51 questions

CCNA 2 Module 1-4

quiz

Worksheet

•

University