click below
click below
Normal Size Small Size show me how
CT Excel 2010
Excel Quiz Review
| Question | Answer |
|---|---|
| A(n) ________ is a pre-written formula that is built into Excel. | Function |
| The ________ alerts Excel that you are entering a FORMULA or FUNCTION and not text. You start every formula or function with this. | equal sign |
| What is the name of the vertical blinking line that indicates where the next typed character will appear? | Insertion Point |
| By default, Excel positions TEXT in a cell _________. | left-aligned |
| The basic unit of a worksheet into which you enter data is called a ___________. | Cell |
| Excel opens a new workbook with ___________ worksheets. | 3 |
| __________ cells involves creating a single cell by combining two or more selected cells. | Merging |
| To save a workbook, use the shortcut keys ________. | CTRL + S |
| What is the difference between a workbook and a worksheet? | A workbook is the entire document with all combined sheets. A worksheet is one individual sheet. |
| Excel automatically positions numbers in a cell _______________. | right-aligned |
| A range of cells is __________________. | A group of cells |
| A ___________________ _______________ includes a needs statement, a source of data, a summary of calculations, and any other special requirements. | Requirements Document |
| A cell is ______________. | Where a row and column meet. |
| How do we name a cell (letter or number first?) | Letter first, number second |
| What is a row (letter or number). | Number |
| What is a column (letter or number). | Letter |
| A selected cell is called the __________. | Active cell |
| The ___________ box displays the active cell reference. | Name |
| A ___________ conveys a visual representation of data. | Chart |
| To copy a formula or function down to adjacent cells you click and drag the little box in the bottom right hand corner of the cell containing the formula called the _________________. | Fill handle |