SPREADSHEET FOUNDATIONS
A grid of rows and columns where data is entered and calculated.
What is a spreadsheet?
Cell references that change when copied to another location.
What are relative 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?
This view shows the regular contents of the worksheet.
What is Normal View?
Applies formatting only when a cell meets a specified condition.
What is conditional formatting?
A file used to store worksheets.
What is a workbook?
A reference that does not change when copied and includes dollar signs.
What is an absolute cell reference?
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?
This view displays formulas instead of calculated results.
What is Formula View?
Displays only data that meets certain criteria.
What is filtering?
Sheets containing formulas, values, text, and graphics within a workbook.
What are worksheets?
A reference that contains both relative and absolute components.
What is a mixed cell reference?
Works with values that are either true or false.
What is a logical function?
Recognized formats for entering dates and times in a spreadsheet.
What is date and time data?
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?
The address of a cell indicating its column and row location.
What are cell references?
A symbol that indicates the relationship between two values.
What is a comparison operator?
This function places the current date in a cell.
What is the TODAY function?
This function creates a date using year, month, and day arguments.
What is the DATE function?
This view displays the location of page breaks within a worksheet.
What is Page Break View?
Shortcuts that link to different locations.
What are hyperlinks?
A combination of letters, numbers, and symbols that form words and sentences.
What is text data?
A numerical value that can be used in mathematical calculations.
What is number data?
This function displays the current date and time.
What is the NOW function?
Tiny charts displayed in the background of a cell.
What is a sparkline?
Allows a user to specify where a page break is located.
What is a manual page break?
Text printed at the top and bottom margins of a page.
What are header and footer?