Excel Functions Quiz

Excel Functions Quiz

10th Grade - Professional Development

•

15 Qs

quiz-placeholder

Similar activities

MAGIGING FAIRY KA KAPAG SINAGUTAN MO  ETO

MAGIGING FAIRY KA KAPAG SINAGUTAN MO ETO

10th Grade

•

10 Qs

Module 11

Module 11

University

•

20 Qs

CPA JYSS 2018 Prelims Paper 1

CPA JYSS 2018 Prelims Paper 1

7th Grade - Professional Development

•

20 Qs

SIMULASI KOMUNIKASI DAN DIGITAL

SIMULASI KOMUNIKASI DAN DIGITAL

University

•

15 Qs

CPA 3NT Paper 1 Quiz 5 (Edgefield Sec)

CPA 3NT Paper 1 Quiz 5 (Edgefield Sec)

10th - 12th Grade

•

20 Qs

G2TLEMOD6

G2TLEMOD6

10th Grade

•

10 Qs

Emptech review

Emptech review

11th Grade

•

15 Qs

Fundamentos de Excel

Fundamentos de Excel

12th Grade

•

10 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

•

Instructional Technology

•

10th Grade - Professional Development

•

Practice Problem

•

Hard

Created by

Garfield Davidson

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

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have a list of full names in column A and need to separate first names and last names into separate columns. Which function(s) would be most useful?

CONCATENATE

TEXTSPLIT

VLOOKUP

COUNTIF

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to merge first and last names into a single column but use a space between them, which function would be best?

CONCATENATE

TEXTJOIN

SUMIF

INDEX & MATCH

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You need to count how many times 'Pending' appears in a list of order statuses. Which function should you use?

COUNTIF

VLOOKUP

IF

CONCATENATE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you have a list of sales transactions and want to sum only the sales from a specific region, which function would be best?

SUMIF

TEXTJOIN

TEXTSPLIT

MID

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You need to look up an employee’s department based on their ID number from a separate table. Which function would be most useful?

INDEX & MATCH

VLOOKUP

COUNTIF

Both a and b

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have a column of product codes where the first three characters represent the product category. How can you extract just the category code?

LEFT

RIGHT

MID

Both a and c

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to return the last four digits of a phone number from a full phone number column, which function would you use?

MID

RIGHT

CONCATENATE

COUNTIF

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?

Discover more resources for Instructional Technology