Microsoft Excel Chapter 2
Pane
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars
SUM Function
A predefined formula that adds all the numbers in a selected range of cells
Function
A predefined formula that preforms calculations by using specific values in a particular order or structure
Excel Table
A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet
COUNTIF Function
A statistical function that counts the number of cells within a range that meet the given condition- the criteria that you provide
Sheet Tabs
Identify each worksheet in a workbook and are located along the lower left edge of the workbook window
Statistical Functions
Include the AVERAGE, MEDIAN, MIN, and MAX functions, and are useful to analyze a group of measurements
Navigate
Move among worksheets
Paste Options Gallery
Opens when you paste; includes Live Preview to preview the paste formatting that you want
Paste
The action of placing cell contents that have been copied or moved to the Office Clipboard into another location
Comparison Operators
Used to compare values
IF Function
Uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false
Detail Sheets
Where the details of the information is contained
Logical Functions
A group of Excel functions, used to test for specific conditions
Summary Sheet
A worksheet where totals from other worksheets are displayed and summarized
Average Function
Adds a group of values, and then divides the result by the number of values in the group
Logical Test
Any value or expression that you can evaluate as being true or false
Sort
Arrange all the data in a specific order- in ascending or descending order
Drag and Drop
Cell contents can be moved from one location to another
Conditional Format
Changes the appearance of a cell based on a condition- a criteria
MAX Function
Determines the largest value in a selected range of values
MIN Function
Determines the smallest value in a selected range of values
Filter
Display only a portion of the data based on matching a specific value
Freeze Panes
Enables you to select one or more rows or columns and then freeze (lock) them into place
Print Titles
Enables you to specify rows and columns to repeat on each printed page
Scale to Fit
Enables you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages
Data Bar
Provides a visual cue to the reader about the value of a cell relative to other cells
NOW Function
Retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell
Find and Replace
Searches the cells in a worksheet-or in a selected range- for matches, and then replaces each match with a replacement value of your choice
Criteria
Specified conditions
Volatile
The date and time will not remain as entered, but rather the date and time will automatically update each time you open this workbook
Paste Area
The target destination for data that has been cut or copied using the Office Clipboard
Arguments
The values that an Excel function uses to preform calculations or operations
