Excel II

Excel II

Professional Development

14 Qs

Similar activities

Engaging Students Quiz

Engaging Students Quiz

Professional Development

15 Qs

Culture Week Quiz

Culture Week Quiz

Professional Development

15 Qs

Excel Imil Quiz

Excel Imil Quiz

Professional Development

11 Qs

Financeiro Quiz!

Financeiro Quiz!

Professional Development

15 Qs

Recapitulation Test

Recapitulation Test

Professional Development

12 Qs

Health Unit 1 Test

Health Unit 1 Test

5th Grade - Professional Development

18 Qs

Fun Quiz - WS

Fun Quiz - WS

Professional Development

15 Qs

Python Functions

Python Functions

Professional Development

9 Qs

Excel II

Excel II

Assessment

Quiz

Created by

Anastasia Frecautan

Other

Professional Development

2 plays

Medium

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function is case sensitive?

SEARCH

FIND

LEFT

SUM

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What function to use to get this ->55555 from the initial value -> 55555-End

LEFT

MID

RIGHT

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function uses delimiter as a parameter in its syntaxis?

&

CONCATENATE

CONCAT

TEXTJOIN

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In this image, which formula could you use to subtract the inventory costs from the monthly budget?

=B3-B2

=B3/B2

=SUM(B2:B3)

=B2-B3

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What formula would you use to find the average of the values in cell range A1 to A10?

=AVG(A1:A10)

=AVERAGE(A1:A10)

=TOTAL/A10

=MEAN(A1:A10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to add several numeric values?

COUNTA

TOTAL

SUM

AVERAGE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function can find the highest value in a cell range?

HIGHEST

MAX

MAXVALUE

TOP

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function can display a differnece value depending on a condition?

IF

AVERAGE

CONDITION

TEST

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =A1&" "&A2 do in Excel?

Adds the value in A2 to the value in A1

Combines the values in cells A1 and A2 into a single cell with a space between them


Multiplies the values in cells A1 and A2

Subtracts the value in A2 from the value in A1

10.

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","Low")

=IF(B4<200,"High","Low")

=IF(B4>200"High","")

Explore all questions with a free account

or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?