Excel Chapter 2: End-of-Chapter Quiz
with Verified Answers
Function ✔✔A predefined formula that adds all the numbers in a selected range.
Statistical functions ✔✔Excel functions, such as AVERAGE, that are useful to an
...
Excel Chapter 2: End-of-Chapter Quiz
with Verified Answers
Function ✔✔A predefined formula that adds all the numbers in a selected range.
Statistical functions ✔✔Excel functions, such as AVERAGE, that are useful to analyze a group
of measurements
SUM function ✔✔A predefined formula that adds all the numbers in a selected range.
AVERAGE function ✔✔An Excel function that adds a group of values and then divides the
result by the number of values in the group
MEDIAN function ✔✔An Excel function that finds the middle value that has as many values
above it in the group as are below it
MIN function ✔✔An Excel function that determines the smallest value in a range
MAX function ✔✔An Excel function that determines the largest value in a range
MEDIAN function (2)*Possible error ✔✔An Excel feature which, after typing an = (equal sign)
and the beginning letter or letters of a function name, displays a list of function names that match
the typed letters(s)
Logical Functions ✔✔A group of functions that test for specific conditions, and which typically
use conditional tests to determine whether specified conditions are true or false
Criteria ✔✔Conditions that you specify in a logical function
COUNTIF function ✔✔A statistical function that counts the number of cells within a range that
meet the given condition and which has two arguments- the range of cells to check and the
criteria
Logical test ✔✔Any value or expression that can be evaluated as being true or false
IF function ✔✔A function that uses a logical test to check whether a condition is met, and then
returns one value if true and another value if false
Comparison operator ✔✔Symbols that evaluate each value to determine if it is the same (=),
greater than (>), less than (<), or in between a range of values as specified by the criteria
Conditional Format ✔✔A format that changes the appearance of a cell based on a condition
Data bar ✔✔A shaded bar that provides a visual cue about the value of a cell relative to other
cells
NOW function ✔✔The function that retrieves and then displays the date and time from your
computer
Freeze panes ✔✔The command that enables you to select one or more rows or columns and then
lock them into place
Excel Table ✔✔A series of rows and columns that contains related data and that is manages
independently from other data
Sorting ✔✔The process of arranging data in a specific order based on the value in each field
Filtering ✔✔The process of displaying only a portion of the data based on matching a specific
value to show only the data that meets the criteria that you specify
Print titles ✔✔The Excel command that enables you to specify rows and columns to repeat on
each printed page
Sheet tabs ✔✔The labels along the lower border of the workbook window that identify each
worksheet
Summary sheet ✔✔The worksheets that contain the details of the information summarized on a
summary sheet
Detail sheets ✔✔The worksheets that contain the details of the information summarized on a
summary sheet
Paste ✔✔The action of playing cell contents that have been copies or moved to the clipboard
into another location
Flash Fill ✔✔The Excel command that recognizes a pattern in your data and then automatically
fills in the values when you enter examples of the desired output
Arguments ✔✔The values that an Excel function uses to perform calculations or operations
Paste Area ✔✔The target destination for data that has been cut or copied using the Office
Clipboard
Volatile ✔✔The term used to describe an Excel function that is subject to change each time the
workbook is opened
[Show More]
