Methods of Data Presentation

1.Which of the following is(are) TRUE about the function “PivotTable”?

I. It can generate a two-way frequency table.

II. It can generate summary statistics such as mean across several categories of data.

• I only

• II only

• I and II

• none

Which of the following is the most appropriate in presenting the trend of time series data?

• Line chart

• Bar chart

• Pie chart

• Pictograph

Which type of chart is the most appropriate for categorical data with 6 or fewer categories?

• Line chart

• Bar chart

• Pie chart

• Pictograph

Which type of chart is most appropriate for presenting the percentage allocation across categories of data?

• Line chart

• Bar chart

• Pie chart

• Pictograph

Which of the following horizontal bar charts is(are) available in MS EXCEL?

• simple bar chart

• grouped bar chart

• subdivided/stacked bar chart

• all of the above