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

Quiz
•
Computers
•
11th Grade
•
Hard
GHIS 2023
Used 10+ times
FREE Resource
12 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
1 min • 1 pt
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
17 questions
1.4 principles of programming

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

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

Quiz
•
7th - 12th Grade
10 questions
Programming_Grade11_Term3_Week02

Quiz
•
11th Grade
16 questions
Python basics

Quiz
•
9th - 12th Grade
10 questions
Câu hỏi về hàm SUMIF trong Excel

Quiz
•
9th Grade - University
10 questions
MOAC Word 2016 Lesson 3

Quiz
•
8th - 12th Grade
8 questions
HTML vs. XHTML Quiz

Quiz
•
11th Grade - University
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade