Quiz for Data Analysis

Q1: Which chart is best used to compare parts of a whole?

A. Pie Chart B. Bar Graph C. Line Chart D. Scatter Plot

Q2: What does a line chart typically represent?

A. Trends over time B. Category comparison C. Distribution of data D. Frequency

Q3: Which of these is NOT a form of data visualization?

A. Table B. Histogram C. Flowchart D. Pie Chart

Q4: Which software is widely used for data analysis?

A. MS Paint B. MS Excel C. Notepad D. Chrome

Q5: In Excel, which function is used to find the average of a range?

A. SUM() B. MAX() C. AVG() D. AVERAGE()

Q6: What does a bar graph display?

A. Data changes over time B. Quantities by category C. Parts of a whole D. Correlation

Q7: Which chart type is best for showing correlation?

A. Pie Chart B. Line Chart C. Scatter Plot D. Bar Graph

Q8: Which tool in Excel helps summarize data using tables?

A. Filter B. Pivot Table C. Sort D. Wrap Text

Q9: What is a frequency distribution?

A. Data arrangement by name B. Range of values C. Data grouped by occurrence D. Average of data

Q10: Which axis in a bar chart shows categories?

A. X-axis B. Y-axis C. Z-axis D. None

Q11: In data analysis, “trend” means?

A. Random changes B. Fluctuation C. General direction over time D. Anomalies

Q12: Which Excel function returns the highest value?

A. MIN() B. AVERAGE() C. MAX() D. COUNT()

Q13: Which is a data analysis tool in Excel?

A. Pivot Chart B. Pie Text C. Ribbon D. Tabs

Q14: Which function finds the middle value?

A. MIN() B. MAX() C. MEDIAN() D. SUM()

Q15: What type of data does a histogram show?

A. Cumulative B. Categorical C. Frequency D. Alphabetical

Q16: In Excel, which feature automatically fills cells based on a pattern?

A. AutoComplete B. AutoFill C. Flash Fill D. Copy-Paste

Q17: Which is not a valid Excel chart type?

A. Doughnut B. Radar C. Funnel D. Brick

Q18: Which Excel feature helps identify trends?

A. Spell Check B. Data Bars C. Trendline D. Zoom

Q19: Which chart is used for time series data?

A. Column Chart B. Bar Chart C. Line Chart D. Pie Chart

Q20: Which Excel tab contains chart tools?

A. Home B. Insert C. Data D. Review