Data Analytics Tools MCQs (25)
1) Which tool is widely used for data visualization dashboards?
A. Power BI
B. Photoshop
C. VLC
D. Notepad
2) Tableau is mainly used for?
A. Video editing
B. Data visualization and dashboards
C. Coding games
D. Networking
3) Which language is most popular in data analytics?
A. Python
B. HTML
C. CSS
D. XML
4) Pandas library is used for?
A. Data manipulation and analysis
B. Image editing
C. Web hosting
D. Antivirus
5) NumPy is mainly used for?
A. Numerical computing
B. Video creation
C. Networking
D. Cloud storage
6) Excel is commonly used for?
A. Data analysis and reporting
B. Mobile development
C. Operating system
D. Game engine
7) SQL is used for?
A. Database querying
B. Designing logos
C. Video streaming
D. Animation
8) Power BI uses which language for calculations?
A. DAX
B. CSS
C. JSON
D. XML
9) Power Query is used for?
A. Data cleaning and transformation
B. Drawing charts manually
C. Coding AI models
D. Gaming
10) Matplotlib is used for?
A. Data visualization in Python
B. Database backup
C. Cloud deployment
D. Networking
11) Seaborn is built on top of?
A. Matplotlib
B. SQL
C. Excel
D. Tableau
12) Jupyter Notebook is mainly used for?
A. Writing and running analysis code
B. Video editing
C. Music production
D. Networking config
13) R language is mostly used for?
A. Statistical analysis
B. Gaming
C. Hardware control
D. Cloud storage
14) Which tool is best for big data processing?
A. Apache Spark
B. Paint
C. Calculator
D. WordPad
15) Hadoop ecosystem is used for?
A. Big data storage and processing
B. Video games
C. UI design
D. Antivirus
16) Which cloud service is commonly used in analytics?
A. AWS
B. Bluetooth
C. LAN
D. USB
17) Google Data Studio is used for?
A. Reporting and dashboards
B. Editing images
C. Database coding
D. OS installation
18) Which tool is best for ETL operations?
A. Talend
B. Photoshop
C. Chrome
D. Spotify
19) GitHub is used by analysts mainly for?
A. Version control
B. Data visualization
C. Audio editing
D. Networking
20) Which tool is best for statistical modeling?
A. R
B. Excel Paint
C. VLC
D. Notepad
21) Which Python library is used for machine learning?
A. Scikit-learn
B. Flask
C. Django
D. Tkinter
22) Which tool is used for workflow automation in data pipelines?
A. Apache Airflow
B. Paint
C. Calculator
D. Zoom
23) Which BI tool is developed by Microsoft?
A. Power BI
B. Tableau
C. QlikView
D. Looker
24) Which tool supports drag-and-drop dashboard building?
A. Tableau
B. Python
C. SQL
D. C++
25) Data analytics tools mainly help in?
A. Extracting insights from data
B. Playing games
C. Hardware repair
D. File compression
Answer Key
1) A
2) B
3) A
4) A
5) A
6) A
7) A
8) A
9) A
10) A
11) A
12) A
13) A
14) A
15) A
16) A
17) A
18) A
19) A
20) A
21) A
22) A
23) A
24) A
25) A