Quiz

Quiz

Professional Development

16 Qs

quiz-placeholder

Similar activities

Adwords Fundamentals??? Basic lang yan! T_T

Adwords Fundamentals??? Basic lang yan! T_T

University - Professional Development

20 Qs

Java Fundamentals

Java Fundamentals

Professional Development

20 Qs

Drones

Drones

KG - Professional Development

17 Qs

Computer Networking Fundamentals

Computer Networking Fundamentals

Professional Development

12 Qs

Forward/Reply/Reply All

Forward/Reply/Reply All

Professional Development

13 Qs

E-Commerce

E-Commerce

University - Professional Development

16 Qs

ISC2 - Chapter 1 - Module 3 - G2

ISC2 - Chapter 1 - Module 3 - G2

Professional Development

13 Qs

Git-it?

Git-it?

Professional Development

18 Qs

Quiz

Quiz

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

Karma Dorji

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

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the "Remove Duplicates" feature in Excel do?

Deletes all rows with the same values in every column

Removes repeated values from a selected range or table

Sorts the data and highlights duplicates

Only removes duplicates if conditional formatting is applied

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the TEXT function do in Excel?

Converts numbers to formatted text

Extracts text from formulas

Combines multiple strings

Formats fonts in text

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to combine the contents of two cells (e.g., A1 and B1) in older versions of Excel?

MERGE()

CONCATENATE(A1, B1)

TEXTJOIN(A1)

JOIN(A1, B1)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to replace all occurrences of "cat" with "dog" in cell A1?

=REPLACE(A1, "cat", "dog")

=SWITCH(A1, "cat", "dog")

=SUBSTITUTE(A1, "cat", "dog")

=SUBSTITUTE(A1, "dog", "cat")

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main purpose of Data Validation in Excel?

To validate formulas

To remove incorrect entries

To restrict user input based on specific criteria

To compare worksheet data

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Data Validation setting allows users to choose from a predefined list of values?

Whole Number

List

Custom

Text Length

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the "Filter" feature in Excel allow you to do?

Merge cells

Display rows matching specific conditions

Validate data formats

Highlight text

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?