Excel Functions Quiz

Excel Functions Quiz

Professional Development

15 Qs

quiz-placeholder

Similar activities

Data analytics Introduction

Data analytics Introduction

Professional Development

10 Qs

Batch 2 Post Test 2 Analyzing Data Using Ms. Excel

Batch 2 Post Test 2 Analyzing Data Using Ms. Excel

Professional Development

20 Qs

Supply-PKT-Aug-3

Supply-PKT-Aug-3

Professional Development

10 Qs

Microsoft Excel

Microsoft Excel

KG - Professional Development

20 Qs

Kuis Sharing Session ArcGIS Pro

Kuis Sharing Session ArcGIS Pro

Professional Development

20 Qs

Kelas X 28 Spreadsheet 2020

Kelas X 28 Spreadsheet 2020

Professional Development

15 Qs

PivotTable

PivotTable

Professional Development

10 Qs

Health Professional Shortage Area

Health Professional Shortage Area

12th Grade - Professional Development

10 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

Other

Professional Development

Easy

Created by

Mahipal Jadeja

Used 1+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the VLOOKUP function do in Excel?

Finds text within text

Searches for a value by row and returns corresponding data

Adds values across a column

Filters the data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function should you use to add all salaries of employees in the 'Sales' department?

COUNTIF

SUMIF

HLOOKUP

INDEX

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will the formula =IF(A1>10000, 'Eligible', 'Not Eligible') return when A1 = 9500?

TRUE

Not Eligible

Eligible

FALSE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions checks whether a cell contains a number?

ISNA

ISBLANK

ISNUMBER

ISTEXT

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax for the SUMIFS function?

SUMIFS(criteria_range, sum_range)

SUMIFS(sum_range, criteria_range, criteria)

SUMIFS(criteria, range)

SUMIFS(sum_range)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does HLOOKUP search through?

First column

First row

First cell

Last column

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is useful for handling division-by-zero errors in Excel?

IF

INDEX

IFERROR

COUNTIFS

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?