BIM Excel Test Matching Question Preview (ID: 28930)
Excel Matching Questions.
TEACHERS: click here for quick copy question ID numbers.
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
Functions used to analyze loans and investments
a) financial
b) logical
c) mathematical/trigonometric
d) statistical
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
The file used to store worksheets.
a) workbook
b) active worksheet
c) spreadsheet
d) cell
Functions used to display text or values if certain conditions exist
a) logical
b) statistical
c) financial
d) mathematical/trigonometric
A ____ is the intersection of a row and a column.
a) cell
b) active
c) spreadsheet
d) workbook
Functions used to describe quantities of data
a) statistical
b) financial
c) logical
d) mathematical/trigonometric
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
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
Highlights worksheet data by changing the look of cells that meet a specified condition
a) Conditional Formatting
b) Sort
c) Filtering
d) Comment
Best view for entering and formatting data in a worksheet.
a) Normal View
b) Page Layout
c) Print Area
d) Paste
Shows how the worksheet will appear on paper
a) Page layout
b) Print Area
c) Normal View
d) Copy
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.
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
Log In | Sign Up / Register