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.
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
Log In | Sign Up / Register