shaunequa's EP2 flashcards Flashcards

Left-wing politics
Terms Definitions
1. To start a new line in a cell, press _____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.
a. ALT+ENTER
2. All of the following are valid Excel arithmetic operators except _____.a. ^
d. >
3. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.
b. 26
4. When an error occurs in a formula in a cell, Excel displays the _____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
c. Trace Error
5. The _____ button lists formatting options following an insert of cells, row, or columns
d. AutoCorrect Options
6. In Excel, functions can be entered using any of the following methods except the _____
b. keyboard or mouse
7. To save a saved workbook using a new name or on a different drive, _____.
b. click Save As on the File menu
8. If Range Finder is used to change cells referenced in a formula, press the _____ key to complete the edit.
c. ENTER
9. A(n) _____ dollar sign always appears immediately to the left of the first digit
c. floating
10. The _____ in the Conditional Formatting dialog box can be used to remove one or more active conditions.
b. Delete button
11. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of _____.
a. 8.43 characters, or 64 pixels
12. To set a column width to best fit, _____ boundary of the column heading above row 1.
d. double-click the right
13. To instruct Excel to display a hidden column, position the mouse pointer to the _____.a. left of the column heading boundary where the hidden column is located and then drag
d. double-click the right
14. To check the spelling of the text in a single cell, _____ to make the formula bar active and then click the Spelling button on the Standard toolbar
c. double-click the cell
15. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks _____.
b. the remainder of the worksheet, including notes and embedded charts
16. Rather than click the Next and Previous buttons to move from page to page in the Preview window, the _____ keys can be pressed
c. PAGE UP and PAGE DOWN
17. When the mouse pointer shape is a magnifying glass, the previewed page in the Preview window can be clicked to carry out the function of the _____ button.
b. Zoom
18. Excel does not display the Print dialog box shown in the accompanying figure when the _____ is used.
d. Print button on the Standard toolbar
19. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print the selected range
a. Selection option button
20. In the Print dialog shown in the accompanying figure, the _____instructs Excel to print the worksheet currently on the screen or the selected worksheets.
c. Active sheet(s) option button
21. In the Print dialog box shown in the accompanying figure, the _____ instructs Excel to print all the worksheets with content in the workbook.
a. Entire workbook option button
22. To toggle between the values version and the formulas version of a worksheet, hold down the _____ key.
c. CTRL key while pressing the ACCENT MARK (`)
23. When Excel first is installed, all of the following Web queries are available except _____.
d. MSN MoneyCentral Investor Commodity Prices
24. To change the stock symbols Excel uses when refreshing the data in a Web query, click the _____ on the External Data toolbar
b. Query Parameters button
25. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then _____.
d. press the ENTER key
1. One of the reasons Excel is such a valuable tool is that a(n) _________________________
F0RMUlA
2. The _________________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
EQUALI SIGN
3. When more than one arithmetic operator is involved in a formula, Excel follows the same basic _________________________ that is used in algebra.
ORDER OF OPERATIONS
4. _________________________ allows cells to be selected for use in a formula by using the mouse.
POINT MODE
5. Excel can identify certain actions to take on specific data (including dates, financial symbols, people’s names, and more) using _________________________.
SMART TAG
6. Excel places a small purple triangle, called a(n) _________________________, in a cell to indicate that a smart tag is available.
SMART TAG INDICATOR
7. A blank cell in Excel has a numerical value of _________________________.
ZERO
8. A(n) _________________________ takes a value or values, performs an operation, and returns a result to the cell.
FUNCTION
9. The values used with a function are called _________________________.
ARGUMENTS
10. The _________________________ is a function that sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range.
AVERAGE FUNCTION
11. Excel has a function called the _________________________ that displays the highest value in a range
MAX FUNCTION
12. The _________________________ is a function used to determine the lowest number in a range.
MIN FUNCTION
13. Excel’s _________________________ can be used to check which cells are referenced in the formula assigned to the active cell.
RANGE FINDER
14. The _________________________ is a format that displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and rounds numbers to the nearest cent.
CURRENCY STYLE FORMAT
15. A(n) _________________________ is a dollar sign that appears to the far left in a cell, often with spaces between it and the first digit.
FIXED DOLLAR SIGN
16. A(n) floating dollar sign is a dollar sign that appears immediately to the left of the first digit in a cell with no _________________________.
SPACE
17. The _________________________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredth
COMMA STYLE FORMAT
18. Formatting that appears only when the value in a cell meets specified conditions is called _________________________.
CPNDITIONAL FORMATTING
19. A(n) _________________________, which is made up of two values and a relational operator, is true or false for each cell in a range
CONDITION
21. A(n) _________________________ is a dot on the screen that contains a color.
PIXEL
22. _________________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column
BEST FIT
23. _________________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.
HIDING CELLS
24. Excel has a(n) _________________________ that can be used to check a worksheet for spelling errors
SPELL CHECKER
25. When Excel’s spell checker finds a word that is not in the standard or custom dictionaries, it displays the word in the _________________________, as shown in the accompanying figure.
SPELLING DIALOG BOX
26. To correct a word throughout a worksheet, click the _________________________ in the Spelling dialog box shown in the accompanying figure
CHANGE ALL BUTTON
28. Click the _________________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change
ADD TO DICTIONARY
29. By _________________________ the worksheet, you see exactly how it will look without generating a printout.
PRIEWVING THE WORKSHEET
30. _________________________ means the printout is printed across the width of the page.
PORTRAIT ORIENTATION
31. _________________________ means the printout is printed across the length of the page.
LANDSCAPE ORIENTATION
32. The _________________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.
VALUES VERSION
33. The _________________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.
FORMULAS VERSION
34. _________________________ is the process of finding and correcting errors in a worksheet.
DEBUGGING
35. The most popular service on the Internet is _________________________, which is the electronic transmission of messages and files to and from other computers using the Internet.
EMAIL
1. If a formula is entered into cell F4 to multiply the values in cells D4 and E4, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F4
TRUE
2. The arithmetic operator, ^, directs Excel to perform the division operation
FALSE
1. Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.
FALSE
1. Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.
FALSE
/ 62
Term:
Definition:
Definition:

Leave a Comment ({[ getComments().length ]})

Comments ({[ getComments().length ]})

{[comment.username]}

{[ comment.comment ]}

View All {[ getComments().length ]} Comments
Ask a homework question - tutors are online