WorksheetsMethods of Data Presentation
Total questions: 5
Worksheet time: 3mins
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
