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 |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |