: Quizzes frequently use files like "Store Sales 2011.txt," requiring you to identify delimiters and perform multi-level sorts.
Based on existing course modules, you can expect questions on the following: Fundamental Excel Navigation : Shortcuts like (Save), and Cell Referencing : Distinguishing between absolute references (e.g., ) and relative references. Data Organization Data > Subtotal (requires sorting data first) and creating Pivot Tables. Logic and Lookup Functions : Proper usage of statements, and the Date Functions : Understanding how Excel handles dates, such as the functions. Learning Responsibly Course Review: Introduction to Data Analysis using Excel
Most "Introduction" level quizzes focus on these core competencies: Introduction to Data Analysis Using Excel | Coursera Logic and Lookup Functions : Proper usage of
Introduction to Data Analysis using Microsoft Excel - Coursera Course Review: Introduction to Data Analysis using Excel