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
active worksheet
C
spreadsheet
D
cell
2) Functions used to analyze loans and investments
A
logical
B
financial
C
mathematical/trigonometric
D
statistical
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
workbook
B
cell
C
spreadsheet
D
active worksheet
5) Functions used to display text or values if certain conditions exist
A
statistical
B
mathematical/trigonometric
C
logical
D
financial
6) A ____ is the intersection of a row and a column.
A
cell
B
spreadsheet
C
workbook
D
active
7) Functions used to describe quantities of data
A
financial
B
statistical
C
logical
D
mathematical/trigonometric
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
Live Preview
B
Cell Style
C
Auto Fit
D
Wrap Text
10) A note attached to a cell that is usually used to explain or identify information contained in the cell
A
Hide
B
Comment
C
Filtering
D
Sort
11) Highlights worksheet data by changing the look of cells that meet a specified condition
A
Comment
B
Filtering
C
Sort
D
Conditional Formatting
12) Best view for entering and formatting data in a worksheet.
A
Normal View
B
Paste
C
Page Layout
D
Print Area
13) Shows how the worksheet will appear on paper
A
Print Area
B
Page layout
C
Normal View
D
Copy
14) Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria
A
Filtering
B
Conditional Formatting
C
Hiding
D
Sort
15) Rearranging the data in a more meaningful order
A
Sort
B
Filtering
C
Hiding
D
Conditional Formatting
16) Temporarily removing a row or column from view
A
Conditional Formatting
B
Filtering
C
Sort
D
Hiding
17) Shows the relationship of parts to a whole
A
Pie Chart
B
Scatter Chart
C
Line Chart
D
Column Chart
18) Shows the relationship between two categories of data, creating data points that are unrelated to each other
A
Pie Chart
B
Scatter Chart
C
Column Chart
D
Line Chart
19) Illustrates trends over time
A
Scatter Chart
B
Line Chart
C
Column Chart
D
Pie Chart
20) Shows relationships among categories of data
A
Line Chart
B
Column Chart
C
Pie Chart
D
Scatter 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?