Term
|
Definition
| Keyboard command to create a new workbook |
|
|
Term
| The cursor moves to the top of the next column |
|
Definition
| You select a range that includes several rows and columns, then enter information into the cells. When you enter information into the last selected cell in a column, you press enter. What happens? |
|
|
Term
| It confines the movement of the active cell to the selected range |
|
Definition
| What is the advantage of selecting rows and columns before entering information? |
|
|
Term
|
Definition
| What is the defalut number format for cells? |
|
|
Term
|
Definition
| Number format where numbers display exactly as you type them and trailing zeroes do not display even if you type them |
|
|
Term
|
Definition
| symbols with which you can specify the type of calculation you want to perform in a formula |
|
|
Term
|
Definition
| symbol that represents multiplication |
|
|
Term
|
Definition
| I want to multiply cells b3 and d3 in cell E3. What do I write? |
|
|
Term
|
Definition
| symbols representing basic mathematical operations--addition, subtraction, multiplication, division, percent, and exponentiation |
|
|
Term
|
Definition
| another name for subtraction |
|
|
Term
|
Definition
| operator symbol for addition |
|
|
Term
|
Definition
| operator symbol for subtraction |
|
|
Term
|
Definition
| operator symbol for division |
|
|
Term
|
Definition
| operator symbol for percent |
|
|
Term
|
Definition
| operator symbol for expnentiation |
|
|
Term
|
Definition
| refers to cells by their position in relation to the cell that contains the formula |
|
|
Term
|
Definition
| refers to cells by their fixed position in the worksheet--their colum and row number |
|
|
Term
|
Definition
| T or F: A relative cell refeence automatically adjusts when a formula is copied. |
|
|
Term
|
Definition
| T or F: An absolute cell reference automatically adjusts whena formula is copied |
|
|
Term
|
Definition
What is the formula to calculate a percentage?
a) amount/total = percentage
b) total/amount = percentage
c) total/percentage = amount
d) percentage/amount = total |
|
|
Term
|
Definition
| You answered 42 questions correct out of 50. What percentage of the answers were correct? |
|
|
Term
|
Definition
| formula displays in the cell, with the two referenced cells displayed in color and bordered with the same color. Useful in verifying formulas or quickly positioning the insertion point within the cell to edit |
|
|
Term
|
Definition
| symbol used by Excel to denote an absolute cell reference |
|
|
Term
|
Definition
| part of a whole expressed in hundredths |
|
|
Term
|
Definition
| command that displays text on multiple lines within a single cell when the column is not wide enough to display all the cell's content |
|
|
Term
|
Definition
| charts that show the relationship of each part to a whole |
|
|
Term
|
Definition
| workbook sheet that contains only a chart |
|
|
Term
|
Definition
| the combination of chart elements--title, legend, labels--that you want to display |
|
|
