Excel-lent Adventures
Includes a needs statement, a source of data, a summary of calculations, and any other special needs for the worksheet
What is a requirements document?
A predetermined combination of font, font size, and font color that you can apply to a cell.
What is a cell style?
This is a column or row in a datasheet and also the set of values represented in a chart.
What is a data series?
a cell address that refers to a specific cell and does not change when you copy the formula.
What is an Absolute cell reference?
If you want to know what the active cell is, you can look here.
What is the name box?
Different types of these are often used in a worksheet to make it more appealing to the reader and to relate or distinguish data in the worksheet.
What are fonts or font types?
Text and graphics that print at the top of each page.
What is a header?
This type of chart shows the contribution of each piece of data to the whole, or total, of the data.
What is a pie chart?
This feature looks for patterns in the data and automatically fills or formats data in remaining cells based on those patterns.
What is flash fill?
This is a decision-making tool in which changing input values recalculate formulas, in order to predict various possible outcomes.
What is what-if analysis?
What is a Column Letter and Row Number?
Commonly used rules with the ability to create your own custom rules and formatting to identify specific criteria within a cell or range of cells.
This type of chart allows you to compare values side by side, broken down by category.
What is a Clustered Column chart?
The sequence in which operators are applied in a calculation.
What is the mathematical order of operations?
When you do this, typically to column or row titles, Excel allows you to do this so that they will remain on the screen no matter how far down or to the right you scroll.
What is freeze a worksheet column and row?
A saved workbook is called this.
What is a file?
Displays the highest value in a range.
What is the MAX function?
This type of chart is typically used for viewing scientific, statistical, and engineering data.
What is a Scatter chart?
a cell address in a formula that automatically changes to reflect the new location when the formula is copied or moved.
What is a Relative cell reference?
When you want all of your documentation to have a similar appearance, you would apply this.
What is apply a theme?
When changing the column width, you can set the width manually or instruct Excel to do this.
What is best fit?
When assigned to a cell, this returns a number that corresponds to the system date and time beginning with December 31, 1899
What is the NOW function?
A simple way to display trends and variations in a range of data within a single cell in an eye-catching summary.
What is a sparkline chart?
In Excel, you use this when you want to assign a value to a cell based on a logical test.
What is the IF function?
When using Excel's Help, you can search for help by using the Help pane or this.
What is the Tell me box?