BIM Excel Test Matching Question Preview (ID: 28930)


Excel Matching Questions. TEACHERS: click here for quick copy question ID numbers.

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 ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 28930 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register