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