This cannot exist in Excel without an associated PivotTable
What is a PivotChart
100
magnify or shrink the appearance of a worksheet or chart with this
What is zoom
100
These do not print when all or a portion of the worksheet is printed
What are worksheet backgrounds
100
Fewer worksheets will show if this happens.
What is the worksheet names are longer
100
A workbook that contains patterns for creating other workbooks
What is template
200
Copying a formula causes Excel to adjust this so the new formulas contain references corresponding to the new locations
What are references
200
This allows multiple people to work independently on the same workbook at the same time, if they are in a networked environment
What is sharing
200
A single character, word, or phrase is referred to as this
What is a string
200
Number of worksheets that are in a new workbook if you do not set a default
What is 3
200
This is how you delete a table
What is select the table and press the delete button
300
Excel allows you to place limitations on the values of cells by doing this.
What is data validation
300
This appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet
What is the mini toolbar
300
Both workbooks will scroll together when this is selected.
What is Synchronous Scrolling button
300
Saving the workbook frequently is important for this reason
What is if you lose power, the worksheet could be lost
300
When an error occurs in a formula in a cell, Excel displays this button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
What is Trace Error
400
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell
What is What If Analysis
400
The process of finding and correcting errors in a worksheet
What is debugging
400
Excel continually reviews the workbook for errors in formulas as you create or manipulate it with this...
What is background formula checking
400
A horizontal page break is indicated by this
What is a dotted line
400
The max number of worksheets a workbook can hold
What is it depends on the computers memory
500
To search only a specified range of a worksheet, select the range before invoking this...
What is the find command
500
This type of worksheet shows the actual formulas you have entered, rather than the resulting values.
What is the formulas version
500
You can check formulas for errors by clicking the this button on the Formulas tab on the Ribbon
What is error checking
500
Entering a number once and having it be entered in the same cell on all worksheets
What is drilling an entry
500
Excel allows you to add this many conditional formats to a range.