CSE EXAM - Name: _ Student #: _ Section: _ York University...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Name: __________________________________________ Student #: _________________________ Section: ______ York University Faculty of Science and Engineering Department of Computer Science and Engineering CSE1520.03 - Computer Use: Fundamentals Winter 2006 Final Examination Sunday, April 9, 2006 Instructions: 1. York University examination rules are in effect. 2. Answer ALL questions by filling in the appropriate letters on the answer sheet provided using an HB / No. 2 pencil . Your answers are machine marked so be sure to fill in the bubbles very carefully. Also circle your answers on the examination paper as backup. 3. No aids allowed . In particular, the use of calculators is NOT permitted. 4. There are 22 pages (including cover page) with 100 equally-weighted questions. Check that your question paper is complete. 5. Time allowed is 3 hours. 6. Be sure your ID is coded correctly on the Scantron sheet 7. Both the question sheets and the answer sheet must be submitted together .
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2006 CSE1520 - Final Examination EXCEL FUNCTION LIST SUM (range) MIN (range) MAX (range) AVERAGE (range) MEDIAN (range) SIN (number) TAN (number) COS (number) PI () COUNTIF (range, criteria) RAND () ROUND (number, num_digits) ROUNDUP (number, num_digits) IF (logical_test, value_if_true, value_if_false) AND (logical1, logical2, …) OR (logical1, logical2, …) NOT (logical) TRUE () FALSE () LEFT (string, number_of_characters) RIGHT (string, number_of_characters) MID (string, start_char, num_chars) STDEV (number1, number2, …) LOOKUP (lookup_value, lookup_vector, result_vector) YEAR (serial_number) NOW () TODAY () COUNTIF (range, criteria) SUMIF (range, criteria, sum_range) VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) HLOOKUP (lookup_value, table_array, row_index_num, range_lookup) MATCH (lookup_value, vector) MOD (number, divisor) INT (number) INDEX (array, row_num, col_num) Page 2 of 22
Background image of page 2
Winter 2006 CSE1520 - Final Examination 1. This person played a key role in formulating the notion of programming the Analytical Engine to perform different functions. A. Blaise Pascal B. Rene Descartes C. Ada Byron D. Joseph Jacquard E. Gottfried Wilhelm von Leibniz 2. This person developed the first electro-mechanical tabulator, which read information from a punched card. A. William Burroughs B. Herman Hollerith C. Alan Turing D. John von Neumann E. Thomas Watson 3. Which of the following characterizes the second generation (1959-1965) of computer hardware? A. Transistors B. Vacuum tubes C. Silicon chips D. Large-scale integration 4. Integrated Circuits characterize which generation of computer hardware? A. first B. second C. third D. fourth 5. In which computer software generation did the distinction between systems and application programmers first surface? A.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

CSE EXAM - Name: _ Student #: _ Section: _ York University...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online