COMP 100 FINAL EXAM FA 02
6 Pages

COMP 100 FINAL EXAM FA 02

Course: COMP 100, Fall 2009

School: 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

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

DeVry Mesa - BIS - 315
BIS 315 Visual Basic Programming for BusinessSample MidtermStudent Name _ Section _ Date _ Fundamentals of Programming with Visual Basic (1) With Visual Basic you can write computer programs that run in the Microsoft Windows environment. Answer:
University of Hawaii - Hilo - TR - 012
0.0.0JCMT REMOTE OPS FMECA STUDY1cabc33b29d9d6a972830b95bb241d2eca9bcd1d.xlsSYSTEM INDENT LEVEL REF DRAWING OPERATIONAL MODE ID # ITEM FUNCTIONJCMT CAROUSEL X.0.0 JRBD000 CLOSE-UP IN BAD WEATHER FAILURE MODE CLOSED OPEN OPEN HALF OPEN FAILURE
University of Hawaii - Hilo - TR - 032
#%-12345X@PJL JOB @PJL SET RESOLUTION = 600 @PJL ENTER LANGUAGE = POSTSCRIPT %!PS-Adobe-3.0 %Title: I:\drawings\jcmt\j300\j313000a %Creator: Windows NT 4.0 %CreationDate: 15:20 4/1/1998 %Pages: (atend) %BoundingBox: 13 13 599 780 %LanguageLevel: 2 %D
University of Hawaii - Hilo - TR - 019
James Clerk Maxwell Telescope Technical Report No. 32.0Preliminary Design Study: ACSIS Infrastructure Requirements at the JCMTIan PainOriginal: 19.Mar.98 Issue 2: 30.Mar.98Joint Astronomy Centre 660 N. Aohoku Place, University Park Hilo, Hawaii
Millersville - BUAD - 341
BAUD.341 Managerial Finance I Syllabus Summer 2008General Information: McComskey 350 Office phone: 871-2273 Home phone: 284-1922 eric.blazer@millersville.edu www.millersville.edu/~eblazer/ Office Hours: Tuesdays and Thursdays 5:00 6:00 pm Wednesd
University of Hawaii - Hilo - TR - 032
ACSIS Correlator coolant requirementsFormulae: Heat transfer coefficientsource NATURAL Convection 1 ASHRAE 3.12 Table 5 IV (b) 2 ASHRAE 3.12 Table 5 IV (b) 3 ASHRAE 3.12 Table 5 IV (general) 4 ASHRAE 3.12 Table 5 IV (general) FORCED convection 5 Ge
Washington - PHARM - 560
UNIVERSITY OF WASHINGTONSchool of Pharmacy2001 Constituency SurveyThis questionnaire was faxed to 1124 Washington pharmacies in late July 2001 using the WSPA fax database. Our directions asked the recipient pharmacists to fax the survey back as s
Washington - PHARM - 560
Unequal Treatment: Confronting Racial and Ethnic Disparities in Health Care http:/books.nap.edu/catalog/10260.htmlSummaryABSTRACT Racial and ethnic minorities tend to receive a lower quality of healthcare than non-minorities, even when access-rel
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Purdue - EE - 255
Arizona - NATS - 104
Interesting facts about walnut flies (Rhagoletis juglandis) - This species lays eggs exclusively on walnuts, and larvae develop in walnuts In Arizona, adults emerge in late June at high elevations and lay eggs over a 4-5 week period, until fruits dis
Arizona - NATS - 104
According to natural selection, what are both females and males selected to do? Survive and reproduce Certain traits favor survival and reproduction. When those traits have a genetic basis, they are passed on to successful offspring. Genes that c
Arizona - NATS - 104
Quiz 4 KEY (9 points) Animal Sexual Behavior, Feb 13, 2003 Any one answer separated by / counts for full credit. E.g., bird / widowbird (either one counts) 1) What animal was studied in this experiment? (1 point) bird /widowbird / long-tailed bird/ E
Arizona - NATS - 104
Quiz 6-2, Article: What Good is Sex? R.E. Michod. NATS 104, February 27, 2003KEY1) Was the author discussing sex in terms of gender, the act of sex, or sexual reproduction leading to offspring? (1) sexual reproduction OR both act of sex and sexual
Arizona - NATS - 104
Quiz 13 (9 points). Reading: Judson, &quot;Till death do us part&quot; NATS 104, April 24, 2003 KEY 1) What are two things that you learned today from the lecture by Dr. Judson? (9 points) ANY ANSWER THAT SHOWED THAT YOU ATTENDED THE LECTURE AND ABSORBED SOME
Arizona - NATS - 104
NATS 104: Animal Sexual Behavior Feedback sheet for article reviews: If a category has a check next to it, then you may want to improve on that aspect for your next article review. Question 1: Hypothesis Need to include primary hypothesis of experim
Arizona - NATS - 104
NATS 104 (2003) Homework 2 (3 points). Due in lab Feb 10-12 1) Draw a graph of some of your data from the experiment your group conducted on guppies the week of Feb 3-5. The graph must be hand-drawn. Label both axes and give the graph a title (again
Arizona - NATS - 104
Quiz 8 Results Graphed by Responses from male and female students:If you could be the male of any animal in Dr. Tatianas book, what would it be and why?Wanttobeamaleofthisspecies:10 9 8 7 6 5 4 3 2 Numberofresponsesbysex 1 0 lion dolphin peacock
Arizona - NATS - 104
Work Sheet: Assignments and Points (Animal Sexual Behavior, NATS 104, Spring 2003) Points Possible 9 9 9 9 9 9 9 9 9 9 9 9 9 9 Top 12 quiz 9 9 9 9 9 9 9 9 9 9 9 9 All Grades Received Grades with Top 12 quizAssignment Quiz1 Quiz2 Quiz3 Quiz4 Quiz5 Q
University of Hawaii - Hilo - TR - 100
*** ** ** CCCC OOOO SSSS M M OOOO SSSS / M M ** C O O S MM MM O O S / MM
Maryville MO - CS - 303
CS 303Design and Analysis of Algorithms Review For Midterm Dong Xu(Based on class note of David Luebke)1 3/17/2004Mid-term12:55-1:55pm, Friday, March 19 Close book Bring your calculator 30% of your final score Office hours during March 15-19Do
Maryville MO - CS - 303
Mid-termCS 303Design and Analysis of Algorithms Review For Midterm Dong Xu(Based on class note of David Luebke)1 3/17/200412:55-1:55pm, Friday, March 19 Close book Bring your calculator 30% of your final score Office hours during March 15-19D
Taylor University - COS - 104
COS104 Exam IOctober 4, 20011.) A computer can be defined as: A) a programmable, multiuse machine that accepts data and processes it into information we can use. B) a programmable, multiuse machine that can turn information into raw facts and fig
University of Florida - STA - 3032
Ex2. A coin is tossed 10 times. Suppose the probability of head is 0.2. Let X be the no. of heads in the 10 tosses. Cumulative Distribution Function Binomial with n = 10 and p = 0.200000 x 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 P( X
E. Washington - CHAP - 327
static int iterativeRabbit(int n) {/ Iterative solution to the rabbit problem. / initialize base cases: int previous = 1; / initially rabbit(1) int current = 1; / initially rabbit(2) int next = 1; / result when n is 1 or 2 / co
East Los Angeles College - BS - 911
The Weight Watchers Diet The weight watchers diet was started in History of Diet1961 Jean had tested many FAD diets Attended free weight loss clinic lost 2 stone Found support from friends was useful for helping to lose weight and weight
Montclair - GEOS - 444
Tectonophysics 316 (2000) 287296 www.elsevier.com/locate/tectoNon-plume magmatism and rifting during the opening of the central Atlantic OceanJ.G. McHone *Graduate Liberal Studies Program, Wesleyan University, Middletown, CT 06459, USA Received 1
Montclair - GEOS - 444
Watchung Basalts (~201 Ma)3. Hook Mountain Basalt (~100 m thick; 2 flows) 2. Preakness Basalt (~300 m thick; 9-10 flows) 1. Orange Mountain Basalt (~200 m thick; 3 flows) Erupted all within ~600,000 years based on stratigraphic constraintsOrange M
Montclair - GEOS - 444
100.0010.00Column H Column I Column J Column K Column L Column M Column N Column O Column P Column Q Column R Column S Column T Column U Column V Column W Column X Column Y Column Z1.00 La Ce Pr Nd Sm Eu Gd Tb Dy Ho Er Tm Yb LuKd values oliv
Montclair - GEOS - 444
Three Phase Mixing Modelm(estimate) = [Gt x G]^-1 x Gt x dMatrix GSiO2 TiO2 Al2O3 FeO MnO MgO CaO Na2O K2O P2O5 daughter Cpx Opx 53.47 52.20 54.24 1.37 0.50 0.00 15.69 2.00 1.50 10.36 6.88 12.64 0.16 0.00 0.00 5.35 19.17 29.62 10.35 19.00 2.00 2.
Texas A&M - MATH - 647
International Journal of Food Microbiology 64 (2001) 247260 www.elsevier.nl / locate / ijfoodmicroOn the need for another type of predictive model in structured foodsE.J. Dens, J.F. Van Impe*BioTeC-Bioprocess Technology and Control, Department of
Texas A&M - MATH - 171
Exam 3, version A Math 171.501 4/23/09An unsupported answer is a wrong answer!1. (5 pts.) Give a precise statement of the hypotheses and conclusion of the Mean Value Theorem. 2. (15 pts.) Find the dimensions of the rectangle with largest area tha