Timedora

Data Analysis with Spreadsheets - DATA 110

Covers formulas, functions, tables, charts, filtering, pivot tables, descriptive statistics, and basic data analysis workflows.

Study Tools

All

Study guides

7

2 Formulas and Functions

Learn how spreadsheet formulas use references, operators, and functions to calculate, test, transform, and retrieve data, and how to check results reliably.
Study guide · Updated

7 Basic Spreadsheet Data Analysis

Learn a repeatable spreadsheet workflow for preparing data, summarizing and checking results, and communicating findings with their scope and limitations.
Study guide · Updated

1 Spreadsheet Data Foundations

Learn how to structure, enter, clean, and reference spreadsheet data so it is ready for reliable calculations, sorting, filtering, and summaries.
Study guide · Updated

3 Tables, Sorting, and Filtering

Learn how to organize spreadsheet records in structured tables and use sorting, filtering, and conditional formatting to analyze and present them accurately.
Study guide · Updated

5 Pivot Tables

Learn how pivot tables summarize detailed records, how to prepare and arrange their fields, and how to check summaries, groups, and filters.
Study guide · Updated

6 Descriptive Statistics

Learn how to summarize data with frequency distributions and measures of center and spread, and how to choose and interpret those summaries in context.
Study guide · Updated

4 Charting Spreadsheet Data

Learn to select, build, format, and interpret spreadsheet charts for category comparisons, time trends, composition, distributions, and relationships.
Study guide · Updated

Quizzes

7

6 Descriptive Statistics

A medium-difficulty quiz on interpreting and applying descriptive statistics, including frequency, center, spread, and appropriate use of summaries.
Quiz · Updated

2 Formulas and Functions

A medium-difficulty quiz on applying spreadsheet formulas and functions, including references, conditional calculations, text, dates, and troubleshooting.
Quiz · Updated

5 Pivot Tables

A medium-difficulty quiz on preparing data, building pivot tables, and interpreting or refining their summaries.
Quiz · Updated

1 Spreadsheet Data Foundations

A medium-difficulty quiz on organizing, formatting, cleaning, and referencing spreadsheet data.
Quiz · Updated

7 Basic Spreadsheet Data Analysis

A medium-level quiz on framing spreadsheet questions, preparing data, choosing analysis tools, checking results, and communicating findings.
Quiz · Updated

3 Tables, Sorting, and Filtering

A medium-difficulty quiz on organizing spreadsheet tables and applying sorting, filtering, and conditional formatting in Excel.
Quiz · Updated

4 Charting Spreadsheet Data

A medium-difficulty quiz on choosing, building, formatting, and interpreting spreadsheet charts.
Quiz · Updated

Flashcards

7

6 Descriptive Statistics

Learn how frequency, center, and spread summarize data, and how to choose statistics that fit the data’s shape and type.
Flashcards · Updated

4 Charting Spreadsheet Data

Learn how to choose, build, format, and interpret spreadsheet charts clearly and accurately.
Flashcards · Updated

5 Pivot Tables

Learn how pivot tables organize, summarize, filter, and check data without changing the underlying records.
Flashcards · Updated

3 Tables, Sorting, and Filtering

Learn how to organize spreadsheet data in structured tables and use sorting, filtering, and conditional formatting to analyze it.
Flashcards · Updated

2 Formulas and Functions

Learn how to build spreadsheet formulas, use references and functions, handle text and dates, and retrieve data with lookups.
Flashcards · Updated

7 Basic Spreadsheet Data Analysis

Learn a repeatable spreadsheet workflow for preparing data, analyzing results, checking accuracy, and communicating findings.
Flashcards · Updated

1 Spreadsheet Data Foundations

Learn how to structure, format, clean, and reference spreadsheet data for more reliable analysis.
Flashcards · Updated