click below
click below
Normal Size Small Size show me how
Computer Apps11
Excel
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 reference - example | (A1:F1) |
##### | Numbers extend beyond a cell's width |
3 ways to enter data in a cell | Enter tab, enter button in formula bar |
Wildcard (find/replace) | * (asterisk) |
Default magnification | 100% |
Print tab | Enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look. |
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 colum or the best height for a row, based on its contents |
Explain 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 numbers displayed in a cell? | Right aligned |
Merge & Center | Centers cell contents across several columns |
Theme | Preset collection of design elements, including fonts, colors, and other effects. |
CTRL + U | Underline |
CTRL + B | Bold |
CTRL + I | Italics |
Wrapped text | With wrapped text, the row height will automatically adjest to show all of the lines of text. Text wraps within a cell like in a word processing document, rather than spilling over into the next cell. |
CTRL + C | Copy |
CRTL + V | Paste |
How do you insert a row in an Excel spreadsheet? | Click the row number to select the row where you want the new row to appear, then click the insert button |
Landscape orentation | Wider than they are long |
Portrait orientaion | Longer than they are wide |
Header | Text that prints in the top margin of each page |
Footer | Text that prints in the bottom margin of each page |
Identify three ways to enter a formula into a cell | Enter, tab, enter button on the formula bar |
Show an example of multiplication | A1 * 7 |
Show 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 evaluated first, moving outward |
Control + `(grave accent) | Used to switch between showing formulas and showing formula results in a worksheet |
Show an example of the SUM function. | SUM(F1:F10) |