Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
BIM Excel Test Matching
Test Description: Excel Matching Questions
Instructions: Answer all questions to get your test result.
1) A grid of rows and columns in which you enter text, numbers, and the results of calculations.
A
workbook
B
spreadsheet
C
cell
D
active worksheet
2) Functions used to analyze loans and investments
A
mathematical/trigonometric
B
logical
C
statistical
D
financial
3) Identifies the cell, and is formed by combining the cell’s column letter and row number.
A
active
B
cell reference
C
spreadsheet
D
cell
4) The file used to store worksheets.
A
active worksheet
B
spreadsheet
C
workbook
D
cell
5) Functions used to display text or values if certain conditions exist
A
financial
B
statistical
C
logical
D
mathematical/trigonometric
6) A ____ is the intersection of a row and a column.
A
active
B
spreadsheet
C
cell
D
workbook
7) Functions used to describe quantities of data
A
financial
B
logical
C
mathematical/trigonometric
D
statistical
8) Functions used to manipulate quantitative data
A
financial
B
statistical
C
logical
D
mathematical/trigonometric
9) Determines the best width for a column or the best height for a row, based on its contents.
A
Wrap Text
B
Auto Fit
C
Live Preview
D
Cell Style
10) A note attached to a cell that is usually used to explain or identify information contained in the cell
A
Filtering
B
Sort
C
Comment
D
Hide
11) Highlights worksheet data by changing the look of cells that meet a specified condition
A
Conditional Formatting
B
Comment
C
Sort
D
Filtering
12) Best view for entering and formatting data in a worksheet.
A
Print Area
B
Page Layout
C
Normal View
D
Paste
13) Shows how the worksheet will appear on paper
A
Copy
B
Page layout
C
Normal View
D
Print Area
14) Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria
A
Sort
B
Filtering
C
Conditional Formatting
D
Hiding
15) Rearranging the data in a more meaningful order
A
Sort
B
Conditional Formatting
C
Hiding
D
Filtering
16) Temporarily removing a row or column from view
A
Conditional Formatting
B
Hiding
C
Sort
D
Filtering
17) Shows the relationship of parts to a whole
A
Pie Chart
B
Column Chart
C
Line Chart
D
Scatter Chart
18) Shows the relationship between two categories of data, creating data points that are unrelated to each other
A
Scatter Chart
B
Pie Chart
C
Line Chart
D
Column Chart
19) Illustrates trends over time
A
Column Chart
B
Pie Chart
C
Line Chart
D
Scatter Chart
20) Shows relationships among categories of data
A
Scatter Chart
B
Line Chart
C
Pie Chart
D
Column Chart
*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?