click below
click below
Normal Size Small Size show me how
accel
| Question | Answer |
|---|---|
| Columns | Appear vertically and are identiefied by letter at the top of the worksheet window |
| Range reference- example | (A1:F1) |
| ###### | Number xetended beyond a cell's width |
| 3 ways to enter data ina a a a cell | Enter,tab, enter button in formula bar |
| wildcard(find/replace) | *(asterick) |
| Default | 100% |
| Print tab | Enabels yo to select the number of copies to print, a printer, the parts of the worksheets to print, and the way the printed worksheet will work. |
| What happens if you try to close a worksheet that has not been saved? | You are promted to save the file |
| Autofit | Determines the best width for a column or the best height for a row, based on its contest. |
| expain how to resize the width of several columns at once | select the columns you want to resize, then use the pointer to click and drag the right edge of one of the selected column headings. |
| How are the numbers displayed in a cell? | Right aligned |
| Merge & Center | center cell contents acroos several columns |
| Theme | Preset collection of design elements, elements, including fonts, color, and other effects. |
| CTRL +U | Underline |
| CTRL+B | Bold |
| CTRL+1 | Italics |
| Wrapped Test | ps within a cell like in a word procesing document, rather than spilling over into the next cell |
| CTRL+C | Copy |
| CTRL+V | Paste |
| How do you insert a row in an excel spreadsheet? | Click the row number t=to select the row where you want the new row to appear, then click the insert button |
| landscape orientation | Wider thatn they are long |
| portait orientation | Longer than they are wide |
| Header | text that prints in the toip margin of each page |
| footer | Text that prints in the bottum margin of each page |
| Identify three ways to enter a formula into a cell. | Enter, tabe, enter butoom margin of each page |
| show an example of multiplication | A1*7 |
| Show an example of division | A1/2 |
| Show an example of exponentiation | A1^3 |
| Order of evaluation | the sequence used to calculate the value of a formula |
| what is the order of operations when executing an excel Formula? | Inner most parentheses are evluated first,moving outward |
| Control+' (grave accent) | Used to switch between showing formulas and showing formula results ina worksheet |
| Show an example of the SUM function | SUM(F1:F10) |