Workbooks & Worksheets
When you see these, it means your columns need to be adjusted.
What are # signs?
If you know the result you want a formula to produce, you can use this to determine the value of a cell on which the formula depends.
What is Goal Seek?
This type of chart is a good way to compare values side by side.
What is a column or cylinder chart?
A formula that contains a reference back to itself is called this.
What is a circular reference?
A company may choose this as a standard what so that all of their documents have a similar appearance.
What is a theme?
This command allows you to keep the top row or first column in place so they are always visible.
What is Freeze rows and columns?
Values in cells that you can change to determine new values for formulas.
What is Assumptions?
This type of chart is a good choice because it shows trends over a period of time for each row of data.
What is a sparkline chart?
You can easily obtain a total, an average, or other information about the numbers in a range by using this.
What is the AutoCalculate area on the status bar.
This is a collection of rules that define which mathematical operations take precedence over the others in expressions with multiple operations.
What is the order of operations?
If you choose another option on this menu, Excel changes the contents of the destination range.
What is Auto Fill Options Menu.
When new data is entered, Excel not only recalculates all formulas in a worksheet but also does this.
What is redraws any associated charts?
This type of chart allows the user to see how the various expense categories compare with each other each month, and across months.
What is a clustered column chart?
When a number is entered with this, Excel displays it with the assigned format.
What is a format symbol? (E.g., $, Comma, %)
This includes the needs, source of data, summary of calculations, and chart information.
What is a requirements document?
Using this type of date results in the date updated whenever the worksheet is opened.
What is the system date?
What you call the process of finding and correcting errors in the worksheet.
What is Debugging?
Excel allows you to use this chart feature to allow more in-depth examination of subsets of data by doing this.
What is apply chart filters?
In Excel, you use this function when you want to assign a value to a cell based on a Boolean test.
What is the IF function?
With Excel, you can enter functions using one of five methods. Name two.
What is keyboard; touch gesture, or pointer; the Insert Function button in the formula bar; the Sum menu; the Sum button on the Formulas tab; and the Name box area in the formula bar.
You can move and insert a selected cell or range between existing cells by holding down what key while you drag the selection to the gridline where you want to insert the selected cell or range.
What is the Shift key? (You can also hold down the Ctrl + Shift keys while you drag the selection to the desired gridline.)
This type of formatting offers you the ability to automatically change how a cell appears based on the value in the cell.
What is conditional formatting?
When you want to see how each part relates to the whole, you use this type of chart.
What is a pie chart?
This reference instructs the paste operation to use the same cell reference as it copies a formula from one cell to another.
What is Absolute Referencing?
You can use this to override the order of operations.
What are parentheses?