BIM Excel Test Matching: Question Preview (ID: 28930)

Below is a preview of the questions contained within the game titled BIM EXCEL TEST MATCHING: Excel Matching Questions .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

Shows how the worksheet will appear on paper
a) Page layout b) Print Area c) Normal View d) Copy
Best view for entering and formatting data in a worksheet.
a) Normal View b) Page Layout c) Print Area d) Paste
Highlights worksheet data by changing the look of cells that meet a specified condition
a) Conditional Formatting b) Sort c) Filtering d) Comment
A note attached to a cell that is usually used to explain or identify information contained in the cell
a) Comment b) Sort c) Hide d) Filtering
Functions used to manipulate quantitative data
a) mathematical/trigonometric b) logical c) financial d) statistical
Determines the best width for a column or the best height for a row, based on its contents.
a) Auto Fit b) Wrap Text c) Cell Style d) Live Preview
Functions used to describe quantities of data
a) statistical b) financial c) logical d) mathematical/trigonometric
A ____ is the intersection of a row and a column.
a) cell b) active c) spreadsheet d) workbook
Functions used to display text or values if certain conditions exist
a) logical b) statistical c) financial d) mathematical/trigonometric
The file used to store worksheets.
a) workbook b) active worksheet c) spreadsheet d) cell
Identifies the cell, and is formed by combining the cell’s column letter and row number.
a) cell reference b) cell c) active d) spreadsheet
Functions used to analyze loans and investments
a) financial b) logical c) mathematical/trigonometric d) statistical
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
a) spreadsheet b) active worksheet c) workbook d) cell
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
Rearranging the data in a more meaningful order
a) Sort b) Conditional Formatting c) Filtering d) Hiding
Temporarily removing a row or column from view
a) Hiding b) Sort c) Filtering d) Conditional Formatting
Shows the relationship of parts to a whole
a) Pie Chart b) Column Chart c) Scatter Chart d) Line Chart
Shows the relationship between two categories of data, creating data points that are unrelated to each other
a) Scatter Chart b) Line Chart c) Column Chart d) Pie Chart
Illustrates trends over time
a) Line Chart b) Column Chart c) Pie Chart d) Scatter Chart
Shows relationships among categories of data
a) Column Chart b) Pie Chart c) Scatter Chart d) Line Chart
Play Games with the Questions above at
To play games using the questions from the data set above, visit and enter game ID number: 28930 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register