Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Basic - MITA
Test Description: Review course vocabulary 10283
Instructions: Answer all questions to get your test result.
1) 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
chart
C
function
D
formula
2) Used to display only the rows in a list that satisfy the conditions you specify.
A
function
B
backstage
C
formula
D
filter
3) A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value.
A
filters
B
functions
C
formula
D
find
4) A prewritten formula that takes a value or values, performs an operation, and returns a value or values.
A
function
B
formula
C
filter
D
AutoSum
5) A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date.
A
Backstage
B
Organizer
C
Sort Order
D
Saving
6) A view that replaces the file menu that appeared in previous versions of Office.
A
Backstage
B
Ribbon
C
Save Page
D
Info Page
7) A graphical representation of numeric data. It displays the data along with the relationship between them.
A
PivotChart
B
workbook
C
Table
D
Chart/Graph
8) A structure that incorporates commands in logical tabs.
A
Info Page
B
Ribbon
C
Tools
D
Menu
9) A feature in which a small text box appears besides the icon or button when the mouse is moved over it.
A
Screen set up
B
Screen Bean
C
Screen Help
D
Screen Tip
10) a file that is used by a Microsoft Excel spreadsheet application; a set of pages
A
Worksheet
B
Workbook
C
Worklog
D
Worktab
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?