Excel practice questions DS150423

Excel (DS150423)

  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