Microsoft Excel Quiz

Microsoft Excel Quiz

University

25 Qs

quiz-placeholder

Similar activities

Quiz No. 1_EA

Quiz No. 1_EA

University

20 Qs

Microsoft Week 23 PA Wrap Up!

Microsoft Week 23 PA Wrap Up!

University

20 Qs

2p-WTO & OPEC_Int.Org._2024

2p-WTO & OPEC_Int.Org._2024

University

20 Qs

UAS MK. Manajemen Pemasaran

UAS MK. Manajemen Pemasaran

University

20 Qs

Round 01

Round 01

5th Grade - Professional Development

20 Qs

QUIZ WEEK 6

QUIZ WEEK 6

University

20 Qs

Quiz ODC-Jan 2021

Quiz ODC-Jan 2021

University

20 Qs

Ulangan Harian 2

Ulangan Harian 2

9th Grade - 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

Create a free account and access millions of resources

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?