EECS 1520 Study Guide - Midterm Guide: Turing Machine, Spreadsheet, Scantron Corporation
1 Oct 2018
School
Course
Professor
Name: _______________________________, ___________________________________
(Last name) (First name)
Student ID#: __________________________________
Registered Section: B
Instructor: Ali Mahmoodi
York University
Department of Electrical Engineering & Computer Science
Lassonde School of Engineering
EECS 1520.03 COMPUTER USE: Fundamentals
Test 1 (Solutions marked with x)
October 20, 2017
Instructions:
❖ This is an in class examination, therefore examination rules are in effect.
❖ This test uses multiple choice format for all questions.
❖ Choose the best response in case of more than one correct answer.
❖ Use the Scantron sheet provided to record your answer using a PENCIL.
❖ Make sure identification fields on the Scantron sheet are properly filled.
❖ Tests submitted without student numbers will NOT be marked.
❖ Answer bubble must be COMPLETELY filled in, and changes must be COMPLETELY erased
❖ NO markings on the form where the registration marks are (black bars)
❖ NO staples
❖ NO bending of the forms
❖ Fill in the box at the top of this page also, and print your Student ID#.
❖ Answer ALL questions:
❖ Time allowed is 50 minutes.
❖ Use of calculators is NOT permitted.
❖ There are 35 questions, and 7 pages including this cover. Please count them.
EECS 1520 Test 1 – Fall 2017 Section B
test-1520_Oct2017_2_solution Page 2 of 7
1. A _______________ is an interactive computer program for organization, storage,
and analysis of data in a tabular format where each row and column is labelled for
easy addressing.
a) Operating system
b) Turing machine
c) Compiler
d) Spreadsheet x
e) All of the above
2. In Excel 2010 spreadsheet the LOOKUP function can always be replaced by
equivalent
a) IF functions, sometimes leading to complex formulas x
b) SUM functions
c) AND functions
d) OR functions
e) All of the above
3. The Excel function used to calculate total expenses for a list of items is
a) AVERAGE
b) MAX
c) MEDIAN
d) MIN
e) SUM x
4. In Excel 2010, the cell E8 contains the formula =A3 . This formula is copied from
cell E8 and pasted into cell H9. What will the formula look like in cell H9?
a) =C3
b) =D4 x
c) =E5
d) =F6
e) =G7
5. _____________ is the first mechanical general-purpose computer.
a) Abacus
b) Jacquard’s Loom
c) Analytical Engine x
d) Difference Engine
e) ENIAC
6. _____________ is known as the father of modern information theory because of his
significant contributions to the theory of communication.
a) Charles Babbage
b) Steve Jobs
c) Claude Shannon x
d) Alan Turing
e) Ada Lovelace
54
EECS 1520 Full Course Notes
Verified Note
54 documents
