This includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet.
What is a requirements document?
100
This contains areas where you can view and enter document properties.
What is the Document Information Panel?
100
This presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
What is the status bar?
100
Excel can draw a variety of these.
What is charts?
200
allows users to enter, calculate, manipulate, and analyze data.
What is a worksheet?
200
Typically contains information that is analogous to items in a list, such as products sold by a company.
What is a row?
200
This symbol means there is too many numbers in a cell and the column needs to be larger.
What is ####?
200
By using this option, located on the status bar, you easily can obtain a total, an average, or other information about the numbers in a range.
What is AutoCalculate?
200
organizes and stores data within worksheets.
What is a table?
300
The first step in creating an effective worksheet is to make sure you understand these.
What is requirements?
300
Typically contains descriptive information about items in rows, or contains information that helps to group the data in the worksheet.
What is a column?
300
Excel displays the active cell reference in this.; located on left side of the formula bar.
What is the Name box?
300
The easiest way to copy things from one cell to another is to use this.; This is the small black square located in the lower-right corner of the heavy boarder around the active cell.
What is a fill handle?
300
A number or letter above each row or column identifying each is called this.
What is a heading?
400
The default (preset) view is this.
What is normal view?
400
This gallery shoes common gallery choices on the Ribbon rather than in a drop-down list.
What is an in-Ribbon gallery?
400
A cell is referred to by its unique address, otherwise known as this.
What is a cell reference?
400
The cell into which you can enter data.
What is an active cell?
400
The basic unit of a worksheet into which you enter data is called this.
What is a cell?
500
allows users to save Excel worksheets or parts of a worksheet in HTML format, so a user can view and manipulate the worksheet using a browser.
What is Web Support?
500
A 3-D Clustered Column chart drawn on the same worksheet as the data is called this.
What is an embedded chart?
500
If you prefer using the keyboard, instead of the mouse, you can press the ALT key on the keyboard to display this for certain commands.; Also called a keyboard code icon.
What is a Key Tip badge?
500
This is a feature that allows you to point to a gallery choice and see its effect in the worksheet without actually selecting the choice.
What is live preview?
500
As you type, Excel displays the entry in this.; appears below the Ribbon.