The Firm | Meet the Staff | Where Are We? | News |
Gossip | New Tax Laws | Tax Help | Credit Courses |
Committees | Articles | CPE Courses | The Computer Show |
ACCOUNTING 116
MICROCOMPUTER ACCOUNTING
EXAMINATION IV
35 QUESTIONS, MULTIPLE CHOICE. USE THE SCANTRON SHEET PROVIDED. 1. Found at the top of the screen, under the pull-down menus, this area displays the cell pointer location. A. address line C. summary line B. prompt line D. cell pointer 2. Located to the right of the area in question 1, this area displays the data during input. A. address line C. summary line B. prompt line D. cell pointer 3. Located two lines below the area referred to in question 1, under the icon bar, this area displays the description of the macro menu options. A. address line C. summary line B. prompt line D. cell pointer 4. An area on the screen where data input is entered and displayed is called: A. address line C. summary line B. prompt line D. cell pointer 5. What is (are) the key(s) that function as command generator(s)? When used in conjunction with other keys, (a) command generator key(s) will form a command (for example, "^C" will usually get you out of a problem situation and return you to an earlier menu in the program): A. Control Key B. Alt (Alternate) Key C. Function Keys (F1, F2, etc.) D. All of the above. E. None of the above. 6. An area on the prompt line which is used to select a macro menu option is called the: A. macro menu pointer B. interactive macro C. macro menu D. macro menu options 7. A series of separate commands automatically activated with two keystrokes, selected from a menu within the control panel, usually requesting the user to input specified data, is called: A. an interactive macro C. a formula B. a function D. a command 8. A frequently used mathematical equation applied to a value or values. Examples of mathematical equations are square root, integer value of, absolute value of, cosine of, etc. The mathematical equation can also be applied to a group or range of values. Examples of this type of mathematical equation are sum of, average of, minimum of, maximum of, etc. A. interactive macro C. formula B. function D. command 9. Instructions for mathematical computations of addition, subtraction, multiplication, or division which may contain numbers, such as 13.56 or 2,700, or variables denoted by inputting a cell location, such as A14 or D3, where the value that has been entered into the cell is then substituted into the mathematical computation. The value produced by the mathematical computation is displayed by the spreadsheet. This item consists of numbers, mathematical operandi, and variables. A. interactive macro C. formula B. function D. command 10. Single operations or manipulations of the spreadsheet that are activated by pressing a single key ("/") which puts a menu of these operations at the top of the screen, over the pull-down menus and the icon bar. A. interactive macro C. formula B. function D. command 11. A spreadsheet feature that permits a spreadsheet to be saved to a file on disk. At a later date, the file can be retrieved from the disk and displayed on the screen to permit edits and revisions. A. Save File C. Scroll B. Range D. Print 12. A group of cells on the spreadsheet, determined by the user inputting cells representing the upper left and lower right corners of the group. All cells which are within the rectangular box formed by the two points are included. A. Save File C. Scroll B. Range D. Print 13. The act of moving the cell pointer around the spreadsheet. If the cell pointer is directed to a cell not currently displayed on the screen, rows and columns will be removed from the screen to permit the display of other rows and columns. A. Save File C. Scroll B. Range D. Print 14. A spreadsheet feature that permits the user to record any portion of the spreadsheet on paper or other physical hard copy medium. A. Save File C. Scroll B. Range D. Print 15. A spreadsheet print command that advances the paper in the printer to the top of the next page, or the next sheet. A. Page C. Vertical Title B. Horizontal Title D. Both Title 16. A spreadsheet command that prevents a portion of the spreadsheet from scrolling off the screen. All cells in the rows above the row where the command is input remain on the screen regardless of the position of the cell pointer. A. Page C. Vertical Title B. Horizontal Title D. Both Title 17. In order to display the input number 25512.40 as $25,512.40, you would use which of the following cell formats? A. US Dollar, 2 C. , Comma, 2 B. US Dollar, 0 D. , Comma, 0 18. In order to display the input number 25512.40 as $25,512, you would use which of the following cell formats? A. US Dollar, 2 C. , Comma, 2 B. US Dollar, 0 D. , Comma, 0 19. In order to display the input number 25512.40 as 25,512.40, you would use which of the following cell formats? A. US Dollar, 2 C. , Comma, 2 B. US Dollar, 0 D. , Comma, 0 20. The key located to the left of the space bar, used to access a macro menu: A. Control Key C. Esc Key B. ENTER Key D. Alt Key 21. The key used to enter data into cells and interactive macros: A. Control Key C. Esc Key B. ENTER Key D. Alt Key 22. The key used to clear incorrect input from an interactive macro, and remove the protected cell warning from the screen: A. Control Key C. Esc Key B. ENTER Key D. Alt Key 23. Which one of the following statements is NOT true? A. "Copy" is a non-destructive command. B. The default drive is the drive you are in. C. The command "DIR" directs the computer to the proper device to save. D. CD, MD, and RD are directory commands (DOS). E. MS-DOS stands for Microsoft Disk Operating System. 24. Storage devices include all of the following except: A. Disk Drives B. Tape Streamers C. Cassette Players D. RAM and ROM, internal E. Keyboards 25. Which of the following is a false statement? A. The path name is the path of the sub-directory. B. The backslash is used in subdirectories. C. Subdirectories make files easier to find on the hard disk. D. Subdirectories are created with the command MKDIR or MD. E. The ocmputer directory is found in the yellow pages. 26. Name the way(s) that one can change information (data) in a cell. A. Type new data over old data in the cell. B. F2 C. /RE D. Click the "Edit" pull-down menu and select UNDO or CLEAR. E. All of the above. 27. What happens when you hit the "Home" key? A. The cell pointer moves up one cell. B. The cell pointer moves left one cell. C. The cell pointer moves left one screen. D. The cell pointer moves up one screen. E. The cell pointer moves to the upper left corner of the spreadsheet. 28. If I am at cell B2 and I want to go to cell E5, I would hit: A. the right cursor key 3 times and the down cursor key 3 times. B. the down cursor key 3 times and the right cursor key 3 times. C. the F5 key, and then enter: E5. D. All of the above. 29. If the value in a cell is 1234.3456, and the cell is set to display currency format, then the cell's appearance in the display will be: A. 1234.3456 B. $1234.34 C. $1234.35 D. $1,234.34 E. $1,234.35 30. Using the 1-2-3 Classic menu, which of the following starts a command entry, A. / (slash) C. F2 B. F1 D. F5 31. Which command(s) will take the information from one cell and place it into another cell without changing the information in the original cell? A. Copy C. Replicate B. Move D. Delete 32. Which of the following keys activates the HELP screen: A. / (slash) C. F2 B. F1 D. F5 33. Which mode(s) must you be in to start entering data directly into a cell? A. Menu B. Wait C. Ready D. Point E. All of the above. 34. Which of the following characters at the beginning of an entry displays it as a LABEL, when it would otherwise be recognized as a VALUE by the spreadsheet? A. ' (apostrophe) B. " (quotation mark) C. ^ (caret) D. All of the above 35. What key would you hit to return to cell coordinates A1? A. END B. TAB C. HOME D. PAGE UP