Computer Information Systems Midterm
Absolute Cell Reference
A cell reference that refers to a cell by its fixed position in a worksheet
Data Marker
A column, bar, dot, area, pie slice or another symbol in a chart that represents a single data point
Conditional Format
A format that changes the appearance of a cell based on a condition
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
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
Axis
A line that serves as a frame of reference for measurement and that borders the chart plot area
Value Axis
A numerical scale on the left side of a chart that shows the range of numbers for the data points; y-axis
Autocomplete
An Excel feature which after typing an equal sign and the beginning letter(s) of a function name displays a list of function names that match the typed letters
Formula
An equation that performs mathematical calculations on values in a worksheet The cell content that performs computations Needs an equal sign plus other stuff Not every formula need a function
Workbook
An excel file that contains one or more worksheets Spreadsheet applications such as Excel produce files called workbooks
Cell Address
Another name for a cell reference
Value
Another name for a constant value
Spreadsheet
Another name for a worksheet A category of computer software applications that is useful for analyzing numeric data
Logical Test
Any value or expression that can be evaluated as being 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
=C6+Y3 is an example of a ___ cell entry
Formula
Row
Horizontal group of cells in a worksheet labeled with numbers
Constant Value
Numbers, text, dates, or times of day that you type into a cell
Data Series
Related data points represented by data markers
Data
Text or numbers in a cell
C+Y3 is an example of a ___ cell entry
Text/Label
Quarter 1 is an example of a ___ cell entry
Text/Label
Category Axis
The area along the bottom of a chart that identifies the categories of data; x-axis
Chart Area
The entire chart and all of its elements
=FunctionName(cell:cell)
The general syntax or structure of a formula that uses the SUM, AVERAGE, MIN or MAX function
What-if Analysis
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
Fill Handle
The small black square in the lower right corner of a selected cell
The date December 31, 2000 is an example of a ___ cell entry
Value
BUDGET.XLSX is the name of a ___
Workbook
Function
A predefined formula that performs calculations by using specific values in a particular order or structure Every function needs a formula
Bevel
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled
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 the criteria
Column
A vertical group of cells in a worksheet labeled with letters
Goal Seek
A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell
Statistical Functions
Excel functions such as AVERAGE, that are useful to analyze a group of measurements
Chart
Graphic representation of data in a worksheet
Relative Cell Reference
In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to
Cell
Intersection of a column and a row
Sheet Tabs
Labels along the lower border of the excel window that identifies each worksheet
Formula Auto-Complete
The Excel feature which after typing "=" and the first letter of a function displays a list of function names