CELL REFERENCES
The address of a cell indicating its column and row location.
What are cell references?
An expression that returns a value.
What is a formula?
A range of values plotted as a single unit on a chart.
What is a data series?
Text printed in the top margin of each page.
What is a header?
A grid of rows and columns used to enter and calculate data.
What is a spreadsheet?
This type of reference changes when copied to another cell.
What are relative cell references?
A named operation that returns a value.
What is a function?
The range that contains the selected data displayed in a chart.
What is a data source?
Text printed in the bottom margin of each page.
What is a footer?
A file used to store worksheets.
What is a workbook?
This type of reference includes dollar signs and does not change when copied.
What is an absolute cell reference?
A function that places the current date in a cell.
What is the TODAY function?
Numerical values that can be used in mathematical calculations.
What is number data?
This orientation means the page is wider than its length.
What is landscape orientation?
Sheets containing formulas, values, text, and graphics within a workbook.
What are worksheets?
This type of reference contains both relative and absolute parts.
What is a mixed cell reference?
A function that displays the current date and time.
What is the NOW function?
A combination of letters, numbers, and symbols forming words or sentences.
What is text data?
This view shows where page breaks are located in a worksheet.
What is Page Break View?
Displays only data that meets certain criteria.
What is filtering?
A symbol that indicates the relationship between two values.
What is a comparison operator?
This function creates a date using year, month, and day arguments.
What is the DATE function?
Tiny charts displayed in the background of a cell.
What is a sparkline?
This view shows how the worksheet will appear when printed.
What is Page Layout View?
Sorts data by text, numbers, formatting, or dates in one or more columns.
What is sorting?