COMP B5 - Excel Test
Freeze panes
A command that enables you to lock rows or columns in place
Conditional format
A format that changed the appearance of a cell based on a condition
Function
A predefined formula that performs calculations by using specific values in a particular order or structure
Formula
An equation that performs mathematical calculations on values in a worksheet
Workbook
An excel file that contains one or more worksheets
Spreadsheet
Another name for a worksheet
Cell address
Another name for cell reference
Value
Another name for constant value
Logical test
Any value or expression that can be evaluated as true or false
Cell content
Anything typed into a cell
Criteria
Conditions that you specify in a logical function
Number values
Constant values consisting of only numbers
Statistical functions
Excel functions, such as Average, that are useful to analyze a group of measurements
AVERAGE function
Function that adds a group of values then divides by the number of values in the group
COUNTIF function
Function that counts the number of cells within a range
MAX function
Function that determines largest value in a range
MIN function
Function that determines smallest value in a range
MEDIAN function
Function that finds the middle value
IF function
Function uses logical test to check whether condition is met, returns one value if true and another false
Logical functions
Functions that test for specific conditions, typically use conditional tests
Row
Horizontal group of cells in a worksheet
Cell
Intersection of a column and row
Sheet tabs
Labels that identify each worksheet
Constant value
Numbers, text, dates, or times of day that you typed into a cell
SUM function
Predefined formula that adds all the numbers in the selected range
Comparison operator
Symbols that evaluate each other if it is the same
Data
Text or numbers in a cell
Chart
The graphic representation of data in a worksheet
Fill handle
The small black square at the lower right corner of a selected cell
Column
Vertical group of cells in a worksheet
