Excel Functions Quiz samir

Excel Functions Quiz samir

University

20 Qs

quiz-placeholder

Similar activities

RISIKO KREDIT & RISIKO OPERASIONAL

RISIKO KREDIT & RISIKO OPERASIONAL

KG - Professional Development

20 Qs

MCC

MCC

KG - Professional Development

15 Qs

UAS Rekayasa Nilai (VE) 2022-1

UAS Rekayasa Nilai (VE) 2022-1

University

17 Qs

Sistemas de impresión

Sistemas de impresión

University

15 Qs

World Cup Football Quiz

World Cup Football Quiz

University - Professional Development

15 Qs

Q2 Accenture Academy - Individual Quiz

Q2 Accenture Academy - Individual Quiz

University

15 Qs

Control systems I(Viscosity controller & OMD)

Control systems I(Viscosity controller & OMD)

University

20 Qs

Employee Satisfaction and Commitment

Employee Satisfaction and Commitment

University

19 Qs

Excel Functions Quiz samir

Excel Functions Quiz samir

Assessment

Quiz

Other

University

Practice Problem

Hard

Created by

Raman Shrestha

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...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the VLOOKUP function do?

Looks up values horizontally

Looks up values vertically

Sums values

Filters data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function searches data horizontally in the first row?

VLOOKUP

INDEX

HLOOKUP

MATCH

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function returns the position of a value in a range?

INDEX

MATCH

CHOOSE

HLOOKUP

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to return the value at a specific row and column?

VLOOKUP

HLOOKUP

INDEX

OFFSET

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax of VLOOKUP?

VLOOKUP(range, value, row_num, FALSE)

VLOOKUP(value, table_array, col_index_num, [range_lookup])

VLOOKUP(col_index_num, value, table_array, TRUE)

VLOOKUP(value, row, column, TRUE)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens if VLOOKUP cannot find the value?

Returns 0

Returns blank

Returns #N/A error

Crashes Excel

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function can dynamically return a cell reference by moving rows/columns?

MATCH

INDEX

OFFSET

XLOOKUP

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?