MATH 206 Final, Spring 1997

Math 206 Final(Spring 97) Time : 5:00 PM Duration: ¥® minutes. Date : 19" of June 1997 Name ID# Section : Concepts And Terminology(25pts) 1) Answer by true or false: 1, (32*32) bytes = 1Kbytes . 22° Kbytes = 1 Terabytes . 1 bit = 8 Bytes . Main Memory is volatile . It’s possible to save a file on a CD-ROM. . A network is a group of interconnected computers. . Acompiler is slower than an interpreter. . The memory is often referred to as the brain of the computer. . A bit is a technical word for 0 or 1. 10. Before executing a program, it must be placed on the hard disk. 11. Acomputer game belongs to the Application Software Category. 12. The RAM is responsible for fetching instructions from hard disk to CPU 13. Machine Language is the language most commonly used by today’s programmers. 14. It is possible to use the screen as input and output device. 15. When a program is being processed the control is transferred from O.S. to CU. 2) Circle the right answer 1.A compiler a- translates a program written in a certain language into another written in a higher level language. b- translates a program written in a certain language into another written in a lower level language. c- translates an algorithm written in English into a program written in a specified programming language. 2.Instructions to be executed directly by the machine are a-Strings of assembly codes. b-Strings of 0’s and 1’s. c-Strings of a high level language. 3.An interpreter belongs to a category of software called a-Application Software b-Programming languages e-System Software 4.In a 100 MHz computer the clockcycle is the time interval needed by CPU to execute a-10* instructions b-10° instructions ¢-10? instructions 3) Define BRIEFLY the main components of the CPU MSWORD(20 pts) 4) Fill in the Blanks: 1. The key erases the characters to the right of the insertion point. 2. The white space between the text and the edge of the paper is the 3. Use the to find synonyms for common words. 4. The command removes text from the document and stores it in the clipboard. is used to create a . A(n) is a source reference or explanation displayed at the end of the page. gives you a raised character in a smaller font usually used in mathematical equations. . Windows pictures are stored under a folder called 9. is used to create a 10.Bold italic is a font 11.A continuous section break followed by a page break is equivalent to section break. 12.To change the line spacing of a paragraph, you go to >> . 13.To change the symbol used in a bulleted list, you go to >> . 14.The “send behind text “ button is used in creating 15.The is used to copy the format of text. 5) Answer by true or false a-It is possible to add borders to one word in a paragraph. b-It is possible to have the same page number for two different pages of the same document. c-Any command on the toolbars is found under one of the menus. d-It is not possible to have full justification (left and right ) for columns. e-Autocorrect feature can be used to insert symbols in a faster way MSEXCEL(35p' AS 6)What should you enter in the Name Box of the Formula Bar in order to select the following? 7)Answer by True or False: 1. You can not have 2 databases on the same worksheet. 2. can not be used to sort a database . 3. Autocomplete is the feature used when expanding a series over cells 4. The pattern *7* will only match numbers or text where the digit 7 appears in the middle. 5. Any number of data series can be represented by a pie chart. 6. It is not possible to select noncontinuous cell ranges in Excel. 7. It is not possible ,by any means, to sort a database by four fields. 8. When copied from cell D4 to cell F6 the formula “=B3*D2” becomes “=D5*F4”. 9. The “delete” Key on the keyboard corresponds to the “Delete” option on the edit menu. 10.This is a valid array formula {=(E5:E9)+100}.___ The following is the database used in Questions 8,9,and 10. fF 1 Top Drivers LastName FirstName __— Position Salary Birth Date Age 1 $250,000' 2 $100,000 1 $300,000 ] $150,000 2 1 = $100,000 $200,000) 2 | $75,000 yy 2 $150,000) 2 $150,000! 2 $78,000 2 a iotenderg avid $125,000] 93 1 8)Using an array formula compute the age of every person. Show the steps for creating the ; Do not show the result, do not write essays, specify actions and ranges only . 1. 2. 3 4 9)Filter all the pilots whose position is 2 and whose salary between $75,000 and $150,000.(Fill in the custom box if needed + any additional condition) stom AutoFilter 10)Describe the steps to filter all the pilots with salary between $75,000 and $150,000 and different from $125,000.(Hint: custom filter can not be used in this case)