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
cell
B
active worksheet
C
spreadsheet
D
workbook
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
cell
B
spreadsheet
C
active
D
cell reference
4) The file used to store worksheets.
A
active worksheet
B
spreadsheet
C
cell
D
workbook
5) Functions used to display text or values if certain conditions exist
A
mathematical/trigonometric
B
statistical
C
financial
D
logical
6) A ____ is the intersection of a row and a column.
A
active
B
cell
C
workbook
D
spreadsheet
7) Functions used to describe quantities of data
A
logical
B
financial
C
statistical
D
mathematical/trigonometric
8) Functions used to manipulate quantitative data
A
financial
B
logical
C
mathematical/trigonometric
D
statistical
9) Determines the best width for a column or the best height for a row, based on its contents.
A
Auto Fit
B
Live Preview
C
Cell Style
D
Wrap Text
10) A note attached to a cell that is usually used to explain or identify information contained in the cell
A
Comment
B
Filtering
C
Hide
D
Sort
11) Highlights worksheet data by changing the look of cells that meet a specified condition
A
Filtering
B
Sort
C
Conditional Formatting
D
Comment
12) Best view for entering and formatting data in a worksheet.
A
Paste
B
Page Layout
C
Normal View
D
Print Area
13) Shows how the worksheet will appear on paper
A
Print Area
B
Page layout
C
Copy
D
Normal View
14) Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria
A
Hiding
B
Sort
C
Filtering
D
Conditional Formatting
15) Rearranging the data in a more meaningful order
A
Hiding
B
Filtering
C
Conditional Formatting
D
Sort
16) Temporarily removing a row or column from view
A
Sort
B
Filtering
C
Conditional Formatting
D
Hiding
17) Shows the relationship of parts to a whole
A
Scatter Chart
B
Pie 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
Line Chart
B
Scatter Chart
C
Column Chart
D
Pie 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
Column Chart
B
Line Chart
C
Scatter Chart
D
Pie 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?