A parks GIS tech exports CSV lists and cleans columns in Excel before publishing. Which capability does that workflow demonstrate?
Select an answer to reveal the explanation.
Short Explanation
CSV cleanup is spreadsheet work. Excel is where columns get trimmed, sorted, and shaped before publish. Phones, patch rings, and calendars do not scrub GIS tables.
Full Explanation
Excel is used to prepare and clean tabular data before wider use—precisely the parks GIS tech workflow of exporting CSV lists and cleaning columns prior to publishing. Column cleanup, filters, and reshaping are core spreadsheet capabilities in municipal data prep.
Teams Phone fails because voice calling does not automatically clean CSV columns. Windows Autopatch fails because OS update servicing does not rewrite GIS spreadsheets. Outlook calendaring fails as the primary tool for tabular data cleanup.
Exam caveat: cleaning in Excel is fine for prep, but published GIS or open-data outputs still need validation and a governed publish path. Operational check: keep a documented cleaning checklist, preserve raw CSV separately from cleaned workbooks, and have a second tech spot-check columns before public or system publish. Record the choice in the municipal service catalog so help-desk scripts stay consistent. Record the choice in the municipal service catalog so help-desk scripts stay consistent. Record the choice in the municipal service catalog so help-desk scripts stay consistent. Record the choice in the municipal service catalog so help-desk scripts stay consistent. Record the choice in the municipal service catalog so help-desk scripts stay consistent.