Podcast
Questions and Answers
Flashcards
Capitale de la France (exemple de fiche)
Capitale de la France (exemple de fiche)
Paris
Study Notes
📝 Data Analysis Fundamentals Q: What is the analogy made with data collection? A: Data collection is compared to planning a vacation or party, where information is gathered to make informed decisions.
🔧 Tools Q: What are the two main tools mentioned for data analysis? A: Microsoft Excel and Power BI
⌨️ Excel Alignment Q: How does Excel align text and numbers by default? A: Text aligns to the left, numbers align to the right
📊 Format Painter Q: What is the function of Format Painter in Excel? A: To copy formatting from one cell to other cells
🔒 Freeze Panes Q: What is the purpose of the Freeze Panes function? A: To keep specific rows or columns static while scrolling
🔍 Filtering Q: How can you identify that a filter is active in Excel? A: A funnel symbol appears on the filter arrow
📐 Calculations Q: What is the order of precedence in Excel calculations? A: Multiplication and Division are performed before Addition and Subtraction
📍 Cell References Q: What's the difference between relative and absolute references? A: Relative references adjust when copied, absolute references (with $) remain constant
🔄 Autocomplete Q: How does Autocomplete work in Excel? A: It suggests entries based on previously entered data in the column
📊 Multi-level Sorting Q: How do you perform sorting on multiple criteria? A: Use the Sort button and add multiple sort levels in the dialog box
💼 Career Q: In which fields are data analysis skills valued? A: In all sectors, with opportunities to progress to data scientist positions
🔗 Power BI Integration Q: Why is it important to master Excel before Power BI? A: Excel serves as a foundation for data preparation before using Power BI
📱 New Window Q: What is the advantage of using New Window in Excel? A: Allows opening a second view of the same file to see different parts simultaneously
🏷️ Name Box Q: What are the two main functions of the Name Box? A: 1) Quickly navigate to specific cells 2) Assign names to cells
📋 Data Types Q: How does Excel treat entries with both letters and numbers? A: As text
🔢 Number Formatting Q: What are two common number formats mentioned? A: Currency format and Comma format (for thousands separators)
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
