
Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A detailed guide on how to use excel's data filtering and sorting features to analyze and manipulate data from a table. The instructions cover importing data from a web query, cleaning the table, applying filters using various criteria, calculating new fields, and sorting records. The document also includes exercises to practice these skills.
Typology: Study notes
1 / 1
This page cannot be seen from the preview
Don't miss anything!
the data to check for other data errors.
headers to Bold.
field names and it does not include it in the sort.
the top of each column. These arrows indicate you are ready to filter your data.
arrow, choose the “Custom” option, using the drop down menu, select the “Begins with” option, enter an ‘A’ in the text box and click OK. ( 15 countries? ) Notice how the row numbers still show the original numbers; the other rows are simply hidden.
in their name? (Note the use of * and? in the “Custom filter dialog box.) How many countries have a name that starts with A and ends with A? Can you determine how many start with A, end with A, and have exactly seven letters? Can you determine how many contain “ an ” anywhere in the name and start with an F?
all.
Density divide Population by Area. Put that formula in the first record Density field. (What happens if you double click the fill handle?)
use the same menu to turn Auto Filter back on. Did you get an arrow on your Density field? Sort your data by the density field. What country has the highest density? (Ignore the error for Vatican City).
your sort order on density still active?
Auto size the column widths.
about any of your filter arrows before you turn off the filters you set?)
on country area, ascending. Now filter on countries with fewer than 100 square kilometers.
columns. Delete the record in your data containing the Holy See.