Excel Functions and Techniques Quiz

Excel Functions and Techniques Quiz

Professional Development

30 Qs

quiz-placeholder

Similar activities

Mangi lal Prajapat

Mangi lal Prajapat

Professional Development

30 Qs

L-50

L-50

Professional Development

33 Qs

Birth rate

Birth rate

Professional Development

26 Qs

xxxReady for IELTS 2nd ed. Unit 1: Writing Task 1

xxxReady for IELTS 2nd ed. Unit 1: Writing Task 1

12th Grade - Professional Development

25 Qs

test 8 ETS 2023

test 8 ETS 2023

Professional Development

29 Qs

Basic Computer MCQs

Basic Computer MCQs

Professional Development

28 Qs

Technical Paper Writing

Technical Paper Writing

Professional Development

30 Qs

IT Vocabulary

IT Vocabulary

Professional Development

31 Qs

Excel Functions and Techniques Quiz

Excel Functions and Techniques Quiz

Assessment

Quiz

English

Professional Development

Medium

Created by

sajjan yadav

Used 2+ times

FREE Resource

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to add values in Excel?

AVERAGE

SUM

ADD

TOTAL

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the `=MAX(A1:A10)` return?

Minimum value

Sum

Largest value

Count

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to count numeric values only?

COUNTA

COUNT

LEN

AVERAGE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the `=LEFT("Excel",2)` return?

"Ex"

"El"

"ce"

Error

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the use of `=TRIM()` function in Excel?

Text जोड़ने के लिए

Extra spaces हटाने के लिए

Text को छोटा करने के लिए

कुछ नहीं

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function returns today’s date?

NOW

DATE

TODAY

TIME

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to join texts?

CONCATENATE

SUM

JOIN

LINK

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?