Excel II

Excel II

Professional Development

14 Qs

quiz-placeholder

Similar activities

BUGÜN NE ÖĞRENDİM ? / 1 MART 2024

BUGÜN NE ÖĞRENDİM ? / 1 MART 2024

Professional Development

11 Qs

Formula One Kelenge?

Formula One Kelenge?

Professional Development

10 Qs

Recapitulation Test

Recapitulation Test

Professional Development

12 Qs

EXCEL BASIC - 02

EXCEL BASIC - 02

Professional Development

10 Qs

Spanish Quizzez

Spanish Quizzez

Professional Development

13 Qs

CEAC_U04

CEAC_U04

Professional Development

15 Qs

1. Fórmulas en Hoja de cálculo

1. Fórmulas en Hoja de cálculo

Professional Development

11 Qs

Prueba de log mat handler

Prueba de log mat handler

Professional Development

12 Qs

Excel II

Excel II

Assessment

Quiz

Other

Professional Development

Medium

Created by

Anastasia Frecautan

Used 2+ times

FREE Resource

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

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?