Kids Excel 2 – Quiz | Divex Consult

1. What Excel tool helps remove repeated records automatically? *

a) Sort

b) Remove Duplicates

c) Find & Replace

d) Filter

2. If you want to change all “NY” to “New York” in your dataset at once, which feature do you use? *

a) Sorting

b) Replace All

c) Remove Duplicates

d) Data Validation

3. When cleaning data, why is “sorting” important? *

a) To delete records

b) To arrange records in order

c) To add up numbers

d) To create charts

4. Which function can help you remove extra spaces in text data? *

a) TRIM()

b) CLEAN()

c) LEFT()

d) PROPER()

Filtering allows you to temporarily hide data you don’t need *

True

False

Data Analysis Using Excel for Kids 001