Basic quiz for data analysis

1.) What is the keyboard shortcut to select the entire column in Excel?
a) Ctrl+C
b) Ctrl+V
c) Ctrl+A
d) Ctrl+Shift+Arrow Down

2.)Which Excel function is used to calculate the sum of a range of cells?
a) SUM
b) AVG
c) COUNT
d) MAX

3.) Which chart type would you use to compare the sales performance of different products over time?
a) Line chart
b) Pie chart
c) Bar chart
d) Scatter plot

2 Likes

ans1: C
ans2: A
ans3: A

1 Like

Answers for data analysis quiz

  1. c
    2.a
    3.a
1 Like