Giovetti and Giovetti, Certified Public Accountants

The Firm Meet the Staff Where Are We? News
Gossip New Tax Laws Tax Help Credit Courses
Committees Articles CPE Courses The Computer Show

Examination IV

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
All contents of The Computer Show are Copyright © 1998 Joppa Computersbacktothetop.gif 1.65 K