COMP 100 FINAL EXAM FA 02
6 Pages

COMP 100 FINAL EXAM FA 02

Course Number: COMP 100, Fall 2009

College/University: DeVry Mesa

Word Count: 1908

Rating:

Document Preview

COMP 100 Student Name Computer Applications for Business Group FINAL EXAM Date Choose from (a), (b), (c), (d) or (e) to answer the given question. The Windows Operating System (1) In the Windows environment, when a file is deleted from the C:\ drive, where is it placed? (a) Accessories (b) Recycle Bin (c) Desktop (d) Clipboard (e) My Computer To perform a search of all MS Word files located on the F : \ drive...

Unformatted Document Excerpt
Coursehero >> Arizona >> DeVry Mesa >> COMP 100

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

100 Student COMP Name Computer Applications for Business Group FINAL EXAM Date Choose from (a), (b), (c), (d) or (e) to answer the given question. The Windows Operating System (1) In the Windows environment, when a file is deleted from the C:\ drive, where is it placed? (a) Accessories (b) Recycle Bin (c) Desktop (d) Clipboard (e) My Computer To perform a search of all MS Word files located on the F : \ drive and residing within the SAMPLES folder, you would enter which of the following commands into the Windows Find utility? (a) F:\SAMPLES\*.ppt (b) F:\SAMPLES\*.xls (c) F:\SAMPLES\*.mdb (d) F:\SAMPLES\*.doc To determine the storage devices and printers connected to your computer, click the My Computer icon. (a) True (b) False To create a new folder on your Desktop, right - click an unused portion of your Desktop, left - click New , choose Folder and type a name for the folder.. (a) (5) . (6) True (b) False (2) (3) (4) The three dots, known as an ellipsis, in a menu item such as the Microsoft Page Setup... option, indicates that a dialog box will appear. (a) True (b) False Word. Within the Windows Explorer window, when files and folders are arranged by date, they are arranged such that which of the following is true? (a) (b) (c) (d) they they they they True are are are are arranged arranged arranged arranged by by by by the the the the current date date they were last modified day they were created day they were last used (7) (8) (9) To find a file by its name, you can use the Find utility found on the Start menu. (a) (b) False One keyboard shortcut to activate the Start button of your Windows (a) Ctrl - Alt - Del (a) (c) (b) Alt - Tab desktop is (e) Ctrl - Shift (c) Ctrl - Tab (b) (d) (d) Ctrl - Esc To copy a folder or file in Windows click File, then click Paste right - click and click Copy Explorer which of the following is performed? right - click and click Delete double - click the file icon (10) When Jane moves a file or folder in the Windows true? (a) the original is moved (c) a copy of the original is created environment, which of the following is (b) a shortcut is created and moved (d) a copy of the original is created and moved MS Word (11) When using MS Word, which shortcut key will center text? (a) Ctrl + C (b) Ctrl + H (c) Ctrl + E (d) Ctrl + K (e) Ctrl + A (C) Copyright 2001 by P.E.P. Page 1 of 6 COMP 100 Student Name (12) Computer Applications for Business Group FINAL EXAM Date Which MS Word menu item contains the option to Cut selected text? (a) Edit (b) Tools (c) Help (d) View (e) Table . (13) Which Word menu item contains the option to perform a Print Preview ? (a) File (b) Tools (b) red (b) red (c) Help (c) blue (c) blue (d) Insert (d) black (d) yellow (e) Table . (e) green (e) black (14) (15) (16) MS Word indicates possible grammatical errors with a wavy __________ line. (a) yellow (a) green MS Word indicates possible spelling errors with a wavy __________ line. Which Word menu item includes the option to perform a Spelling and Grammar... . check? (a) File (b) Tools (c) Help (d) Insert (e) Table . (17) Which Word menu item includes the option to Hide the Office Assistant ? (a) File (b) Window (c) Help (d) Insert (e) Table . (18) Which Word menu item includes the option Header and Footer ? (a) View (b) Window (c) Help (d) Insert (e) Table . (19) Which Word menu item includes the option to Change Case... ? (a) File (b) Edit (c) Help (d) Insert (e) Format . (20) Which of these MS Word menu options contain the option to Paste selected text? (a) Format (b) Insert (c) Window (d) Tools (e) Edit . (21) When using MS Word, if you mistype a word but the result is not a misspelling ( for example, typing "from" instead of "form" or "there" instead of "their" ), the spelling checker will not flag the word. (a) True (b) False (22) In a mail - merge operation in Word, the main document refers to the document that contains the text and graphics that are the same for each version of the merged document, for example, the return address or salutation in a form letter. (a) True (b) False (23) In Print Layout view, page boundaries, headers and footers, backgrounds and drawing objects do not appear. (a) True (b) False The following sentence appears in a word processing document. Which type of spelling checker error is apparent here? He reached for the book form the top of the shelf. (a) (b) dictionary limitation error error of context (24) (C) Copyright 2001 by P.E.P. Page 2 of 6 COMP 100 Student Name (25) Computer Applications for Business Group FINAL EXAM Date A thesaurus is software that offers synonyms and antonyms. (a) True (b) False MS Excel (26) Which of the following MS Excel functions is most likely used to determine a monthly mortgage payment? (a) MAX (b) PMT (c) SUM (d) COUNT (e) AVERAGE The spreadsheet program Excel 2000 will correctly calculate all of the following cell entries EXCEPT (a) (b) (c) (d) (e) (28) = A3 B5 + C12 = 2 B5 = A3 B5 + 8 = A3 500 50 110.50 (27) If B4 currently contains the number 6, B8 currently contains the number 0.50 and A12 currently contains the number 4.5, what value or text is returned by the following spreadsheet IF statement? = IF ( B4 > = 6 , B8 , A12 ) (a) 10 (b) 2.25 (c) True (d) 4.5 (e) 0.50 If the series of number symbols ###### appears in a cell for which you just entered a formula that returns a numeric value, then the column width needs to be increased. (a) True (b) False In MS Excel, portrait orientation prints a worksheet with the paper positioned so that it is taller than it is wide. (a) True (b) False You can receive Help MS from Excel by pressing the F1 function key. (a) True (b) False In a certain Excel worksheet, cell A1 contains a value of 200, cell A2 contains 50, cell A3 contains the formula = $A$1 + $A$2. In column B, cell B1 contains 150, and cell B2 contains 30. If the spreadsheet user copies cell A3 to cell B3, then cell B3 will have which of the following formulas? (a) = A1 + A2 (b) 250 (c) = $B$1 + $B$2 (d) = $A$1 + $A$2 A certain spreadsheet has the following values in the cells given below. A 1 2 3 4 B C D E (29) (30) (31) (32) (33) 2 3 2 3 10 8 0 -5 6 6 5 0 10 -5 10 3 -2 9 0 -5 What value will be returned by the following spreadsheet function? = SUM ( A2 : D4 ) - SUM ( D3 , E1 ) (a) 24 (b) 40 (c) 32 (d) 22 (e) 8 (C) Copyright 2001 by P.E.P. Page 3 of 6 COMP 100 Student Name (34) (35) Computer Applications for Business Group FINAL EXAM Date The auto sum button (a) True is located on the Standard Excel toolbar. (b) False When you sort a series of numbers from largest to smallest, you are sorting in descending order. (a) True (b) False How many cells will be totaled by the following Excel SUM function. (a) 20 (b) 10 (c) 19 (d) 24 (e) The spreadsheet function defined below, returns which of the following? = IF ( B1 > B2 , B1 - B2 , B1 * B2 ) (a) (b) (c) (d) the the the the product of cells B2 and B3 if cell B1 < B2 difference of cells B1 subtracted by B2 if cell B1 < B2 product of cells B1 and B2 if cell B1 > B2 difference of cells B1 subtracted by B2 if cell B1 > B2 = SUM ( E2 : F5 ) none of these (36) (37) (38) Joel wishes to compute his monthly mortgage payment using the formula shown below. What is the amount of his mortgage loan? = PMT ( 6 % / 12 ,360 , 180000 ) (a) $ 36,000 (b) $ 360,000 (c) $ 180,000 (d) $ 600,000 (39) A spreadsheet cell is basically (a) (b) (c) (d) the combination of a control unit and an arithmetic logic unit equivalent to one megabyte of memory the intersection of a row and column a twisted - pair model (40) Referring to an electronic spreadsheet, if B3 has a value of 150 and A2 equals 3.5, what value is computed in the cell having the formula that follows? = B3 - 4 * A2 / 10 (a) (b) (c) (d) (e) 733.50 103.60 148.60 14.52 none of the above Computer Concepts - The Internet (41) Which of the following is a legitimate prefix for a URL? (a) http:\\www. (42) (43) (44) (b) http://www. (c) http//:www. (d) http\\:www. Which of the following Internet domains is used for nonprofit organizations? (a) edu (b) gov (c) mil (d) org (e) net Which of the following is an Internet search engine? (a) VRML (a) com (b) URL (b) gov (c) Lycos (c) mil (d) Explorer (d) org (e) Boolean (e) edu Page 4 of 6 Which of the following Internet domains is used for commercial entities? (C) Copyright 2001 by P.E.P. COMP 100 Student Name (45) Computer Applications for Business Group FINAL EXAM Date A(n) _________________ is the software on the user's computer to access the Internet via the service provider using a graphical interface. (a) spreadsheet (b) ergonomics (c) browser (d) http (46) The World Wide Web ( WWW ) has been in existence since the beginning of the Internet. (a) True (b) False (c) HTML (d) CERN (e) TCP / IP Internet Web pages can be created using _______________ . (a) FTP (b) URL The __________ page is the term generally used to describe the first document that is displayed by a Web site. (a) home True edu (b) (b) (b) browser (c) False gov (c) mil (d) org (e) net active (d) opening (e) title The U.S. government considered the central authority of the Internet. (a) Which of the following Internet domains is used for network service providers? (a) (47) (48) (49) (50) MS PowerPoint The following questions refer to PowerPoint software and concepts / topics involving electronic graphics presentation, in general. (51) (52) When using Power Point, which of the following can be used to edit and change text? (a) Outline View (b) Slide View (c) Slide Sorter View (d) both (a) and (b) Some of the elements that should be included in a successful graphics presentation include the purpose of the presentation, the type of presentation, the audience and its needs and the format of the presentation. (a) True (53) (54) (a) (b) False (b) (c) Page Up (d) Home (e) Page Down . In the Slide Show view, which of these keyboard keys displays the previous slide? Which of the following provides design and content suggestions? (a) Slide Show view (c) design template (55) (a) Slide Sorter view (c) Outline view (b) blank presentation (d) AutoContent Wizard (b) Slide Show view (d) Normal view Which of the following provides the best environment for creating a presentation? MS Access (56) A field size can be assigned to which of the following data types? (a) text (b) yes / no (c) number (d) both (a) and (c) (C) Copyright 2001 by P.E.P. Page 5 of 6 COMP 100 Student Name (57) Computer Applications for Business Group FINAL EXAM Date Which of the sequences below represents the hierarchy of terms in a database, ordered from largest to smallest? (a) table, field, record, database (b) database, table, record, field (c) database, table, field, record (d) database, record, table, field Which view is used to add, delete or edit records in an Access 2000 table? (a) (c) the Design view both (a) and (b) (b) (d) the Datasheet view neither (a) nor (b) (58) (59) Which of the following would not be a good choice for a database primary key field? (a) Social Security number (b) Order Number (c) Zip Code (d) Part Number Each of the following is an Access data type except (a) Memo (b) Currency (c) Accounting (d) Text (60) (C) Copyright 2001 by P.E.P. Page 6 of 6
MOST POPULAR MATERIALS FROM COMP
MOST POPULAR MATERIALS FROM DeVry Mesa