Excel - Part 10 Question Preview (ID: 8954)


2nd 50. TEACHERS: click here for quick copy question ID numbers.

What is an organized collection of data called?
a) Table or list
b) Database or list
c) Table or field
d) Table or database

Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
a) RotateTable
b) PivotDate
c) PivotTable
d) PivotChart

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
a) PivotChart
b) PivotTable
c) PivotDate
d) RotateTable

Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
a) Delete
b) Remove
c) Format
d) Format as Table

What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
a) Slicer
b) Cutter
c) Division
d) Sliver

In a chart, what is data that appears along the horizontal scale of the chart called?
a) Y-axis data
b) X-axis data
c) Vertical data
d) Horizontal data

In a chart, what is data that appears along the vertical scale of the chart called?
a) Y-axis data
b) X-axis data
c) Vertical data
d) Horizontal data

What type of chart would be used to show proportions of a part to the whole?
a) Column
b) Line
c) Pie
d) Radar

Which is a tiny chart that provides a visual representation of data in a worksheet cell?
a) Trendline
b) Sparkline
c) Dataline
d) FlashPoint

Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
a) Style
b) Design
c) Layout
d) Format

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 8954 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register