Multiple Choice
Sorting arranges records in a table by:
a. using filter arrows.
b. the value in field(s) within a table.
c. permanently removing extraneous data.
d. the row number.
The value in field(s) within a table.
Uses the computer's clock to display the current date and military time that you last opened the workbook
What is the Now function?
This is a small line, column or win/loss chart contained in a single cell.
What is a sparkline?
A region of a worksheet with formulas dependent on values from an input area
What is an output area?
T/F The fill handle is a small green cross located to the right of a chart.
False; the fill handle is a small green square at the bottom-right corner of a cell.
Freezing rows and/or columns:
a. keeps them visible as you scroll through a worksheet.
b. collects structured, related data in columns and rows.
c. keeps all worksheets on the screen.
d. enables you to adjust settings to control how the worksheet will print.
Keeps them visible as you scroll through a worksheet.
Finds the midpoint value, which is the value that one half of the data is above or below.
What is the median function?
Contains a single chart and no spreadsheet data.
What is a chart sheet?
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 For a straightforward, basic mathematical expression, it is best to use a formula like =C16*C17.
True.
A mixed cell reference:
a. occurs when a formula directly or indirectly refers to the cell containing the formula.
b. contains absolute or relative cell references, but not both.
c. causes a potential error
d. contains both an absolute and a relative cell reference.
Contains both an absolute and a relative cell reference
This arranges records in a table by the value in the field(s) within the table.
What is the sorting function?
A horizontal line that borders the plot area to provide the frame of reference for measurement.
What is the X-axis.
A file containing related worksheets.
What is a workbook?
T/F: Absolute references are designated by "$" in the formula.
Ture.
All formulas must begin with a:
a. $
b. *
c. =
d. brackets
=
The process of displaying only records that meet special conditions
What is filtering?
Compares values across categories suing vertical columns.
What is a column chart?
An electronic file of a grid of columns and rows of related data.
What is a spreadsheet?
T/F: A workbook can have multiple worksheets.
Ture.
a. tally the number of the number of cells in a range that contain values you can use in calculations.
b. tally the average.
c. tally the mean.
d. tally the median.
a. a. tally the number of the number of cells in a range that contain values you can use in calculations.
Controls the sequence in which Excel performs arithmetic operations
What is the order of preference?
A group of adjacent or contiguous cells in a workbook.
What is a range?
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 will miss remote learning.
Ture; Simone, the cat, will miss remote learning, although her mother will not!