Question | Answer |
Columns | appear vertically and are identified by letters at the top of the worksheer 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 worksheer 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 prompted to save the file |
Autofit | Determines the best width for a column or the best height for a row, based on its contents |
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 od design elements, including fonts, colors, and the other effects. |
CTRL + U | Underline |
CTRL + B | Bold |
CTRL + I | Italics |
Wrapped text | the row height will automatically adjust to show all of the lines of text. Test wraps within a cell like in a word processing documentm 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 to select the row where you want the new row to appear, then click the insert button |
Landscape orientation | wider than they are long |
Portrait orientation | longer than they are wide |
Header | text that prints in the top margina of each page |
Footer | text that prints in the bottom margina of each page |
Identify three ways to enter a formula into a cell | enter, tab, enter buttom on the formula bar |
Show an example of multiplication | A1*7 |
Show an example of division | A1/2 |
Show an example of exponenatiaton | 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, movng outward |
Control + ` (grave accent) | Used to switch bewtween showing formulas and showings formula results in a worksheer |
Show an example of the SUM function | SUM(F1:F10) |