Data Cleaning

Data Cleaning

11th Grade

12 Qs

quiz-placeholder

Similar activities

POGIL: Python Activity 1

POGIL: Python Activity 1

9th - 12th Grade

12 Qs

Google Sheets Warmup Quiz

Google Sheets Warmup Quiz

9th - 12th Grade

13 Qs

Word 1.6 Review Quiz

Word 1.6 Review Quiz

7th - 12th Grade

17 Qs

Touch Typing Concepts 2

Touch Typing Concepts 2

9th - 12th Grade

10 Qs

Graphic Design Intro: Type

Graphic Design Intro: Type

9th - 12th Grade

10 Qs

PPT Indicator

PPT Indicator

9th - 12th Grade

10 Qs

Excel Quiz Review

Excel Quiz Review

9th - 12th Grade

14 Qs

Excel Review

Excel Review

7th - 12th Grade

10 Qs

Data Cleaning

Data Cleaning

Assessment

Quiz

Computers

11th Grade

Hard

Created by

GHIS 2023

Used 12+ times

FREE Resource

12 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

--------- , R and SQL are used for large data

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

One of the easiest ways of cleaning data in Excel is to --------------- duplicates

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Extra spaces are painfully difficult to spot. While you may somehow spot the extra spaces between words or numbers, trailing spaces are not even visible. There is a neat way to get rid of these extra spaces – Use ----------- Function.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you get data from a database or import it from a text file, it may happen that all the text is cramped in one cell. You can parse this text into multiple cells by using Text to Column functionality in -------------- tab.

Home

Format

Data

View

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To Convert Numbers Stored as Text into Numbers , we use ----------- function

value

Val

Text

txt

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Finding "r" is the same like finding "R" using -------------- function

Find

Replace

Search

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Finding "r" is NOT the same like finding "R" using -------------- function

Find

Replace

Search

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?

Discover more resources for Computers