Data Cleaning

Quiz
•
Computers
•
11th Grade
•
Hard
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
Similar Resources on Wayground
10 questions
App inventor

Quiz
•
11th Grade
10 questions
J277 Utility Software (Encryption & Defragmentation)

Quiz
•
10th - 12th Grade
10 questions
MOAC Word 2016 Lesson 5

Quiz
•
8th - 12th Grade
17 questions
Shortcut keys

Quiz
•
7th - 12th Grade
15 questions
CSS Rules Quiz

Quiz
•
11th Grade
10 questions
PARDUS DOSYA SİSTEMİ VE ÇALIŞMA MANTIĞI

Quiz
•
9th - 12th Grade
15 questions
Python Lists

Quiz
•
8th - 12th Grade
15 questions
Excel - Worksheet and Formula

Quiz
•
9th Grade - University
Popular Resources on Wayground
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World

Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
20 questions
ELA Advisory Review

Quiz
•
7th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns

Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade