Data Cleaning

Data Cleaning

11th Grade

12 Qs

quiz-placeholder

Similar activities

Digital Literacy vocab

Digital Literacy vocab

6th - 12th Grade

10 Qs

Ex - Basic Functions 2

Ex - Basic Functions 2

9th - 12th Grade

12 Qs

4.3 Word Quizizz

4.3 Word Quizizz

8th - 12th Grade

14 Qs

ICT Review

ICT Review

11th Grade

10 Qs

Programming_Grade11_Term3_Week02

Programming_Grade11_Term3_Week02

11th Grade

10 Qs

DIT Excel 2016 Review

DIT Excel 2016 Review

8th - 12th Grade

15 Qs

Python basics

Python basics

9th - 12th Grade

16 Qs

Câu hỏi về hàm SUMIF trong Excel

Câu hỏi về hàm SUMIF trong Excel

9th Grade - University

10 Qs

Data Cleaning

Data Cleaning

Assessment

Quiz

Computers

11th Grade

Hard

Created by

GHIS 2023

Used 10+ 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?