Term
|
Definition
| Planning, recording system, analyzing and interpreting financial information. |
|
|
Term
| What is an accounting system? |
|
Definition
| A planned process for providing financial information that will be useful to management. |
|
|
Term
| What are accounting records? |
|
Definition
| Organized summaries of a business's financial activities. |
|
|
Term
| What often contributes to business failures or bankruptcy? |
|
Definition
| Inaccurate accounting records |
|
|
Term
| What is a service business? |
|
Definition
| A business that performs an activity for a fee. |
|
|
Term
| What is a proprietorship? |
|
Definition
| A business owned by one person. |
|
|
Term
| What does Encore Music do? |
|
Definition
| They rent office space and the instruments used to teach music lessons. |
|
|
Term
Assets= liability + Owners Equity
What is an asset? |
|
Definition
| Anything of value that is owned |
|
|
Term
| What are some examples of assets? |
|
Definition
|
|
Term
|
Definition
| Financial rights to the assets of a business. |
|
|
Term
|
Definition
| An amount to own a business. |
|
|
Term
| What is owner's equality? |
|
Definition
| The amount left over after subtracting liabilities from assets. |
|
|
Term
|
Definition
| A business activity that changes the assets, liabilities, or owner's equality. |
|
|
Term
|
Definition
| A record summarizing all the information pertaining to a single item in the accounting equation . |
|
|
Term
| What is an account title? |
|
Definition
| The name given to an account. |
|
|
Term
| What is a Cash account for? |
|
Definition
| The Cash account is used to summarize information about the amount of money the business has available. It is also a asset account. |
|
|
Term
| What is an account balance? |
|
Definition
| The amount in an account. |
|
|
Term
|
Definition
| The account used to summarize the owner's equity in a business. It is also an owner's equity account. |
|
|
Term
| What is Encore Music capital account called? |
|
Definition
| It is called Barbara Trevino, Capital. This account summaries the owner's equity in Encore. |
|
|
Term
|
Definition
| Is applied when a business's financial information is recorded and reported separately from the owners personal financial information. |
|
|
Term
| 1-2- Unit of Measurement- |
|
Definition
| Is applied when business transactions are stated in numbers that have common values- which means using a common unit of measurement |
|
|
Term
|
Definition
| Financial statements are prepared with the expectations that a business will remain in operation indefinitely. |
|
|
Term
|
Definition
| A financial statement that reports assets, liabilities and owner's equity on a specific date. |
|
|
Term
| What are the major sections of a balance sheet? |
|
Definition
| The fist section is assets, which are on the left side of the accounting equation. And it is also on the left of the balance sheet. |
|
|
Term
| What are the major sections of a balance sheet? |
|
Definition
The second section is liabilities, and they are on the right side of the accounting equation, which means that they are on the right side of the balance sheet. The last section is owners' equity. This is also on the right side of the equation so that means it will be on the right side on the balance sheet. |
|
|
Term
|
Definition
| All media of exchange circulating in a country. |
|
|
Term
|
Definition
· Metallic currency- Coins
· Paper currency- Paper money or credit instruments (bonds, checks, even some types of loan papers)
· Government Currency- Money printed by a government. Bank issued by banks against their reserves.
· Deposit Currency-Includes checks. It's called this because that is how their value is redeemed.
· Bank Currency- Notes issued by banks again their reserves. |
|
|
Term
| How has the meaning of currency changed? |
|
Definition
| Before 1914( 1914-1918 was World War One), many countries had governments that did not issue paper money. Paper money was considered to be notes issued by large banks. However, in the U.S., paper currency meant the money that the government printed, and nothing else. After the war, the idea of a currency took on a broader meaning. It became closer to what it is like today. |
|
|
Term
|
Definition
· Coins were the most popular medium exchange. · Foreign money was very popular. · The Spanish dollar, called the Real, was the most popular because it had a high silver content. · Early American coins were imitations of Reals · There was paper money in the colonies too. · Most of it consisted of English or other foreign bank notes. |
|
|
Term
| 1. Microsoft Office Word is a(n) |
|
Definition
| d. full-featured word processing program that can be used to create and revise professional looking documents easily |
|
|
Term
| 2. The main elements of the C are the insertion point, end mark, mouse pointer, rulers, scroll bars, and status bar. |
|
Definition
|
|
Term
| 3. The b is a short horizontal line indicating the conclusion of a document. |
|
Definition
|
|
Term
| 4. In the above figure, the D is a special toolbar that displays a series of names, each of which represents a list of commands that can be used to perform tasks. |
|
Definition
|
|
Term
| 5. In the accompanying figure, a d contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar. |
|
Definition
|
|
Term
| 6. A A is not attached to an edge of the Word window; that is, it displays in the middle of the Word window and can be moved anywhere in the window |
|
Definition
|
|
Term
| 7. When the Language bar is B, it means that you do not see it on the screen but it will be displayed the next time you start your computer |
|
Definition
|
|
Term
| 8. The A, or typeface, defines the appearance and shape of letters, numbers, and special characters. |
|
Definition
|
|
Term
| 9. When Word flags a possible spelling or grammar error, it also changes the mark on the Spelling and Grammar Status icon to a C. |
|
Definition
|
|
Term
| 10. The paragraph mark (¶) is a formatting mark that indicates where the C was pressed |
|
Definition
|
|
Term
| 1. At any point while working with an Excel worksheet, a task pane can be opened or closed by clicking the Task pane command on the _____. |
|
Definition
|
|
Term
| 2. The active cell can be identified in all of the following ways except _____. |
|
Definition
| d. a block arrow displays in the center of the cell |
|
|
Term
| 3. When both the Standard toolbar and Formatting toolbar display on the same row, all of the buttons on either toolbar can be displayed by _____. |
|
Definition
| c. double-clicking the move handle on the left of each toolbar |
|
|
Term
| 4. When the Language bar is _____, it means it is displayed on the Windows taskbar. |
|
Definition
|
|
Term
| 5. The easiest way to select a cell (make it active) is to _____. |
|
Definition
| d. use the mouse to move the block plus sign to the cell and then click |
|
|
Term
| 6. To complete an entry into a cell, click the _____. |
|
Definition
|
|
Term
| 7. In Excel, a number can contain the characters |
|
Definition
a. 0 1 2 3 4 5 6 7 8 9 b. + - ( ) , / c. . $ % E e d. all of the above |
|
|
Term
| 8. When proposing a range of cells to sum using the SUM button, Excel first looks for a range |
|
Definition
| b. above the active cell and then to the left |
|
|
Term
| 9. The _____ is the small black square located in the lower-right corner of the heavy border around the active cell |
|
Definition
|
|
Term
| 10. When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format |
|
Definition
| c. Auto Fill Options button |
|
|
Term
| 11. The _____ defines the appearance and shape of letters, numbers, and special characters. |
|
Definition
|
|
Term
| 12. A character with a point size of 10 is about _____ of an inch in height. |
|
Definition
|
|
Term
| 13. To display the AutoFormat dialog box shown in the accompanying figure and format a range automatically, use the AutoFormat command on the _____. |
|
Definition
|
|
Term
| 14. In the AutoFormat dialog box shown in the accompanying figure, the Close button or the _____ terminates the current activity and closes the AutoFormat dialog box. |
|
Definition
|
|
Term
| 15. In the AutoFormat dialog box shown in the accompanying figure, the _____ allows additional formats, such as fonts or borders, to be deselected within an autoformat |
|
Definition
|
|
Term
| 16. The small _____ at the corners and along the sides of the rectangle that encloses an embedded chart indicate the chart is selected |
|
Definition
|
|
Term
| 17. The small box to the right of an embedded column chart contains the legend, which _____. |
|
Definition
| b. identifies the colors assigned to each bar in the chart |
|
|
Term
| 18. When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) |
|
Definition
|
|
Term
| 19. When you click the Tools button in the Save As dialog box, the _____ in the list that displays allows you to save a backup copy of the workbook, create a password to limit access to the workbook to be created, and carry out other functions |
|
Definition
| d. General Options command |
|
|
Term
| 20. A password entered in the Save As dialog box is _____ and can be up to 15 characters long. |
|
Definition
|
|
Term
| 21. The _____ can be used to quit Excel |
|
Definition
| a. Close button and Control-menu icon on the menu bar |
|
|
Term
| 22. Clicking None at the top of the AutoCalculate shortcut menu _____. |
|
Definition
| a. turns off the AutoCalculate area |
|
|
Term
| 23. When a cell containing an error is double-clicked, Excel switches to _____, the active cell contents display in the formula bar, and a flashing insertion point displays in the active cell. |
|
Definition
|
|
Term
| 24. Excel provides the Undo command on the _____ and the Undo button on the Standard toolbar, both of which can be used to erase the most recent cell entries |
|
Definition
|
|
Term
| 25. To clear an entire worksheet, click the _____ and then press the DELETE key. |
|
Definition
| d. Select All button on the worksheet or press CTRL+A |
|
|
Term
| 1. A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. |
|
Definition
|
|
Term
| .5. To identify a cell, specify the row number first, followed by the column letter |
|
Definition
|
|
Term
| 2. A new workbook opens with three worksheets, but additional worksheets can be added up to a maximum of 255. |
|
Definition
|
|
Term
| 3. A number above the worksheet grid, also called the row heading, identifies each column. |
|
Definition
|
|
Term
| 4. A letter on the left side of the worksheet grid, also called the column heading, identifies each row. |
|
Definition
|
|
Term
| . The mouse pointer appears as a block arrow whenever it is located in a cell on the worksheet. |
|
Definition
|
|
Term
| 7. The mouse pointer turns into the block plus sign whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns |
|
Definition
|
|
Term
| 8. Above and to the left of the worksheet window are scroll bars, scroll arrows, and scroll boxes that can be used to move the worksheet window around. |
|
Definition
|
|
Term
| 9. To the right of the sheet tabs at the bottom of the screen is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs. |
|
Definition
|
|
Term
| 10. The menu bar, Standard toolbar, Formatting toolbar, formula bar, and Ask a Question box display at the bottom of the screen, below the worksheet window and above the Windows taskbar. |
|
Definition
|
|
Term
| 11. If a command on a menu with an arrow to its right is pointed to, Excel displays a submenu from which a command can be chosen |
|
Definition
|
|
Term
| 12. When a menu name is clicked on the menu bar, a short menu displays listing all the commands associated with a menu |
|
Definition
|
|
Term
| 13. A full menu lists only the most recently used commands |
|
Definition
|
|
Term
| 14. A dimmed command appears black or bright instead of gray, which indicates it is available for the current selection |
|
Definition
|
|
Term
| 15. A command with a medium blue shading to the left of it on a full menu is called a hidden command because it does not display on a short menu. |
|
Definition
|
|
Term
| 16. The menu bar never changes, regardless of the type of work being done in Excel |
|
Definition
|
|
Term
| 17. Mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel. |
|
Definition
|
|
Term
| 18. Keyboard indicators, such as CAPS (Caps Lock), NUM (Num Lock), and SCRL (Scroll) show which keys are engaged |
|
Definition
|
|
Term
| 19. To indicate whether commands will be spoken or cell entries dictated, use the Language bar. |
|
Definition
|
|
Term
| 20. Excel positions text right-aligned in a cell, meaning the entry displays to the far right in the cell. |
|
Definition
|
|
Term
| 21. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as these cells contain no data |
|
Definition
|
|
Term
| 22. If an error is noticed before clicking the Enter box or pressing the ENTER key, use the DELETE key to erase all the characters back to and including the one that is wrong. |
|
Definition
|
|
Term
| 23. Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers. |
|
Definition
|
|
Term
| 24. Text entered in a cell cannot be realigned |
|
Definition
|
|
Term
| 25. When the AutoSum button is clicked, Excel surrounds the proposed cells to sum with a moving border, called a marquee |
|
Definition
|
|
Term
| 26. After clicking the AutoSum button, if Excel proposes the wrong range to sum you can correct it by clicking the Redo button on the Standard toolbar. |
|
Definition
|
|
Term
| 27. When the fill handle is used to copy a cell to adjacent cells, the cell being copied is called the source area or copy area. |
|
Definition
|
|
Term
| 28. When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area. |
|
Definition
|
|
Term
| 29. If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the AutoSum button is clicked. |
|
Definition
|
|
Term
| 30. Regular, bold, underline, and italic are common font types |
|
Definition
|
|
Term
| 31. Excel can display characters in only three font colors: black, red, and blue. |
|
Definition
|
|
Term
| 32. When a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color |
|
Definition
|
|
Term
| 32. When a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color |
|
Definition
|
|
Term
| 32. When a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color |
|
Definition
|
|
Term
| 33. To use the name box to select any cell, click the Name box and enter the cell reference of the cell you want to select. |
|
Definition
|
|
Term
| 34. Excel derives the scale along the vertical axis of a chart, also called the y-axis or value axis, based on the values in the worksheet |
|
Definition
|
|
Term
| 35. With the range to chart selected, click the Chart Wizard button on the Standard toolbar to initiate drawing a chart. |
|
Definition
|
|
Term
| 36. Holding down the CTRL key while dragging a chart’s sizing handles snaps (aligns) the new border to the worksheet gridlines |
|
Definition
|
|
Term
| 37. Excel automatically selects the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart, also called the x-axis or category axis. |
|
Definition
|
|
Term
| 38. Excel offers 14 different chart types |
|
Definition
|
|
Term
| 39. Saving a backup copy of a workbook means that each time a workbook is saved, Excel copies the current version of the workbook on disk to a file with the same name, but with the words, Backup of, appended to the front of the file name |
|
Definition
|
|
Term
| 40. If, when a workbook is saved, a password is assigned but later forgotten, the workbook still can be accessed. |
|
Definition
|
|
Term
| 41. If a print area is not selected, Excel automatically prints all 16,777,216 cells in the worksheet. |
|
Definition
|
|
Term
| 42. To use the AutoCalculate area, select the range of cells containing the numbers you want to check and then double-click the AutoCalculate area to display the shortcut menu. |
|
Definition
|
|
Term
| 43. If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning. |
|
Definition
|
|
Term
| 44. When using in-cell editing, to delete a character or adjacent characters you can use the mouse to drag through the character or characters and then press the DELETE key or click the Cut button on the Standard toolbar |
|
Definition
|
|
Term
| 45. In Insert mode, Excel replaces the character to the right of the insertion point with the character typed. |
|
Definition
|
|
Term
| 46. In Overtype mode, Excel inserts the typed character and moves all characters to the right of the typed character one position to the right |
|
Definition
|
|
Term
| 47. The Redo button allows previous actions to be repeated |
|
Definition
|
|
Term
| 48. Press the SPACEBAR to clear a cell |
|
Definition
|
|
Term
| 49. To start a new, blank workbook, click the New button on the Standard toolbar or click the New command on the File menu and begin working on the next workbook. |
|
Definition
|
|
Term
| 50. The Type a question for help box on the right side of the menu bar lets you type free-form questions, phrases, or terms and responds by displaying a list of topics related to the question or terms you entered |
|
Definition
|
|
Term
| 1. __Microsoft Office Excel is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from W |
|
Definition
|
|
Term
| 2. When Excel starts, a(n) _taskpane, which is a separate window that enables users to carry out some Excel tasks more efficiently, displays on the screen. |
|
Definition
|
|
Term
| 3. A new blank workbook called Book1, such as that illustrated in the accompanying figure, is like a notebook and is created when Excel starts |
|
Definition
|
|
Term
| 4. Inside a workbook, such as that shown in the accompanying figure, are worksheets each of which has a name that displays on a sheet tab at the bottom of the workbook. |
|
Definition
|
|
Term
| 5. The intersection of a row and column in the worksheet in the accompanying figure is a(n) cell which is the basic unit into which data is entered |
|
Definition
|
|
Term
| 6. The cell reference E5 is a unique address that refers to the cell located at the intersection of column E and row 5, or where the mouse pointer is located in the accompanying figure |
|
Definition
|
|
Term
| 7. In the accompanying figure, cell A1 is designated the active cell because it is the one into which data can be entered. |
|
Definition
|
|
Term
| 8. In the accompanying figure, the horizontal and vertical lines on the worksheet itself are called gridlines and make it easier to see and identify each cell. |
|
Definition
|
|
Term
| 9. In the accompanying figure, the portion of the worksheet displayed on the screen is viewed through a(n) worksheet window |
|
Definition
|
|
Term
| 10. The menu bar is a special toolbar that includes menu names, each of which represents a list of commands. |
|
Definition
|
|
Term
| 11. A(n) menu is a list of commands that can be used to retrieve, store, print, and manipulate data on a worksheet. |
|
Definition
|
|
Term
| 12. When the mouse pointer is moved over a toolbar button or box, the name of the button or box displays below it in a(n) screentip. |
|
Definition
|
|
Term
| 13. When the Standard and Formatting toolbars display on one row, all of the buttons on either toolbar can be displayed by double-clicking the move handle on the left side of each toolbar. |
|
Definition
|
|
Term
| 14. As data is typed, Excel displays in the formula bar, and also displays the active cell reference in the Name box on the left |
|
Definition
|
|
Term
| 15. The status bar displays a brief description of the command selected in a menu, the function of the button the mouse pointer is pointing to, or the mode of Excel. |
|
Definition
|
|
Term
| 16. The auto calculate area the middle of the status bar can be used in place of a calculator or formula to view the sum, average, or other types of totals of a group of numbers on a worksheet. |
|
Definition
|
|
Term
| 17. With office speech recognition installed and a microphone, users can speak the names of toolbar buttons, menus, menu commands, list items, alerts, and dialog box controls, as well as dictate cell entries. |
|
Definition
| office speech recongition |
|
|
Term
| 18. If speakers are available, the speech playback functions of Excel can be used to instruct the computer to read a worksheet. |
|
Definition
|
|
Term
| 19. In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered text. |
|
Definition
|
|
Term
| 20. The autocorrect feature of Excel works behind the scenes, correcting common mistakes when a text entry is completed in a cell. |
|
Definition
|
|
Term
| 21. Excel’s sum function is used to add all of the numbers in a range of cells. |
|
Definition
|
|
Term
| 22. A(n) range is a series of two or more adjacent cells in a column or rectangular group or cells. |
|
Definition
|
|
Term
| 23. When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n) relative reference |
|
Definition
|
|
Term
| 24. The heavy border and transparent (blue) background that indicate a selected range is called a(n) see through view. |
|
Definition
|
|
Term
| 25. You format a worksheet to emphasize certain entries and make the worksheet easier to read and understand. |
|
Definition
|
|
Term
| 25. You format a worksheet to emphasize certain entries and make the worksheet easier to read and understand. |
|
Definition
|
|
Term
| 26. The font size specifies the magnitude of the characters on the screen and is gauged by a measurement system called points |
|
Definition
|
|
Term
| 27. The opposite of merging cells is splitting a merge cell, which is done by selecting a merged cell and clicking the Merge and Center button on the Formatting toolbar |
|
Definition
|
|
Term
| 28. A(n) autoformat is a built-in collection of formats such as font style, font color, borders, and alignment, which can be applied to a range of cells |
|
Definition
|
|
Term
| 29. A(n) embedded chart is a chart that is drawn on the same worksheet as the data. |
|
Definition
|
|
Term
| 30. The area of a worksheet where an embedded chart appears is called the chart location |
|
Definition
|
|
Term
| 31. A saved workbook is referred to as a(n) file |
|
Definition
|
|
Term
| 32. A printed version of a worksheet is called a(n) hard copy |
|
Definition
|
|
Term
| 33. The range of cells that is chosen to print is called the print area |
|
Definition
|
|
Term
| 34. An editing procedure called in-cell editing allows the contents of a cell to be edited directly in the cell. |
|
Definition
|
|