/60 Data Analysis Workshop Exam These questions focus on the key features and uses of Microsoft Excel and Microsoft Power BI The number of attempts remaining is 2 NameRegistration NumberPhone NumberName of the DepartmentEmailYear of Studies 1 / 60 1. How does Excel help with data visualization? A) It plays audio files B) It creates charts and graphs C) It edits videos 2 / 60 2. What does the FIND function in Excel do? A) Finds the largest number B) Finds the position of a text in a string C) Sorts numbers in order 3 / 60 3. What type of visualization tool are Sparklines? A) Full-size graphs B) Small cell-level charts C) Animated charts 4 / 60 4. Which function helps retrieve data from multiple columns horizontally? A) HLOOKUP B) VLOOKUP C) SUM 5 / 60 5. How can you quickly highlight cells with high values? A) Record a Sparkline B) Use a macro C) Apply conditional formatting 6 / 60 6. What does the used to Take Add Cells? A) Add B) Sum C) Sub 7 / 60 7. Which advanced Excel technique allows you to execute actions on a workbook open event? A) Text functions B) Event-Driven Macros C) Basic chart customization 8 / 60 8. Which of the following is NOT a common use of Excel? A) Project management B) Photo editing C) Data organization 9 / 60 9. Which chart feature allows you to add titles and labels? A) Conditional formatting B) Macros C) Chart Customization 10 / 60 10. Power BI’s data transformation is done using: A) Power Query B) Data Query Language (DQL) C) Data Query 11 / 60 11. What does conditional formatting in Excel allow you to do? A) Record videos B) Change cell appearance based on values C) Edit images 12 / 60 12. Which feature allows Power BI users to combine data from multiple sources? A) Power Query B) Composite Models C) Power BI Desktop only 13 / 60 13. How are visual options different between Excel and Power BI? A) Excel has more visual options B) Both offer the same visual options C) Power BI has an extensive range of interactive visuals 14 / 60 14. Which Power BI tool allows creating custom calculations? A) Power Query B) DAX C) Power BI Mobile 15 / 60 15. Which platform supports real-time collaboration? A) Power BI B) Neither C) Excel 16 / 60 16. What is one reason why Power BI is user-friendly? A) It has a complex interface B) It has an intuitive design for all skill levels C) It requires extensive technical knowledge 17 / 60 17. Power BI provides which type of data update? A) Automatic data refresh capabilities B) Only real-time updates C) Only manual updates 18 / 60 18. *What can be said about Power BI's future scope? A) ) Limited future advancements B) It will be replaced by Excel C) Greater integration with Microsoft and third-party tools 19 / 60 19. Power Query in Power BI is used for: A) Data cleaning and transformation B) Data storage C) Report sharing 20 / 60 20. Which data analysis tool in Excel groups and filters data for analysis? A) PivotTables B) COUNT C) Sparklines 21 / 60 21. What is the key difference between Power BI and Excel regarding collaboration? A) Excel allows for online sharing only B) Both require users to work offline C) Power BI allows online real-time sharing 22 / 60 22. What does DAX stand for in Power BI? A) Data Aggregation Expressions B) Data Analysis Expressions C) Database Analysis Exchange 23 / 60 23. What is Microsoft Excel primarily used for? A) B) Data analysis and visualization B) A) Playing games C) Creating animations 24 / 60 24. Which tool handles large datasets efficiently? A) Power BI B) Both C) Excel 25 / 60 25. The Power BI Service allows access to reports: A) Only on desktop computers B) From anywhere with internet access C) Only in specific countries 26 / 60 26. What is a practical use of using Excel’s automation tools? A) Designing logos B) Sending emails C) Automating data reports 27 / 60 27. Which logical function checks if a condition is TRUE or FALSE? A) LEFT B) SUM C) IF 28 / 60 28. A key feature of Power BI’s Composite Models is: A) It requires mobile access B) It allows combining data from multiple sources C) It only works with Power BI Service 29 / 60 29. Which platform requires manual data refresh? A) Power BI B) Both C) Excel 30 / 60 30. Which function is used to find the number of entries in a range? A) FIND B) MAX C) COUNT 31 / 60 31. Which feature allows non-technical users to create reports in Power BI? A) Data storage function B) User-friendly interface C) Excel integration only 32 / 60 32. Which formula would you use to add up all values in a range? A) COUNT B) SUM C) MAX 33 / 60 33. What is Power BI? A) A spreadsheet software B) A business intelligence tool developed by Microsoft C) A data storage solution 34 / 60 34. What is the main function of a PivotTable? A) Creating 3D models B) Editing images C) Summarizing and analyzing large datasets 35 / 60 35. What is a primary use of Excel compared to Power BI? A) Business intelligence and data visualization B) Real-time data monitoring C) Spreadsheet calculations and analysis 36 / 60 36. Which function is helpful in logical decision-making in Excel? A) CONCATENATE B) SUM C) IF 37 / 60 37. Which type of chart is best for comparing parts of a whole? A) Line chart B) Bar chart C) Pie chart 38 / 60 38. What is the main purpose of Power BI Desktop? A) Data entry B) Report creation and data modeling C) Data storage 39 / 60 39. Which advanced feature in Power BI supports AI-driven insights? A) AI and Machine Learning B) Power BI Desktop C) Power Query 40 / 60 40. How do you automate tasks like formatting and calculations in Excel? A) Use filters B) Insert images C) Record Macros 41 / 60 41. What do you use to display small data trends directly in cells? A) Sparklines B) Macros C) PivotTables 42 / 60 42. Which function is used to calculate the average of a range in Excel? A) SUM B) AVERAGE C) MAX 43 / 60 43. What feature does Power BI Mobile provide? A) Data transformation B) Only data storage capabilities C) Access to reports on smartphones and tablets 44 / 60 44. Which text function helps to extract a part of a text from the left side? A) FIND B) RIGHT C) LEFT 45 / 60 45. Which tool is used to sort and filter data for analysis? A) Sorting and Filtering B) Chart Wizard C) Data Analysis Tool 46 / 60 46. Power BI Mobile is specifically designed for A) Mobile devices B) Large-scale servers C) Desktop computers 47 / 60 47. What does Power BI primarily provide? A) Interactive data visualizations through reports and dashboards B) Basic data entry C) Financial planning tools 48 / 60 48. What is a key feature of PivotCharts? A) Using charts with PivotTables B) Creating formulas C) Organizing worksheets 49 / 60 49. Which Power BI component allows for team collaboration? A) Power BI Desktop B) Power BI Mobile C) Power BI Service 50 / 60 50. Which platforms does Power BI support? A) Power BI Desktop, Power BI Service, and Power BI Mobile B) Only Power BI Service C) Only Power BI Desktop 51 / 60 51. Which feature provides a user-friendly way to filter data in PivotTables? A) Slicer B) Macros C) Sparklines 52 / 60 52. Augmented Analytics in Power BI includes A) Limited report options B) Natural language queries and AI recommendation C) Only manual data entry options 53 / 60 53. Power BI supports notifications for data updates through A) Notifications in Power BI Mobile B) Only desktop notifications C) No notification feature 54 / 60 54. What is DAX in Power BI? A) A mobile app feature B) A formula language for creating calculations C) A visualization tool 55 / 60 55. What is CONCATENATE used for in Excel? A) Performing mathematical operations B) Formatting dates C) Joining text strings 56 / 60 56. What does the SUM function do? A) Subtracts numbers B) Adds numbers C) Finds the largest value 57 / 60 57. Which Excel feature is used for automating repetitive tasks? A) Macros B) Conditional Formatting C) Sparklines 58 / 60 58. What type of chart is suitable for showing data trends over time? A) Line chart B) Pie chart C) Scatter plot 59 / 60 59. Power BI supports data integration from: A) Only SQL databases B) Various sources like Excel, Oracle, and SQL C) Only Excel files 60 / 60 60. Which feature in Power BI enables access to real-time data? A) Real-time data streaming B) Power Query C) Only manual input 0%
