=MAX(C4:C18) finds the lowest number in the range of cells from C4 through C18.
What is FALSE? Highest number - MIN = Lowest.
100
B14
What is a cell address? B is the column and 14 is the row
100
Name the 4 formulas used in spreadsheets and their symbols.
What are addition (+); subtraction (-); multiplication (*); division (/)?
100
Arrangement of cells in columns and rows used to organize, analyze, calculate and report information (usually in numerical form).
What is a spreadsheet?
200
Define label and value.
What is used for cells that contain text or numbers that will NOT be used in calculation (label); used for data that has the potential to be used in calculations (value).
200
A mixed cell reference is a combination of an absolute and relative cell.
What is TRUE? i.e. A$24
200
Used to arrange data in alphabetical or chronological order.
What is a sort?
200
Formula versus function.
What is instructs the formula for perform a calculation and always begins with = (formula); Shortcut for a formula (function) some examples are SUM, AVG, MAX and MIN.
200
Symbol used to indicate an absolute cell reference (unchanging).
What is $?
300
Applied to spreadsheet components for the purpose of organizing and clarifying information.
What is formatting?
300
Freeze panes allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges.
What is TRUE?
300
Defaults for labels and values.
What is left (labels) and right (values)?
300
Y-axis vs. X-axis.
What is the left or vertical side of a graph or chart that contains numerical data (Y-axis) and the bottom or horizontal side of a graph or chart and contains category information (X-axis)?
300
Name 4 advanced spreadsheet functions.
What are IF statements, Date functions, LookUp Functions, List and Count?
400
Column Chart
What is used to make comparisions and generalizations about groups of data?
400
Businesses do not need to use charts or graphs to communicate and clarify information in a spreadsheet.
What is FALSE?
400
These are used to clarify data categories or values.
What is a tick mark?
400
Line chart
What is shows trends or changes in data over time i.e sales growth?
400
Used to complete a column or row of consecutive data.
What is fill series?
500
Embedded vs. Linked charts.
What is one that appears on the same sheet as the spreadsheet data it represents and does not change as information is updated (embedded) and will reflect changes made to the spreadsheet it represents (linked)?
500
The horizontal or vertical line that extends across the plot area of a graph for the purpose of adding clarification to the data is called a plot area.
What is FALSE? (gridline) A plot area is the background portion of a graph.
500
Describe a pie chart and how an exploded pie chart is different.
What is used to represent the contribution of each component of one series of data to the whole (pie chart) and the individual components are enhanced (exploded)?
500
What do you do when you see #### located in a cell.
What is change the column width to adjust to the longest entry?
500
Merge cells
What is used to combine two or more cells -- usually for titles of spreadsheets?