Multiple Choice
Sorting arranges records in a table by:
using filter arrows
the value in field(s) within a table
permanently removing extraneous data
the row number
The value of the field(s) within a table.
Finds the midpoint value, which is the value that one half of the data is above or below.
What does the Median function do?
Is a vertical line that borders the plot area to provide a frame of reference for measurement.
What is the Y-axis?
An electronic file of a grid of columns and rows of related data.
What is a spreadsheet?
T/F the chart area in Excel contains the entire chart and all of its elements.
True.
A small line, column or win/loss chart contained in a single cell.
What is a sparkline?
Controls the sequence in which Excel performs arithmetic operations.
What is the order of precedence in Excel?
T/F the formula =C16*C17 is an example of a basic mathematical expression.
True.
A small green square at the bottom-right corner of a cell.
What is the fill handle?
A collection of structured, related data in columns and rows.
What is a dataset?
T/F A file containing related worksheets is a workbook.
True.
Uses the computer's clock to display the current date and military time that you last opened the workbook.
What is the Now function?
Indicates a cell's specific location and the reference does not change when you copy the formula.
What is an absolute cell reference?
T/F A formula is a combination of cell references, operators, values, and/or functions used to perform calculations.
True.
Indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula.
What is a relative cell reference?
T/F Simone, the cat, is going to miss her duties as class mascot.
True.