Test 1 B Flashcards
Header
Information that appears in the top margin of each printed page. it often includes summary information such as the filename and the data.
Print Titles
Information that appears on every printed page.
Banded Rows
Displays alternate rows in an Excel table with different fill colors.
Footer
Information that is printed in the bottom margin of each printed page.
Table Style
Formats the entire table as a single unit.
Margin
The space between the page content and the edges of the page.
Conditional Format
Applies formatting only when a cells value meets a specified condition.
Legend
A key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted.
Absolute Reference
Remains fixed when the cell formula is copied to a new location and has $ signs in front of the column letter and the row number.
Relative Reference
Interpreted in relation to the location of the cell containing the formula.
Required Arguments
in bold, are needed for the function to return a value.
Arguments
The numbers, text or cell references used by the function to return a value.
Optional Arguments
These are not required for the function to return a value.
SUM Function
Returns the sum of the values in the range.
MIN Function
Returns the minimum value in the range.
