Excel Basic - MITA Question Preview (ID: 4511)


Review Course Vocabulary 10283. TEACHERS: click here for quick copy question ID numbers.

In a PivotTable or PivotChart report, a category of data that's derived from a field in the source data. PivotTable reports have row, column, page, and data fields.
a) field
b) function
c) formula
d) chart

Used to display only the rows in a list that satisfy the conditions you specify.
a) formula
b) backstage
c) filter
d) function

A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value.
a) formula
b) functions
c) filters
d) find

A prewritten formula that takes a value or values, performs an operation, and returns a value or values.
a) AutoSum
b) filter
c) formula
d) function

A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date.
a) Organizer
b) Sort Order
c) Saving
d) Backstage

A view that replaces the file menu that appeared in previous versions of Office.
a) Info Page
b) Save Page
c) Backstage
d) Ribbon

A graphical representation of numeric data. It displays the data along with the relationship between them.
a) PivotChart
b) Table
c) Chart/Graph
d) workbook

A structure that incorporates commands in logical tabs.
a) Info Page
b) Ribbon
c) Menu
d) Tools

A feature in which a small text box appears besides the icon or button when the mouse is moved over it.
a) Screen Bean
b) Screen Tip
c) Screen Help
d) Screen set up

a file that is used by a Microsoft Excel spreadsheet application; a set of pages
a) Worksheet
b) Workbook
c) Worklog
d) Worktab

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: 4511 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links