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
function
C
formula
D
chart
2) Used to display only the rows in a list that satisfy the conditions you specify.
A
formula
B
filter
C
function
D
backstage
3) A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value.
A
find
B
functions
C
filters
D
formula
4) A prewritten formula that takes a value or values, performs an operation, and returns a value or values.
A
AutoSum
B
function
C
formula
D
filter
5) A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date.
A
Backstage
B
Sort Order
C
Organizer
D
Saving
6) A view that replaces the file menu that appeared in previous versions of Office.
A
Save Page
B
Ribbon
C
Info Page
D
Backstage
7) A graphical representation of numeric data. It displays the data along with the relationship between them.
A
Table
B
Chart/Graph
C
PivotChart
D
workbook
8) A structure that incorporates commands in logical tabs.
A
Ribbon
B
Info Page
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 Bean
B
Screen Help
C
Screen Tip
D
Screen set up
10) a file that is used by a Microsoft Excel spreadsheet application; a set of pages
A
Worksheet
B
Worktab
C
Workbook
D
Worklog
*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?