click below
click below
Normal Size Small Size show me how
Comupeter Apps Final
Study Guide
| Question | Answer |
|---|---|
| Columns | Appear vertically and are identified by letters at the top of the worksheet window |
| Rows | Appear horizontally and are identified by numbers on the left side of the worksheet window |
| range refernece- example | (A1:F1) |
| ### | Numbers extend beyond a cell's width |
| 3 ways to enter data in a cell | Enter, tab, enter button in formula barr |
| Wildcard (find/replace) | * |
| Default magnifications | 100% |
| Print tab | Enables you to select the # of copies to print |
| What happens if you try to close a wksht that has not been save | You are prompted to save the file |
| Auto Fit | Determines the best width for a column or the best height for a row based on its contents |
| Resize width of several columns | Select, use pointer to click and drag |
| How are numbers displayed in a cell | Right aligned |
| Merge & center | Centers cell contents |
| Theme | Preset collection of design ellements |
| CTRL U | Underline |
| CTRL B | Bold |
| CTRL I | Italics |
| Wrapped text | Row height auto adjusts to show all lines of text |
| CTRL C | Copy |
| CTRL V | Paste |
| insert row in Excel | Click row number and insert |
| Landscape | Wide |
| Portrait | Long |
| Header | Top margin text |
| Footer | Bottom margin text |
| 3 ways to enter a formula into a cell | Enter, tab, enter button on formula bar |
| Multiplication | A1*7 |
| Division | A1/2 |
| Exponentation | A1^3 |
| Order of evaluation | sequence used to calculate the value of a formula |
| order of operations | Parenthesis first moving outward |
| orderof evaluation | sequence used to caclculate the value of a formula |
| CTRL ' | swtich between formulas and formula results |
| SUM | SUM(F1:F10) |
| Title slide | Introduces presentation |
| Transition | Way a slide appears on the screen |
| Animation | effect to make objects move during a slide show |
| How many slides can be printed with Handouts | 2-9 slides per page |
| PowerPoing file extension | .pptx |
| Placeholders | boxes with dotted borders that contain content and reside within a slide layout |
| Slide Master View | gives consisten look |
| Insert slide | Cilck insert table |
| Access | Database management system |
| Database | collection of objects |
| datasheet | table displays its data |
| move feilds | tab |
| move back a feild | shit tab |
| best fir | auto rezises column to best width for the column |
| rearrange in datasheet view | click and drag |