Final Excel Revision Test

Final Excel Revision Test

University

15 Qs

quiz-placeholder

Similar activities

Test Development

Test Development

University

10 Qs

Quiz Time!

Quiz Time!

University

10 Qs

Business Ethics

Business Ethics

University

10 Qs

Unidad - Política fiscal

Unidad - Política fiscal

University

14 Qs

QUIZ SECTION 1 DAY 5

QUIZ SECTION 1 DAY 5

7th Grade - University

20 Qs

UK Knowledge Test

UK Knowledge Test

University

10 Qs

IS - DAS - SOCASIS - Sem 4

IS - DAS - SOCASIS - Sem 4

University

12 Qs

BCSI AWARENESS

BCSI AWARENESS

KG - Professional Development

15 Qs

Final Excel Revision Test

Final Excel Revision Test

Assessment

Quiz

Other

University

Practice Problem

Medium

Created by

Bowre P

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

Pivot Tables are used to:

A. Sort data only

B. Create charts

C. Summarize and analyze large datasets

D. Format data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a Pivot Table, the “Values” field is typically used to:

A. Filter data

B. Format text

C. Perform calculations like sum or average

D. Create headings

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a Slicer used for in a Pivot Table?

A. To delete rows

B. To edit formulas

C. To filter Pivot Tables visually

D. To create graphs

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Conditional Formatting help with?

A. Converting data types

Visual data insights (like highlighting top performers)

C. Creating pivot tables

D. Changing font type

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does =IF(A1>100, "High", "Low") return when A1 = 120?

A. 100

B. TRUE

C. Low

D. High

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the output of =IF(5=5, “Yes”, “No”)?

Maybe
Yes
Absolutely not
Definitely

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does VLOOKUP do?

A. Looks horizontally

B. Looks vertically

C. Calculates totals

D. Counts rows

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?