Microsoft Excel Quiz

Microsoft Excel Quiz

University

25 Qs

quiz-placeholder

Similar activities

EMBEDDED SYSTEM DESIGN

EMBEDDED SYSTEM DESIGN

University

20 Qs

BEEE Pre-test Assessment

BEEE Pre-test Assessment

University

20 Qs

Principal of marketing chapter 2

Principal of marketing chapter 2

University

20 Qs

15th Anniversary KIME FE UNNES

15th Anniversary KIME FE UNNES

University

20 Qs

UAS METOPEN

UAS METOPEN

University

20 Qs

Artificial Potential Field Method & Roadmaps

Artificial Potential Field Method & Roadmaps

University

20 Qs

Ultimate office trivia quiz

Ultimate office trivia quiz

KG - Professional Development

25 Qs

Consumer Behavior

Consumer Behavior

University

20 Qs

Microsoft Excel Quiz

Microsoft Excel Quiz

Assessment

Quiz

Other

University

Practice Problem

Medium

Created by

Ayush Tammannavar

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of Microsoft Excel?

Graphic design

Word processing

Data entry and analysis

Web development

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to search for a value in the first column of a table?

Aunty

SUMIF

VLOOKUP

HLOOKUP

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the syntax for the VLOOKUP function?

=LOOKUP(value, table, index)

=VLOOKUP(value, table, index, range)

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=VLOOKUP(lookup_value, table, index)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the HLOOKUP function do?

Searches vertically in a table

Searches horizontally in a table

Calculates the average of a range

Sorts data in ascending order

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a built-in function in Excel?

SUM

AVERAGE

VLOOKUP

CALCULATE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of Conditional Formatting in Excel?

To freeze panes

To format cells based on specific conditions

To sort data

To create charts

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the CONCATENATE function do?

Joins two or more text strings together

Counts the number of cells in a range

Calculates the sum of a range

Finds the maximum value in a range

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?