WorksheetsBe Spotless: Data Storing & Cleansing
Total questions: 10
Worksheet time: 5mins
The correct form of RAW data is...
Separate day, month, and year per column
Using "-" or "/" on phone number
Put data into separate columns
Using comma instead of Currency or Accounting Format
The best data storing method for date and time is...
This L-shaped handle on the bottom right is NOT to...
Automatically expand when you enter data in the next row/column
Make column headers always visible
Remove data from the Table
Resize any Excel Table by dragging this handle around
Below is NOT the benefit of Name Manager...
Easier to read
Formulas faster to type and debug
Create ranges to make your spreadsheets dynamic and easy to update
Automatically expand when you enter data in the next row/column
Below is NOT the steps of Data Cleaning...
Automate the whole data cleaning process
Makes your analysis run faster
Choose the RIGHT cleaning techniques
Determining what is wrong with your data
After finding what is wrong with our data, we need to clean it. Below is NOT the method of cleaning:
Removing duplicate data
Fixing number or date format
Filtering data
Combining or separating texts
Ways to prevent dirty data source is...
Combining several data into one column
Data input is not using standardize format
Keep the data raw
Create chart to find outliers
Based on table below, the correct formula to take "Kategori" of column A is...
Split Text to Row/ Column
=LEFT(A2, 12)
=MID(A2, FIND("|", A2)+1, LEN(A2))
=RIGHT(A2, 3)
To check missing data we SHOULD NOT use this method...
=ISEXIST
=ISBLANK
=ISNA
=IFNA
To deal with inconsistent data we can use this method...
Remove duplicate
Make sure data input is using standardize format
Check if your data makes sense
Fill in missing values with “best guesses.”
