Excel Functions and Techniques Quiz

Excel Functions and Techniques Quiz

Professional Development

30 Qs

quiz-placeholder

Similar activities

Computer History Quiz: The First Calculating Devices & Computers

Computer History Quiz: The First Calculating Devices & Computers

Professional Development

30 Qs

P&PB 2023 : QUIZ-9

P&PB 2023 : QUIZ-9

Professional Development

30 Qs

AWL 1 Review

AWL 1 Review

9th Grade - Professional Development

25 Qs

First Conditional - HR Theme

First Conditional - HR Theme

Professional Development

25 Qs

Scientific article

Scientific article

Professional Development

25 Qs

Data Warehousing and Data Mining Quiz

Data Warehousing and Data Mining Quiz

Professional Development

30 Qs

Kiểm tra từ vựng/ngữ pháp Unit 1

Kiểm tra từ vựng/ngữ pháp Unit 1

Professional Development

26 Qs

Teleco

Teleco

Professional Development

34 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?